WHAT IS IFI

It is a configuration that needs to be made for QL Server to use the disk space allocated to it more efficiently.

In short, when SQL Server requests disk space from Windows, Windows dedicates this space to SQL Server and scans (i.e. fills) the space for SQL for this purpose. After that, SQL clears the field and starts writing data. Thanks to this setting, he gets rid of the fill-empty operation that we mentioned above and starts managing the space himself from the first moment.

You can use the following scritpi to open and teach.

SELECT @@SERVERNAME AS [Server Name] ,

RIGHT(@@version, LEN(@@version) — 3 — CHARINDEX(‘ ON ‘, @@VERSION)) AS [OS Info] ,

LEFT(@@VERSION, CHARINDEX(‘-’, @@VERSION) — 2) + ‘ ‘

+ CAST(SERVERPROPERTY(‘ProductVersion’) AS NVARCHAR(300)) AS [SQL Server Version] ,

service_account ,

instant_file_initialization_enabled

FROM sys.dm_server_services

WHERE servicename LIKE ‘SQL Server (%’