Databases are one of the most demanding applications in terms of their need for performance and high-availability due to the enormous volumes of data and transactions they typically store and use. DataCore’s SANsymphony-V storage hypervisor includes critical features which make it an ideal storage platform to leverage the benefits of Microsoft SQL Server 2012, including:
· · Powerful centralised storage management under a single pane of control with an intuitive graphical user interface and automated wizards that implement best practices
· · Automated storage tiering to maximize price/performance of available storage assets
· · Adaptive caching for performance acceleration
· · Thin provisioning for space efficiency
· · Synchronous mirroring for high-availability
· · Low-impact online snapshots for high-speed disk to disk backup
· · Pass through disks for non-disruptive migrations
· · Continuous data protection (CDP) for any point in time backup and recovery
· · Unified storage for managing file shares (NAS) and SANs
Microsoft SQL Server 2012 helps address the challenges of increasing data volumes by rapidly turning data into actionable business insights. It expands on Microsoft’s commitment to help customers manage any data, regardless of size, both on-premise and in the cloud. Customers choosing SQL Server 2012 enjoy the benefit of a rich hardware and software partner ecosystem that enables solutions for the most unique and demanding data management needs.
An Ideal Platform for SQL Server 2012
DataCore’s SANsymphony-V abstracts and presents disk storage from different devices to applications as a shared pool of resources. With an ability to process multiple database requests in tandem, the system can absorb random I/O spikes. Built-in adaptive caching fully leverages available memory to boost I/O performance of both read and write traffic. Database administrators (DBAs) have the option of using flash memory/SSDs, high-speed arrays, capacity disks or even cloud storage, all of which can be managed and auto-tiered efficiently by the storage hypervisor. Automated tiering also ensures highly active data files don’t compete with inactive blocks of data for I/O cycles. Additionally, transaction logs and other active data can remain on Tier 1, while backups and other inactive read-only data move to lower tiers.
DataCore also empowers high performance flash and SSD-based storage systems from alliance partners Fusion-IO, Texas Memory Systems, Violin, Savage IO, X-IO Technologies and other SSD vendors to deliver the very best price/performance to meet the needs of demanding SQL application workloads.
For SQL database protection, DBAs can schedule ongoing space-efficient snapshots with application-aware recovery points, or utilise DataCore’s CDP feature to capture and log all changes and allow recovery back to any point in time versus to a specific snapshot image.
Key Benefits for Database Applications
DataCore’s intelligent storage hypervisor software enables enterprises to radically improve the efficiency, performance and availability of their storage infrastructure through virtualisation, transforming disparate storage resources into a unified and efficient infrastructure that is flexible, fast, reliable and scalable.
Key benefits include the ability to:
· · Optimise performance and create a high-performance pool of virtualised storage for SQL databases, eliminating most storage-related I/O bottlenecks for business-critical applications.
· · Provision virtually any size volumes for SQL applications upfront, and increase utilisation and I/O capacity on the fly.
· · Balance cost and performance by storing transaction logs and active data files on higher performance storage devices, while moving backups and inactive data files to lower cost higher capacity drives or cloud storage.
· · Continuously protect databases against downtime and disaster with stretch high-availability design to maximize business continuity.
· Scale storage for throughput, transactions and capacity that meet the needs of applications.
· Automate and simplify storage management that has been integrated and tested “DataCore Ready” with SQL Server.
DataCore and Microsoft
DataCore has been developing innovative storage virtualization solutions designed specifically to work on Microsoft platforms for nearly 15 years. It is a longtime and active member of both the Microsoft Partner Solutions Center and the Microsoft System Center Alliance.
“DataCore remains committed to creating solutions designed to enhance the capabilities of Microsoft platforms and can virtualise and manage enterprise-class storage environments with ease and efficiency,” said Carlos Carreras, vice president of alliances and business development for DataCore Software. “SANsymphony-V’s rich capabilities, such as auto-tiering and thin provisioning, efficiently handle extensive demands placed on storage environments by intensive database applications. Together with SQL Server 2012, DataCore is enabling enterprises to have the robust storage infrastructure critical to attaining maximum returns on their virtualisation, cloud and database investments.”
DataCore has worked with Microsoft technologies since it was founded in 1998. The company has deployed over 20,000 systems around the world leveraging the technology, many with highly intensive database applications. DataCore users are also already experiencing some of the benefits of Microsoft SQL Server platforms because Express Local Edition is integrated into SANsymphony-V to store historical performance data.
DataCore customers represent a broad spectrum of IT organizations, spanning all major vertical industries, and ranging from large enterprises to small and midsize business. Their physical environments consists of systems from all the major storage manufacturers, including Dell, EMC, Fujitsu-Siemens, Hitachi, HP, IBM, NetApp, and many others.
Tags: Storage Virtualization