Welcome to EMC Consulting Blogs

Browse by Tags

• Database Administration
• SQL Server
• SQL Server 2005

• SQL2K5 Enterprise Edition Mini Feature 2 : Ramp up

  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 Read More... Posted 16 March 2008 20:41 by James.Rowland-Jones | 2 Comments Filed under: SQL Server 2005, SQL Server, Database Administration, Enterprise Edition

• SQL2K5 Enterprise Edition Mini Feature 1 : -E Startup Option

  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.  Read More... Posted 16 March 2008 20:38 by James.Rowland-Jones | 2 Comments Filed under: SQL Server 2005, SQL Server, Database Administration, Enterprise Edition

• SQL2K5 Enterprise Edition Mini Features

  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 Read More... Posted 16 March 2008 20:37 by James.Rowland-Jones | 0 Comments Filed under: SQL Server 2005, SQL Server, Database Administration, Enterprise Edition