Diskeeper Can Boost Your SQL Server's Performance

Overview

One of the biggest hardware bottlenecks of any SQL Server is disk I/O. And anything that a DBAs can do to reduce SQL Server's use of disk I/O will help boost its performance. Some of the most common things DBAs do to reduce disk I/O bottlenecks include; 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 fragmentation. Another less frequently used method to reduce overall disk I/O, but nonetheless important, is to perform physical defragmentation of SQL Server program files, database files, transaction logs, and backup files.