Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

SQL Server Instant File Initialization (PQW) Expand / Collapse
Author
Message
Posted Monday, April 2, 2012 12:03 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:33 AM
Points: 344, Visits: 1,543
Comments posted to this topic are about the item SQL Server Instant File Initialization (PQW)


John Sansom (@sqlBrit) | www.johnsansom.com
Post #1276459
Posted Monday, April 2, 2012 2:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:40 AM
Points: 7,001, Visits: 8,439
great summary, John !

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


Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1276491
Posted Monday, April 2, 2012 2:50 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:33 AM
Points: 344, Visits: 1,543
Thanks Johan!


John Sansom (@sqlBrit) | www.johnsansom.com
Post #1276493
Posted Monday, April 2, 2012 4:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 6, 2014 4:49 PM
Points: 389, Visits: 154
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
Posted Monday, April 2, 2012 4:35 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:33 AM
Points: 344, Visits: 1,543
Thanks NCS.

That's a good suggestion.



John Sansom (@sqlBrit) | www.johnsansom.com
Post #1276534
Posted Monday, April 2, 2012 6:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, February 14, 2014 9:15 AM
Points: 14, Visits: 130
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
Posted Monday, April 2, 2012 8:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:21 PM
Points: 2,270, Visits: 3,780
Good job John in explaining this concept. Looking forward for your future PQWs.

Mohammed Moinudheen
Post #1276638
Posted Monday, April 2, 2012 8:43 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 10:33 AM
Points: 344, Visits: 1,543
Thanks Mohammed! You can never have too many PQWs


John Sansom (@sqlBrit) | www.johnsansom.com
Post #1276661
Posted Monday, April 2, 2012 11:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 11:03 AM
Points: 4, Visits: 202
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
Posted Tuesday, April 3, 2012 3:43 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 7:19 AM
Points: 728, Visits: 771
Great artical John, i'm probably not alone in thinking why haven't I done that already (implementing it in DEV as I type), looking forward to your next post.

Mike
Post #1277158
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse