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 |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2006-08-09 : 07:34:11
|
| Does anyone run diskeeper (or similar) on their db boxes to keep physical files as contiguous as possible?Any thoughts / pitfalls found? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-08-09 : 08:08:32
|
| Have done in the past.To get the best effect, you have to run the program offline, before windows starts, so your server has downtime imposed on it. Also it struggled to shift some particularly large database files. Other than that though it seemed fine.-------Moo. :) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-08-09 : 13:29:03
|
| I use CONTIG from Sysinternals - this can be run on a single file, so I use it on specific database files whenever they are off-line for scheduled maintenanceKristen |
|
|
|
|
|
|
Diskeeper