This is the "before" picture. It's a Windows 2000 Small Business Server drive, running both SQL Server 2000 and Exchange 2000. It was also using Diskeeper 9 Server Standard, scheduled to do a defragment every weekend. The performance has got worse over time, and eventually I realised that Diskeeper just wasn't up to the job. The "before" picture above was taken after I had got Diskeeper to do a complete boot-time defragment and a full defrag to the best of its ability. As you can see the drive is in a mess.
This is the drive after the first pass using PerfectDisk 8. The analysis recommended a boot-time defragmentation, but we couldn't do it straight away because the server is in use. As you can see from the picture there is still a lot of fragmentation, and the metadata is in a real mess, with close to 1000 fragments in total. Thanks for nothing, Diskeeper!
Finally, after doing two boot-time defragmentation passes, and a complete defragment overnight, and then a quick pass using contig, the drive is in much better condition.
The other thing I like about PerfectDisk is that it has a "batch file" mode called PDCmd, so you can run a batch file that cleans up unwanted files using Hunter-Killer, then stops the SQL Server service, does a complete defagmentation, and finally starts the SQL Server services again. All automatically and unattended. Remember this is a live server, with SQL Server making backup files from time to time, and users saving documents from their workstations. Even so, the drive is in much better shape and SQL Server is performing well once again.
1 comment:
Wow! You do have perhaps one of the planet's most thorough defragging strategy.
Thanks for opening my eyes on the goodness of PerfectDisk. I had been a user of Diskeeper, but I truly dislike DK's insisting of 20% free space. I uninstalled DK, got PD, and run with it. All is well, but I'm still worried.
Thanks to the shootout I'm now perfectly content with PD. And your defragging of a live server strategy is also wonderful. Can you tell me more about it? Perhaps a blog entry detailing it?
Thanks again for a nice blog!
Post a Comment