The Defrag test to end all arguments!

Does defragging an HDD make it noticably faster in your experience?

  • Yes it makes a marked difference

    Votes: 5 13.2%
  • Only slightly

    Votes: 12 31.6%
  • No, I don't see it

    Votes: 13 34.2%
  • Maybe on a drive with tons of information needing to be read constantly

    Votes: 6 15.8%
  • Unsure

    Votes: 2 5.3%

  • Total voters
    38
look at JKDefrag.... makes sned that it moves the files that are accessed more regualrly to the begining of the hard drive...
 
A file system check is far more important than a defrag, todays drives are fast enough anyway and if you own a SSD you should not defragment it because it will make things slower.
 
Well SSD are not really HDD they are optimized USB sticks :P But I do say that defrag will make things a little faster I mean hell just do it once a month and do it over night.
 
I use Contig and Power Defragmenter 3.0 and do a triple-pass defrag and it generally speeds up this Dell D630 that I am using and my startup programs are all disabled -> http://www.google.co.za/search?q=co...s=org.mozilla:en-US:official&client=firefox-a

I also use Page Defrag and twice a month -> http://technet.microsoft.com/en-us/sysinternals/bb897426.aspx.

Contig is a tool here to defrag a single file:
http://technet.microsoft.com/en-us/sysinternals/bb897428.aspx
Autoruns will tell you EVERYTHING that starts:
http://technet.microsoft.com/en-us/sysinternals/bb963902.aspx
VMMap gives the memory usage of each application, and feature/file. So you can see how much memory a word document for example uses!
http://technet.microsoft.com/en-us/sysinternals/dd535533.aspx
And then (unrelated) desktops does does what Linux does by allowing many different desktops!
http://technet.microsoft.com/en-us/sysinternals/cc817881.aspx

You gotta love sysinternals :)
 
How's this exercise going?

I've been doing some SQL Server 2005 optimization at work recently and one of the things that comes up a lot on the web is fragmentation of the physical database files.

This is especially true if your DB is set to Auto Grow/Auto Shrink and they say fragmentation can cause quite serious query performance issues.

Has anyone had a significant SQL performance boost after defrag?
 
use crapcleaner, and now and then to a jKDefrag (1x for 1-2 months)

the OP makes me think about one employer whom i worked with who insisted that each friday we do a full backup (not bad), full virus scan (odd since it was clean whole week) and then full defrag).
 
How's this exercise going?

I've been doing some SQL Server 2005 optimization at work recently and one of the things that comes up a lot on the web is fragmentation of the physical database files.

This is especially true if your DB is set to Auto Grow/Auto Shrink and they say fragmentation can cause quite serious query performance issues.

Has anyone had a significant SQL performance boost after defrag?

I have started this testing 3 times, each time I start I have to send my equipment out to another site and never get to reach any reasonable conclusion.

WRT SQL, defrag will help nothing if you have not set your DB to autosize, since a single file can never become fragmented after being created.

A fragmented SQL DB is one instance where fragmentation can impact performance. I once saw a 3% performance improvement after performing several optimizations including disabling autosize and defragging the current DB (we had very detailed stats regarding the type of IO).

What RAID level is your DB on? Have you realigned the disks?
 
I couldn't remember how to remove programs from starting on windows start.

Now i know, Msconfig...

I keep closing all the programs that start on startup my pc should start faster now :D
 
...well it does help with overall IO when disc was clutered; definitly not going to zomg fast your pc.

26632
 
Top
Sign up to the MyBroadband newsletter
X