---
title: "Test-DbaInstantFileInitialization"
description: "Tests whether Instant File Initialization (IFI) is properly configured for SQL Server Engine service accounts."
url: "https://dbatools.io/Test-DbaInstantFileInitialization/"
availability: "Windows only"
tags: ["IFI", "Privilege", "Security", "BestPractice", "OS"]
author: "the dbatools team + Claude"
source: "https://github.com/dataplat/dbatools/blob/master/public/Test-DbaInstantFileInitialization.ps1"
last_updated: "2024-01-01"
---

# Test-DbaInstantFileInitialization

## 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. Microsoft recommends enabling IFI as a best practice for all SQL Server installations.  
  
IFI is controlled by the Windows "Perform Volume Maintenance Tasks" privilege (SeManageVolumePrivilege). The recommended approach is to grant this privilege to the virtual service account "NT SERVICE\<ServiceName>" rather than to the actual service account (StartName), as this follows the principle of least privilege and is account-independent.  
  
This command checks both the virtual service account (NT SERVICE\<ServiceName>) and the actual start account (StartName) to determine:  
- IsEnabled: IFI is enabled via either account (the service will benefit from IFI)  
- IsBestPractice: IFI is enabled via the virtual service account only (the recommended configuration)  
  
Note: This command checks direct privilege assignments only. IFI may also be enabled indirectly via group membership (e.g., Administrators), which is not detected by this command.  
  
Requires Local Admin rights on destination computer(s).  
  
References:  
https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization  
https://blog.ordix.de/instant-file-initialization-microsoft-sql-server-set-up-check

## Syntax

```powershell
Test-DbaInstantFileInitialization
    [[-ComputerName] <DbaInstanceParameter[]>]
    [[-Credential] <PSCredential>]
    [-EnableException]
    [<CommonParameters>]

```

## Examples

### Example 1: Tests IFI configuration for all SQL Server Engine services on sqlserver2019

```powershell
PS C:\> Test-DbaInstantFileInitialization -ComputerName sqlserver2019
```

### Example 2: Tests IFI configuration for all SQL Server Engine services on sql1, sql2, and sql3

```powershell
PS C:\> Test-DbaInstantFileInitialization -ComputerName sql1, sql2, sql3
```

### Example 3: Tests IFI configuration for all SQL Server Engine services on sql1 and sql2

```powershell
PS C:\> 'sql1', 'sql2' | Test-DbaInstantFileInitialization
```

### Example 4: Returns SQL Server services on sqlserver2019 where IFI is not configured as best practice

```powershell
PS C:\> Test-DbaInstantFileInitialization -ComputerName sqlserver2019 | Where-Object IsBestPractice -eq $false
```

### Optional Parameters

##### -ComputerName

Specifies the SQL Server host computer(s) to test IFI configuration on. Accepts server names, IP addresses, or DbaInstance objects.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | False |
| Pipeline | true (ByValue) |
| Default Value | $env:COMPUTERNAME |

##### -Credential

Specifies a PSCredential object used to authenticate to the target computer(s) when the current user account is insufficient.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | False |
| Pipeline | false |
| Default Value |  |

##### -EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.  
This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting.  
Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch.

| Property | Value |
| --- | --- |
| Alias |  |
| Required | False |
| Pipeline | false |
| Default Value | False |

## Outputs

**PSCustomObject**

Returns one object per SQL Server Engine service found on each computer tested.

**Default display properties (via Select-DefaultView):**

- ComputerName: The target computer name
- InstanceName: The SQL Server instance name
- ServiceName: The Windows service name (e.g. MSSQLSERVER, MSSQL$INSTANCENAME)
- StartName: The actual Windows account running the service
- IsEnabled: Boolean indicating if IFI is enabled via either the virtual or start account
- IsBestPractice: Boolean indicating if IFI is enabled via the virtual service account (NT SERVICE\<ServiceName>) only

**Additional properties available:**

- ServiceNameIFI: Boolean indicating if the virtual service account (NT SERVICE\<ServiceName>) has IFI privilege
- StartNameIFI: Boolean indicating if the actual start account (StartName) has IFI privilege

---

Part of [dbatools](https://dbatools.io/), a free and open source PowerShell module for SQL Server administration. Full command index: https://dbatools.io/commands/