Condusiv Technologies Server Solutions

SQL Server Database Performance

How do I get the most performance from my SQL Server?

One of the biggest hardware bottlenecks for any SQL Server is disk I/O. Anything a database administrator can do to reduce the amount of I/O necessary to complete a task will increase that server’s performance.

SQL Server Some of the most common things DBAs often resort to are:

  • Tuning queries to minimize the amount of data returned.
  • Using fast disks and arrays.
  • Using lots of RAM so more data is cached.
  • Frequent DBCC REINDEXing of data to remove logical database deleted or inactive files.

But none of these actions will prevent hardware bottlenecks that occur due to the surplus of unnecessary I/O. In order to get the most performance from your SQL Server, you need an operating system utility, not a SQL Server utility.

V-locity® I/O optimization software uniquely addresses the unnecessary I/O patterns of reads and writes by aggregating data on writes to perform sequentially while caching reads on available server memory without contention to the application. As a result, V-locity boosts application performance by 50% or more by (1) maximizing the efficiency of every single I/O from write requests that leave the server and (2) caching the most active data from read requests using available server memory.

Read I/O Optimization – Much of the I/O traffic moving through the infrastructure shares similar data, yet every byte of that data travels the entire distance from server to storage and back for every I/O request, even when it is frequently accessed data. IntelliMemory technology addresses this read request inefficiency by caching the most active data in the server’s available memory. Should an application require more memory, V-locity serves memory back to the application to ensure there is never a case of memory starvation or resource contention. Condusiv Technologies’ self-learning caching algorithms have set the gold standard for the industry as they are OEM’d by eight of the top ten largest PC manufacturers in the world.

Write I/O Optimization – V-locity’s IntelliWrite® technology optimizes I/O write operations, eliminating the performance penalties associated with the Windows OS, splitting files into pieces and writing each piece to a different logical location within the SAN or NAS. V-locity is aware of space allocation and aggregates writes to behave sequentially—requiring less I/O for every file written. Subsequent reads also benefit, since only minimum I/O is required to fulfill the request. As a result, only productive I/O requests are processed across the entire infrastructure, enabling more data to be processed in the same amount of time.

When only productive I/O traffic is processed through the server, network and storage, I/Os per second are accelerated, latency is greatly reduced, and more work can be performed in the same amount of time. This greatly improves the efficiency of all VMware ESX/ESXi and Microsoft Hyper-V virtual platforms and physical servers for increased bandwidth.

V-locity I/O optimization is tailored for virtual environments that leverage a SAN or NAS as it proactively provides I/O benefit—improving storage performance and benefiting advanced storage features like snapshots, replication, data deduplication and thin provisioning. Since V-locity optimizes I/O at the server level, it is complementary to all SAN and NAS storage systems and media types (e.g., HDD or SSD).

Download a trial of V-locity and put it to the test in your real-world environment »