May 9, 2002 at 3:38 am
Hey all,
Just a quick question. Do any of you defrag your SQL Server files at all? Not talking about defragging tables etc. The network guy here was wondering if he should be scheduling defrag's on the SQL Server boxes as he does with other servers?
Anyone had any issues with using a defrag tool such as diskeeper?
Cheers,
Clive
Clive Strong
May 9, 2002 at 5:27 am
I have tested with Diskeeper and say it is a great utility and only saw issues when server load was high (note: Windows 2000+ defrag utility is based on Diskeeper but a stripped own version). As for defragging with a standard utility I do not suggest while the server is active. The reason is SQL locks the files and these utilities will clock sometimes for long periods. They also generally do not actually complete the defrag in full. However Diskeeper itself uses a method, which you can find details on their site, which is able to reorganize without being to intrusive. Currently I do not use diskeeper (no money) but would based on the trial version I tested, I do mine manually at times when I can shutdown SQL. Overall speed and performance do increase but a note that can make this a long term thing. If you know a file will grow by a rough amount before the next defrag then icrease the size just before shutting done SQL (also do with TL files). This way when you defrag the file will remain contiguos longer as it does not have to allocate new space before the next defrag.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply