Diskeeper on SQL Files 1

[klewis10367]

Should I run a defragmenting tool like diskkeeper on my SQL data files? I am running a sql 2005 database and Windows 2003 SP2 OS.

 

[mrdenny]

No, it won't be able to do anything. SQL Server locks the files so that nothing else can access them.

If you need to defrag the databases you'll need to stop the SQL Service, then defrag the files.

This will give you a small performance benefit if anything. It usually isn't worth the downtime.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[klewis10367]

Thank You.