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 |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2013-12-05 : 07:30:16
|
| Is it safe to run a disk defragmentation task on a disk that has SQL Server installed on it?Will it impact performance of the databases?Could it cause any data corruption?Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2013-12-05 : 07:33:52
|
I only defragment the disk when the SQL Service is stopped (i.e. schedule downtime). I specifically defragment Data and Index files individually (using CONTIG from Sysinternals) to try to get them onto contiguous disk space.Every little helps  (EDIT: For avoidance of doubt we don't schedule downtime in order to defrag files, but we do defrag files when we have downtime for other activities, such as upgrading hardware) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-12-05 : 15:47:47
|
| We don't ever defragment the disks. Our systems are 24x7x365.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Disk Defragmentation