RE: Using Diskeeper 8.0 with SQL Server 2000

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 04/07/04 

Date: Wed, 07 Apr 2004 01:54:30 GMT

Hi Guillaume,

Generally, the Defrag programs that come with the OS or purchased from
other vendors will move clusters of data around on the drive to make them
contiguous and files can be read quickly. When a drive is fragmented, files
are read from many locations on the drive which causes wear on the motor
that moves the head. Having files where all the data is together is thus
beneficial to the life of the hard drive.

It can be a possibility of corruption that might lead due to defrag on
server that has SQL Server installed. But there are mechanisms in place to
prevent that where it is possible to prevent it. Defragment programs check
the drive for errors on the File system before running. When a Cluster is
moved from one location to another, the new data is checked to see if it
matches exactly with the old data before the old data is erased and the
cluster is marked as FREE. But based on this, we cannot guarantee 100%
corruptionless scenarios as data loss can still occur for physical reasons
(Power interruption, drive errors, bad write and undetected error). The
possibilities are considered very slight and can be negligible if a backup
of the data is also created on a regular schedule.

I found the following article for your reference.
Keeping Your SQL Server Databases Defragmented with Diskeeper
http://www.sql-server-performance.com/sql_fragmentation.asp

I am looking forward to hearing from you soon.
Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.

Relevant Pages

  • RE: Using Diskeeper 8.0 with SQL Server 2000
    ... >server that has SQL Server installed. ... >cluster is marked as FREE. ... >Microsoft Online Partner Support ...
    (microsoft.public.sqlserver.server)
  • Re: OnlineClusterResource failed - SQL 2000 on Windows 2003 Server
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... Changed all Cluster Resources, as per the Microsoft article ...
    (microsoft.public.sqlserver.clustering)
  • Re: Finding the Active Cluster Node
    ... Columnist, SQL Server Professional ... One option would be to use the cluster.exe command line utility ... Say my cluster name is MyCluster and I want to know the node name ... Microsoft highly recommends that users with Internet access update their ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 and SQL 2005 on the same Cluster
    ... Definitely read the section on Limitations of using mixed SQL Server 2000 and SQL Server 2005 failover cluster instances. ... The Microsoft SQL Server support policy for Microsoft Clustering ...
    (microsoft.public.sqlserver.clustering)
  • RE: Main requirements per A-A model
    ... > clustering is different with SQL Server 2000, using the active/active terminology does not really apply. ... > A single-instance cluster has only one active instance of SQL Server owned by a single server node, and all other nodes of the cluster are in a wait state. ... unless your disk subsystem supports multiple logical drives on one physical drive set. ... > Microsoft Whitepaper - SQL Server 2000 Failover Clustering ...
    (microsoft.public.sqlserver.clustering)