1

I've just inherried a SQL Server, where the database file growth was set to 1MB. So there are a lot of databases (>25) that have grown in small increments until now (currently totalling 300 GB).

So I thought the hard disk must be really fragmented, and ordered lots of downtime to run Disk Optimize (having shut down SQL Server). But it finished in 1 minute, saying the disks were not fragmented.

I noticed that it has been set with Scheduled optimization = On.

Is Windows 2016 able to run Disk Optimize with SQL Server running?

I've been searching high and low and all places say you should manually grow your databases in big chunks to avoid fragmentation. This seems less important if you can accept that Windows runs Disk Optimize once a week. The SP_Blitz tool from Brent Ozar puts out a warning if you have 1MB growth size.

Henrik Staun Poulsen
  • 143

1 Answers1

1

Every since windows had that functionality it actualyl worked on locked files. Even before the one they bought (i think) allowed that. There is a special API in the kernel allowing files to be moved without the regular file system API for that.

So, the answer is yes.

TomTom
  • 52,109
  • 7
  • 59
  • 142