IFI

Test-DbaInstantFileInitialization

Test-DbaInstantFileInitialization View Source the dbatools team + Claude Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Tests whether Instant File Initialization (IFI) is properly configured for SQL Server Engine service accounts. Description Audits Instant File Initialization (IFI) configuration for all SQL Server Engine services on the specified computer(s). IFI allows SQL Server to skip zeroing out data file space during file creation and auto-growth operations, which can dramatically speed up database creation, restore operations, and auto-growth events.