Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
icw
Constraint Violating Yak Guru
378 Posts |
 Posted - 2007-06-24 : 00:03:05
|
| Hi, I have read about a utility called diskeeper to defrag sql server databases. I wanted to get an opinion as to how well it does the job. Also I wanted to ask (a probably silly question) does the Windows built-in defrag tool not work for this?Thanks |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-24 : 12:10:14
|
the windows tool will defrag the disk, not the database files themselves.there are two separate issues: 1. on the filesystem, a single file can be stored all over different parts of the physical disk if it's highly fragmented. the windows tool (and probably diskeeper also) will fix this problem.2. internally to a given database data file, you can have fragmentation. this means pages from the same table or index can be stored all over in different offsets from the top of the file, rather than contiguously. this means I/O will suffer. this is fragmentation of the database, which only sql server can fix (say by rebuilding an index)
elsasoft.org |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-24 : 13:45:34
|
| And should pay more attention on table fragmentation. |
|
|
|
icw
Constraint Violating Yak Guru
378 Posts |
Posted - 2007-06-25 : 01:39:16
|
| much appreciated..thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-06-25 : 08:33:58
|
| I use CONTIG.EXE from Sysinternals which makes it easy to defrag individual files.Not sure its any different to the Windows/Diskkeeper tools, but its one more to consider!Kristen |
|
|
|
|
|
|
Diskeeper