SOURCE: Diskeeper Corporation

December 09, 2009 13:30 ET

Preventing Fragmentation on SQL Server Databases

BURBANK, CA--(Marketwire - December 9, 2009) - A database is the heart of a company's business activities. It is where customer, finance, inventory and other vital data is stored, manipulated and provided so that the company can run smoothly. Hence it is in a company's best interest to have a database that runs at top speed.

File fragmentation slows any process down. It's worse with SQL Server databases, for they suffer from not one, but two types of fragmentation: internal and external. Internal fragmentation occurs when records are removed from database pages, but the space they occupied are still there after deletion. Eventually this space is reused, but as it is reused, the data pages become fragmented, which can lead to unnecessary I/Os, especially in case of table scans where many data pages are read, one after another.

One method for handling internal fragmentation is to use the DBCC REINDEX command to rebuild clustered and non-clustered indexes. Once indexes are rebuilt, data pages are now logically contiguous, and disk I/O is minimized.

This command does nothing for external fragmentation, however. SQL Server databases are made up of large database and log files that are pre-allocated in size at the point of their creation. If there is enough contiguous empty space on disk when the original files are created, then they will not be fragmented. But even if the original database and log files are not fragmented when they are first created, they will almost certainly become fragmented as the database grows over time.

Previously, external fragmentation could only be addressed with a defragmentation utility. Today's most modern approach, however, is with Diskeeper® Performance Software -- the only product available today that actually prevents fragmentation before it happens.

"I can tell you that, with Diskeeper, the seek time for data has given us a response now of 369,000 records of information from a query in 4 seconds out of a data file that is roughly 32 gigabytes, and is accessed by 150-plus employees every minute," said Brandon Butler, IT Manager with Professional Medical Services of Fort Worth, Texas.

Utilizing a new revolutionary technology called IntelliWrite™, Diskeeper 2010 intelligently writes files to the disk to prevent up to 85 percent of fragmentation from occurring. Coupled with Diskeeper's superior defragmentation technology, Diskeeper 2010 delivers a complete performance solution and goes far beyond what defragmentation alone can achieve.

"Ever since we deployed Diskeeper in our location we have seen great improvements with speed on our systems," Butler added. "I am very pleased with the product. We have it deployed on SAN solutions as well."

Diskeeper 2010 keeps a company's database running at maximum performance -- so the company can, too.

Contact Information