Skip to content

Instantly share code, notes, and snippets.

@ghotz

ghotz/check-ifi.sql

Last active October 26, 2020 11:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ghotz/bcc8248cc442c934337862b942371ba9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ghotz/bcc8248cc442c934337862b942371ba9 to your computer and use it in GitHub Desktop.
Download ZIP
Verify Instant File Initialization status
Raw
check-ifi.sql
-- verify IFI status
-- check with DMV where available
SELECT
@@SERVERNAME as server_name
, servicename AS [service_name]
, instant_file_initialization_enabled
FROM sys.dm_server_services;
-- check with undocumented SP otherwise
EXEC xp_readerrorlog 0, 1, N'Instant File Initialization';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment