Improving SQL Server Performance by using Instant File Initialization
Today I want to talk about a very specific topic in SQL Server – Instant File Initialization. If you have Instant File Initialization for your SQL Server Instance enabled, you can have a tremendous performance improvement – under specific circumstances. Instant File Initialization defines how the SQL Server engine interacts with the Windows OS, when …
Improving SQL Server Performance by using Instant File Initialization + read more
