Defrag SQL Server

All
Should the drives where the SQL Server data and log files be defragmenetd on
a regular basis?
ThanksNot unless you overuse autogrow and shrink. OF the database files weren't fr
agmented when you
created then and if you only had a reasonable amount of grow operation per d
atabase file you
wouldn't have fragmented database files. Some info here as well:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David" <David@.discussions.microsoft.com> wrote in message
news:B33CE701-AA9C-4AAC-ADBC-6E7AEEEB5645@.microsoft.com...
> All
> Should the drives where the SQL Server data and log files be defragmenetd
on
> a regular basis?
> Thanks|||Hi David
To add to Tibor's comments. To defragment the disc you would need to stop
SQL Server if you are using the defragmenter supplied with windows, on many
production systems this is not an option. Products such as Diskkeeper can do
this while the server is running.
For a server dedicated to SQL Server you should not need to do this if the
initial file sizes are sufficient and you don't continually shrink the files
.
Make sure that you have regular log backups to enable the log file to be
re-used and keep the log file size more constant.
If you are running SQL Server on (say) a development machine or
demonstration system, defragmenting can be very beneficial, I have seen
performance improvements of around 30% just by defragmenting the disc on suc
h
systems.
John
"David" wrote:

> All
> Should the drives where the SQL Server data and log files be defragmenetd
on
> a regular basis?
> Thanks