Instant file initialization and tempdb log

• PHXHoward

  SSCrazy Eights

  Points: 8389

  More actions

  September 20, 2016 at 10:27 am

  #313357

  Since log files are not able to use instant file initialization like data files, will it impact failover time to presize the tempdb log in the same way we presize tempdb data files?

  Howard

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  September 20, 2016 at 10:31 am

  #1901951

  If you are talking about in a FCI, then no. If the log size has not grown then the same file will be used on failover.

  Read https://www.sqlskills.com/blogs/jonathan/does-the-tempdb-log-file-get-zero-initialized-at-startup/ which has all the details you need, and lots more. :w00t:

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• PHXHoward

  SSCrazy Eights

  Points: 8389

  More actions

  September 20, 2016 at 10:36 am

  #1901955

  Thanks I'll read the article.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  September 20, 2016 at 1:40 pm

  #1902020

  No. TempDB uses existing files, they're just cleaned on a restart. It's only if the files aren't there that it will have to create and size them.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• PHXHoward

  SSCrazy Eights

  Points: 8389

  More actions

  September 20, 2016 at 1:43 pm

  #1902021

  Thanks both for the explanations.