SANsymphony for Microsoft SQL Server
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 storage hypervisor includes critical features which make it an ideal storage platform to leverage the benefits of Microsoft SQL Server, including:
DataCore’s SANsymphony 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.
Benefits of DataCore and Microsoft SQL Server
DataCore’s intelligent storage hypervisor software enables enterprises to radically improve the efficiency, performance and availability of their storage infrastructure through virtualization, transforming disparate storage resources into a unified and efficient infrastructure that is flexible, fast, reliable and scalable.
Key benefits include the ability to:
- Optimize performance and create a high-performance pool of virtualized 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 utilization 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 SQL Server Case Studies
Ports of Auckland
Download Case Study
“We’ve been able to support far more virtual machines and far more I/O requests than the IT team had originally expected” - Craig Beetlestone, lead systems engineer at Ports of Auckland. The company’s Microsoft Exchange email system is mission-critical, it carries the Electronic Data Interchange (EDI) communications, instructions from shipping lines and other customers, and other time-sensitive information required for port operations. Ports of Auckland, New Zealand’s leading port and cargo logistics company is also a heavy user of Microsoft SQL Analysis Services and SQL Reporting Services for business analysis and Microsoft SharePoint for collaboration.
The MLS (The Multiple Listing Service)
"Since we started using DataCore to virtualize storage for our tier 1 applications, we got back on track with our virtualization project," said Pablo Palma, information technology manager at The MLS™, a US real estate advertising and marketing service company. "Before that, I/O bottlenecks and the pesky outages were hitting us at every turn, especially with our web servers, file servers and SQL database servers. Now we can handle about 300% more transactions than before -- all on the same hardware. Moreover our disk pool is completely redundant, giving us the opportunity to upgrade and expand without taking users down."
SANsymphony and Microsoft SQL Server Resources
ESG Lab Validation Report: SANsymphony
This ESG Lab Validation documents the results of hands on testing of DataCore SANsymphony Storage Virtualization Software. The goal was assessing the value of infrastructure-wide storage virtualization including centralized management, ease of use, capacity efficiency, data mobility, and performance.