So I have been researching for a couple weeks, read through this forum (most informative place minus a couple white papers), and am looking for final input while starting forward.
I just got into a server system with roughly 1.5 TB data, split between 1 Raid 10, 2 Raid 5s and a Raid 1 OS and Raid 1 other. The file autogrowth on many databases is set to very small numbers and needs to be changed. I have seen I/O bottlecks almost right away and CPU bottlenecks that could be stemming from poor fragmentation. I cannot even run a check on internal fragmentation (index/table/other) because the I/O it takes to do a full index report will take up too many resources. SAS Raid systems.
I have been talking to the Network staff and the drives are most likely very fragmented. Can't even risk the frag analysis at normal operation times. There had been log files that had auto growth and not backed up or maintained and took up disk.... I'll sum it up. Drives fragmented, looking at fix. Going to push forward on testing with PerfectDisk, looking to see if anyone would have any better info.
I have seen a lot of posts with DisKeeper (55) only only few with PerfectDisk on this forum. I have looked over free utilities as well but these two always hit on topic for server level, SQL Server cannot be taken down, manage everything well... etc.
Anyone ever do a direct comparison or have good stats on either individually? DisKeeper better? PerfectDisk better? Advantages from one over the other based on server specs?
Raxco got my attention with this (http://www.raxco.com/user_data/white_papers/unique_differences_pd11_dk2010.pdf) paper that pushed me to discuss with Net and agreed to put the trial version on our test server. Also, the S.M.A.R.T. capabilities are a plus for Net. DisKeeper has more input from actual users saying success and good throttling control while SQL server runs continuosly.
If you put all that together, thanks, and for any feedback.