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] ,
Get DP Manageus Information Technologies’s stories in your inbox
Join Medium for free to get updates from this writer.
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 (%’
