(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions blog posts collected together when you join our Insider list, plus my online Myths and Misconceptions training course on Pluralsight.) Today is the big day – 8am PST I'm presenting [...]
Paul S. Randal
In Recovery...
A SQL Server DBA myth a day: (14/30) clearing the log zeroes out log records
Posted on: April 14, 2010 6:07 am
A SQL Server DBA myth a day: (3/30) instant file initialization can be controlled from within SQL Server
Posted on: April 3, 2010 1:57 am
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions blog posts collected together when you join our Insider list, plus my online Myths and Misconceptions training course on Pluralsight.) A bit of a shorter one for today as we're [...]
Importance of data file size management
Posted on: June 24, 2009 6:55 pm
In last week's survey I asked how you manage the size of your database *data* files – see here for the survey. Here are the results as of 6/24/09. The 'other' values are as follows: 5 x 'manual file growths and a custom mom alter to when the datafiles are 98% full. autogrow set to [...]
Misconceptions around instant file initialization
Posted on: March 10, 2009 11:51 am
Whenever I teach a class I'm amazed at the number of DBAs who don't know about instant file initialization. Without wanting to redo blog posts that others have done, in a nutshell it allows a file to be create or grown 'instantly' by not having to zero the space in the file. This is especially [...]
Search Engine Q&A #24: Why can’t the transaction log use instant initialization?
Posted on: August 20, 2008 7:47 pm
This is a quickie in response to a blog comment from my previous post on instant initialization: How to tell if you have instant initialization enabled? The comment was: I must say, I love instant initialization. It's awesome. But I always wondered why it's not available for the log file. I assume there's a technical reason… [...]
How to tell if you have instant initialization enabled?
Posted on: August 11, 2008 7:10 pm
As you may already know, instant initialization is a way to prevent data (not log) file create and grow operations having to zero-initialize the new space before allowing it to be used. This can vastly speed up these operations as zero-initialization can take a *long* time for large files. This is especially useful in disaster [...]
