title: Instant File Initalisation - is it enabled for local system accounts?
body: <p>I have a SQL Server that is running under local NT service accounts.</p>
  
  <p><a href="https://i.stack.imgur.com/uPQ9p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uPQ9p.png" alt="enter image description here"></a></p>
  
  <p>Would file initialisation be enabled given the settings below? Is there an easy way to tell without needing to perform full demo scripts.</p>
  
  <p><a href="https://i.stack.imgur.com/3QdKI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3QdKI.png" alt="enter image description here"></a></p>
  
  <p>I tried the below from mssqltips but it doesn't contain that column in SQL 2014</p>
  
  <pre><code>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 (%'
  </code></pre>