I took over a shop that is running SQL 2000 on a Windows 2003 server. This guy is a DOG! I can tell that even though it seems to have addiquite memory and disk capacity, it is fragmented in the worst kind of way. At the disk level Windows says to defrag after running the analyzer. At the file level some of the files show to be 80-90% fragmented. Clearly this machine has not been defraged in over a year. I don’t have access to any fancy administrator software tools and have to make do with the Window tool.
What is my best approach to getting this DOG back to throwbread status?
Can I safely run Windows defrag during low usaged times (lunch or early in the AM) until I complete a full pass?
I would hate to use the scheduler and come in to find a big problem waiting on me.