Thursday, November 16, 2006 - Posts

PASS 2006 - Shared disk is not a scale out solution

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/PASS 2006 - Shared disk is not a scale out solution
The new RSS feed is here

At the end of the keynote today, Paul Flessner joined Steve Balmer for a short Q&A. One of the questions was around SQL Servers response to the Oracle RACK solution to provide a scale out solution.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/PASS 2006 - Shared disk is not a scale out solution

posted Thursday, November 16, 2006 10:31 AM by SimonSabin with 0 Comments

Custom reports in SQL 2005 SP2

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Custom reports in SQL 2005 SP2
The new RSS feed is here

You may have come across the fact that in SP2 you can deploy custom reports that are accessible in management studio. This reports can be run from any context in the object explorer tree.

Whilst I think this is really interesting, I haven't played with it much, but Anthony has read his blog post on how to configure a report to run in management studio

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Custom reports in SQL 2005 SP2

posted Thursday, November 16, 2006 1:07 AM by SimonSabin with 1 Comments

DMVs impact on performance

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/DMVs impact on performance
The new RSS feed is here

Bottom line is very little if any. The way the SQLOS has been rearchitected the dmvs have been built into at the lowest level. This means the data exists, it is not a virtual table that is built up when the dmv is queried.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/DMVs impact on performance

posted Thursday, November 16, 2006 2:58 AM by SimonSabin with 0 Comments

Checkpointing is now throttled in SQL 2005

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Checkpointing is now throttled in SQL 2005
The new RSS feed is here

During the iinterview with the SQLOS team this morning Slava mentioned that as part of the new design for the SQLOS the checkpoint process is much tightly controlled. If the checkpoint process has issues pages to be written and the latency has become too high (20ms was mentioned) then it will stop issuing pages.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Checkpointing is now throttled in SQL 2005

posted Thursday, November 16, 2006 2:47 AM by SimonSabin with 0 Comments

PASS 2006 - Application partitioning

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/PASS 2006 - Application partitioning
The new RSS feed is here

This mornings first session was an interview with the SQLOS developers. This was a great session and a real eye opener into the work that has gone into the SQLOS in SQL 2005, to support NUMA.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/PASS 2006 - Application partitioning

posted Thursday, November 16, 2006 1:51 AM by SimonSabin with 0 Comments