SQL Server Instant File Initialization (PQW)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by John Sansom » SQL Server Instant File Initialization (PQW)

17 posts, Page 1 of 2

1 2 »»

SQL Server Instant File Initialization (PQW)

Rate Topic

Display Mode

Topic Options

Author

Message

John.Sansom

Posted Monday, April 02, 2012 12:03 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 10, 2013 1:52 AM
Points: 343, Visits: 1,453

Comments posted to this topic are about the item SQL Server Instant File Initialization (PQW)

John Sansom (@sqlBrit) | www.sqlbrit.com
The SQLBrit Community Forum - "There's so more to being a Data Professional than just technology."

Post #1276459

ALZDBA

Posted Monday, April 02, 2012 2:43 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:25 AM
Points: 6,861, Visits: 8,045

great summary, John !

It's good you mention "DB restores" as well, as it is a "non trivial" usage area in many cases. Exclamation Mark

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #1276491

John.Sansom

Posted Monday, April 02, 2012 2:50 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 10, 2013 1:52 AM
Points: 343, Visits: 1,453

Thanks Johan!

John Sansom (@sqlBrit) | www.sqlbrit.com
The SQLBrit Community Forum - "There's so more to being a Data Professional than just technology."

Post #1276493

Nitya

Posted Monday, April 02, 2012 4:32 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 09, 2013 5:59 AM
Points: 389, Visits: 140

Awesome post. Been using the feature ever since I learnt from Kim Tripp (> 4years)

A little bit of explanation around why log files are not zero initialized would have made it even more complete.

Thx
NCS

Post #1276527

John.Sansom

Posted Monday, April 02, 2012 4:35 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 10, 2013 1:52 AM
Points: 343, Visits: 1,453

Thanks NCS.

That's a good suggestion.

John Sansom (@sqlBrit) | www.sqlbrit.com
The SQLBrit Community Forum - "There's so more to being a Data Professional than just technology."

Post #1276534

gmmastros

Posted Monday, April 02, 2012 6:51 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, May 12, 2013 2:09 PM
Points: 14, Visits: 108

I wrote SQLCop a couple years ago. SQLCop can also detect whether Instant File Initialization is enabled.

Download SQLCop from http://sqlcop.lessthandot.com
Run SQLCop
Log in to any database on the server.
Expand "Configuration"
Click on "Instant File Initialization"

SQLCop will also show you a blog written by Brad M. McGehee that shows you how to enable Instant File Initialization.

George Mastros
Orbit Software, Inc.

Post #1276592

mohammed moinudheen

Posted Monday, April 02, 2012 8:01 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

Good job John in explaining this concept. Looking forward for your future PQWs. Smile

Mohammed Moinudheen

Post #1276638

John.Sansom

Posted Monday, April 02, 2012 8:43 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 10, 2013 1:52 AM
Points: 343, Visits: 1,453

Thanks Mohammed! You can never have too many PQWs Smile

John Sansom (@sqlBrit) | www.sqlbrit.com
The SQLBrit Community Forum - "There's so more to being a Data Professional than just technology."

Post #1276661

Edward Sun

Posted Monday, April 02, 2012 11:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 12:21 AM
Points: 4, Visits: 186

Thanks much for this article. It implies that it's more important to pre-size the tlog files than the data files because the tlog files cannot take the advantage of Instant File Intialization.

Post #1276792

SQLDBA360

Posted Tuesday, April 03, 2012 3:43 AM

SSChasing Mays

Group: General Forum Members
Last Login: Friday, May 10, 2013 9:32 AM
Points: 643, Visits: 687

Great artical John, i'm probably not alone in thinking why haven't I done that already Smile

(implementing it in DEV as I type), looking forward to your next post.

Mike

Post #1277158

« Prev Topic | Next Topic »

17 posts, Page 1 of 2

1 2 »»

Permissions