Does the tempdb Log file get Zero Initialized at Startup?

Posted by Jonathan Kehayias on SQL Blog See other posts from SQL Blog or by Jonathan Kehayias
Published on Fri, 14 May 2010 00:13:53 GMT Indexed on 2010/05/14 0:26 UTC
Read the original article Hit count: 364

Filed under:

Database Administration

|

Did You Know

|

internals

|

Miscellaneous

While working on a problem today I happened to think about what the impact to startup might be for a really large tempdb transaction log file. Its fairly common knowledge that data files in SQL Server 2005+ on Windows Server 2003+ can be instant initialized, but the transaction log files can not. If this is news to you see the following blog posts: Kimberly L. Tripp | Instant Initialization - What, Why and How? In Recovery... | Misconceptions around instant file initialization In Recovery…...(read more)

© SQL Blog or respective owner

Related posts about Database Administration

SQL SERVER Retrieve and Explore Database Backup without Restoring Database Idera virtual database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database… >>> More
Cloning A Database On The Same Server Using Rman Duplicate From Active Database

as seen on Oracle Blogs - Search for 'Oracle Blogs'
To clone a database using Rman we used to require an existing Rman backup, on 11g we can clone databases using the "from active" database option. In this case we do not require an existing backup, the active datafiles will be used as the source for the clone. In order to clone with the source database… >>> More
cPickle ImportError: No module named multiarray

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm using cPickle to save my Database into file. The code looks like that: def Save_DataBase(): import cPickle from scipy import * from numpy import * a=Results.VersionName #filename='D:/results/'+a[a.find('/')+1:-a.find('/')-2]+Results.AssType[:3]+str(random.randint(0,100))+Results.Distribution+"… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More

Related posts about Did You Know

I know it is a VLC know issue, but cant find a workaround

as seen on Super User - Search for 'Super User'
I installed VLC player, because it works better that other video player on HD videos, but know I have an issue all most of my games (All of those using Bink Video, that means all Unreal Engine games, Call of duty, and more). When I load the game, I can hear the videos, the audio is working, so I… >>> More
Java stuff you didn't know you didn't know

as seen on Stack Overflow - Search for 'Stack Overflow'
What are some Java language features or Java related tools that you were embarrassed to find that you didn't know about? Examples for me are: jmap RuntimeException Please post things every Java programmer should know about, be they language features, tools, or facts about how the JVM works, but… >>> More
How to know what you don't know?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way how to recognize that you don't know something? For example, I had some hard realizations: I didn't know that criticism isn't a good way to teach your friends. I realized that after reading How to Win Friends & Influence People. I didn't know about the fundamental needed for… >>> More
how to know u know the language well enough

as seen on Stack Overflow - Search for 'Stack Overflow'
i have recently finished understanding the basics of c++ and i was wondering how can be assured that i have reached the level i want to reach ..is there any site where one can take tests to know he knows enough .. >>> More
Shout loud what simple things you still dont know but must know

as seen on Stack Overflow - Search for 'Stack Overflow'
Shout loud what simple things you still dont know but must know. In every field of programming / computing, there are some leftovers which we keep on planning forever, but couldnt really start. Share yours ! >>> More