SOURCE: Diskeeper Corporation

March 19, 2008 13:13 ET

The Right Defrag on SQL and Exchange Servers

The Right Defrag Keeps Your SQL and Exchange Servers Running at Maximum

BURBANK, CA--(Marketwire - March 19, 2008) - For most companies, SQL and Exchange performance are crucial to company operation. The database is the core of the enterprise "mind" and is constantly accessed and changed, and email has become the standard for corporate communication, both internal and external. Anything which assists the performance of both these elements -- such as defrag -- is therefore vital.

File fragmentation affects SQL and Exchange just as it affects all applications and file access. Interestingly, both these applications have specialized needs when it comes to fragmentation and defrag.

All SQL server databases, over time, experience what is described as "internal" fragmentation of data. A common method to address internal fragmentation is to use the DBCC REINDEX command to rebuild indexes. Once indexes are rebuilt, data pages are logically contiguous and disk I/O is minimized. Unfortunately, however, internal fragmentation is not the only kind of fragmentation suffered by SQL Server databases; they also suffer from "external" fragmentation -- meaning the database files themselves, and the space they require to expand into, are fragmented, also requiring additional I/Os for access. Database log files also become fragmented, affecting performance -- these are not addressed by the REINDEX command, either, and must be otherwise defragmented.

As with SQL server databases, Exchange databases also suffer from internal fragmentation and contain tools for addressing this problem (ESE and EDB utilities). But in a way similar to SQL databases, the "container files" which contain all Exchange data become fragmented and must be addressed by other methods.

A very popular method of defragmenting SQL and Exchange files is Diskeeper defragmentation software from Diskeeper Corporation. Database and log files defrag is performed by Diskeeper so that access is much smoother and faster. The same holds true for Exchange files -- once defragmented, it takes far less time for access to email. And in both cases response time is not only improved, but system reliability as well.

"The ability for Diskeeper to work with SQL and Exchange -- which typically tend to be bloated large files -- is a good addition to the product feature set," says Bill Bradley of Advanced Hospitality Systems of Vorhees, NJ. "Our goal was to improve response time and performance on our servers."

Advanced Hospitality Systems specializes in point-of-sale (POS) products and, in addition to using Diskeeper for their own systems, requires that Diskeeper be installed with every POS product deployed. "We provide it to our clients for the same reason we use it ourselves," Bradley says. "No maintenance to run and it gets the job done."

The "no maintenance" Bradley is referring to is Diskeeper's proprietary InvisiTasking technology, which allows Diskeeper to defragment completely automatically. The product uses only idle system resources and requires no scheduling at all.

Implementing and maintaining SQL and Exchange can require considerable work. Fortunately, basic performance maintenance through defrag is made as easy as possible with a fully automatic product such as Diskeeper.

Contact Information