| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2004-09-06 : 13:05:35
|
| Outside of DBCC REINDEX and DBCC INDEXDEFRAG commands. Should a windows DEFRAG be run occasionally on the database drive? Is there any DB performance benefit to defraging a hard drive and does SQL need to be stopped to defrag the DB?Sam |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-06 : 22:53:24
|
| You do need to shut off the services. Otherwise, the defrag would never work correctly. It's recommended to do it unless your enclosure or array does it for you. Many of the high-end enclosures and pretty much all the SAN's take care of it for you.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-09-07 : 00:12:55
|
| Thanks Derrick. I guess I'll have to find a convenient time (not) to stop the SQL Server for an hour or so.Sam |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-07 : 01:42:40
|
| I use the contig tool from www.sysinternals.com to defrag .dbf and .ldf files when they get too fragmented. btw, it is a free tool and it runs from the command line. -ec |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-09-07 : 08:59:47
|
| Interesting tools. Do you use any others regularly other than contig?Sam |
|
|
|
ze
Starting Member
5 Posts |
Posted - 2004-09-07 : 13:13:32
|
| Nobody has answered the main question yet,"Should a windows DEFRAG be run occasionally on the database drive? "Thanks,ZEze |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-07 : 13:21:30
|
quote:
Originally posted by ze
Nobody has answered the main question yet,"Should a windows DEFRAG be run occasionally on the database drive? "Thanks,ZEze
Derrick answered it already:quote:
It's recommended to do it unless your enclosure or array does it for you.
Tara |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-07 : 17:06:51
|
quote:
Originally posted by SamC
Interesting tools. Do you use any others regularly other than contig?
Yes, their entire suite of tools is indespensible. Some of the tools go a little out of the DBA realm, but are valuable nonetheless.I would say that the pstools collection, process explorer, filemon and regmon are tools that everyone should use and be somewhat familiar with.-ec |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-07 : 17:07:15
|
quote:
Originally posted by ze
Nobody has answered the main question yet,"Should a windows DEFRAG be run occasionally on the database drive? "Thanks,ZE
ummm, read the first reply.-ec |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-07 : 18:58:37
|
| I use all the tools they have. process explorer is really good.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
Disk Maintenance