SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


PerfectDisk Vs DisKeeper


PerfectDisk Vs DisKeeper

Author
Message
matt.newman
matt.newman
Old Hand
Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)

Group: General Forum Members
Points: 338 Visits: 473
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.
-Me
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32529 Visits: 18556
I have used both of them and there is no real comparison. PerfectDisk by far outperforms DisKeeper.

Unfortunately, if you have heavy fragmentation at the OS level - you would need to stop SQL Server for proper disk defrag using any util.

You may want to look into getting approved outages to defrag the drives.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87775 Visits: 45272
If you get Diskeeper, patch it to the latest version immediately. Some of the older versions have nasty corruption- or error-causing bugs

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62975 Visits: 19111
Haven't tested them together, but both have worked for me. I have been hesitant to use them without stopping SQL Server. Even then, make sure I have 2 backups, just in case.

I'd schedule an outage, like Sat night/sun am, try to defragment as much as you can. Or at least analyze and see if you have lots of log/data file growths. Maybe think about a shrink of the log and then a controlled growth of files after defragmentation.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Brandie Tarvin
Brandie Tarvin
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14678 Visits: 8998
Don't forget to "fix" SQL Server after your OS defrag. Check your indexes to see if they need to be defragged (because a hard drive defrag will move your SQL files around once you've stopped the services) and update your statistics after fixing any index problems.

I'm probably just being anal, but IMHO, it's never a good idea to defrag hard drives without doing SQL Server housekeeping afterward.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
matt.newman
matt.newman
Old Hand
Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)

Group: General Forum Members
Points: 338 Visits: 473
Thanks all. 1 PerfectDisk, 1 not DisKeeper and 1 Neutral leans me in that I was going the correct path for the current needs.

I have been trying to avoid the maintenance window, but due to the drives being online for about 3 years with no real fragmentation statistics I will be looking to go for the maintenance window over slow time. The biggest problem I had is that there are no analytical tools going for WHAT is the peak usage time on that server. The Net guys are working to get Ignite going so I can get that data. It was preferred that I get use that software as opposed to perfmon and my own SQL server level monitoring tools I developed as it will give the usage store in an independant server. Thanks for the posts on that, it gives good reassurance when I take the window to Net and Dir of IT.

We have the perfect opportunity here to test out the S.M.A.R.T. capabilities on the new test server for drive monitoring. I have not seen anything like this around the DisKeeper application.

Just a few other Qs in case the answers are known:
Does DisKeeper have any analysis tools as part of it other than fragmentation that would otherwise not be listed on their site (drive health monitoring, disk usage reporting, other reporting)?
Does PerfectDisk have the same throttle control capability (and as good of one) that I have heard DisKeeper is good at, as to not pool all resources or allow other processes resources first?
Does anyone leave either application running for preventative fragmentation ability they both have ON, 24/7 and if so are there any statistic that would lead to believe that it would put extra wear on spidles and heads?

Side note is if anyone knows of any defrag utility for server environment supporting Raid drives on large (over 1 TB) systems that also has S.M.A.R.T. capabilities, I would love to hear the name and do some research into. I am concerned that the head movement over the years could weaken the drive stability so the analytics on that and any advanced notice I could get would be of help.

Thanks again!
-Matt
dragonette1218
dragonette1218
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 1
Regarding your PerfectDisk throttling question, yes, PerfectDisk has throttle control for their guests and hosts – they call it Virtual Awareness. And they also have CPU throttling for non-virtual as well.
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10378 Visits: 13687
GilaMonster (6/9/2011)
If you get Diskeeper, patch it to the latest version immediately. Some of the older versions have nasty corruption- or error-causing bugs


+1

---------------------------------------------------------------------
matt.newman
matt.newman
Old Hand
Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)Old Hand (338 reputation)

Group: General Forum Members
Points: 338 Visits: 473
Thanks George and Dragonette.

Dragonette, I am curious if the throttling control is as good as the DisKeeper mechanism. I have heard very positive remarks to DisKeeper's ability but have not heard anything about PerfectDisk's throttle capabilities. Do you have any comparison notes between the two?

Thanks!

-Matt
dragonette1218
dragonette1218
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 1
Unfortunately I do not have any comparison notes on throttling. I can tell you PerfectDisk’s works from my experience but I have not used Diskeeper’s.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search