One of the biggest pain points for SQL Server 2000 was for looking at the plan of a SQL Statement, you have to execute the same. As per my understanding SQL Server 2000 did not expose any mechanism for this. So the only way to look at the plan of the...

In my previous post http://blogs.msdn.com/gauravbi/archive/2005/12/01/BufferPoolDesc.aspx we talked about analyzing the contents of buffer pool. Let's talk a bit about analyzing the contents of procedure cache- First we need to figure out what are...

SQL Server team has done some great amount of work in SQL Server 2005 to make the performance analysis of server easy. I am going to post a series of code snippets which I find useful in my day to day work. Memory Analysis Let us assume we have...