sqlservercitation.com
Instant file Initialization and performance impact
Have you ever wonder why some of the file operations in SQL Server is slow? For example, when a database is being restored you felt like it is slow! Here in this post, let's discuss one of the reasons why there is a slowness - Instant file initialization and performance impact. Let's first