Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    Unanswered: Disk Fragmentation

    What's the best way to find out if disk fragmentation on Windows 2000 Server is affecting SQL Server performance?

    If disk fragmentation is shown to be a cause of performance problems, what are the recommendations for a disk fragmentation strategy? eg. use the win 2000 built in disk defrag utility or buy a 3rd party product like DiskKeeper? How much of an overhead is a product like DiskKeeper that defrags in the background?


  2. #2
    Join Date
    Jul 2004
    would running a trace after defragmentation, and running it again when the disk gets fragmented aid in this? you could use the built in defragger, but i would run it when the server is at it's quietest.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts