blogs.conchango.com

This one is a bit surprising. Assume you have a cold SQL Server which you have just re-booted.  The buffer cache is empty and lots of I/O requests are going to be physical. Boo! Hiss!  Down with physical I/O. Well help is at hand (if you are using SQL Server Enterprise Edition). Ramp-up is the process of converting your I/O's from page ...

Are you using multiple files? Are you set up for proportional fill? Is it a warehouse?  Are you concerned about extent fragmentation? You should be.  Extent fragmentation upsets your lovely read-ahead and results in smaller I/O. Let me explain.  When SQL Server allocates - it does so on a one extent at a time.  If multiple ...

I thought it might be fun to do series of posts on features that are exclusive to enterprise edition but that aren't significant enough in their own right to make it on to the big ticket list.  Sometimes people balk at shelling out for SQL Server Enterprise Edition without realising on what they are missing out.  So my objective is to ...