OCZ has released yet another whitepaper released at the Storagemagazine.co.uk and written by Dr. Allon Cohen from OCZ Technology Group on the topic of how flash virtualization can help businesses get the most out of MS SQL Server 2012.

In a rather lengthy paper, Dr. Cohen takes a look at the latest release of Microsoft's enterprise DBMS that includes new features and enhancements that improve database availability, simplify the moving of databases between instances, employ more productive management and development tools, and provide significant enhancements in performance, programmability and security and how it can be actually used by combining PCI-Express based SSDs and VXL software in order to get the full potential of SQL Sever 2012 in virtualised data centers.

Since databases are mostly limited by IOPS performance as well the logical choice is to go with flash solution that dramatically increases IOPS performance as well as reduces read latencies, query completion times and bring flash virtualisation and data caching to increase application performance and data access. According to OCZ, a combination of OCZ Z-Drive R4 SSD and VXL caching and virtualisation software can bring up to 1700% improvement in query processing.

The paper also explains the benefits of caching tempDB on flash, Automatic detection/caching of frequently accessed DB pages, as well as dividing DB tablets between different file groups and retaining log files on mirrored flash volumes.

The implementation of such OCZ hardware/software solution fixes all the issues that virtualised server deployments allowing for even heavy application loads, such as SQL Server 2012. The result is a dynamic, high-performance environment capable of handling the ever increasing storage loads and requirements typically associated with enterprise data centers and cloud environments.




Source: OCZ.com.