Welcome to MSDN Blogs Sign in | Join | Help

March 2009 - Posts

Monday, March 30, 2009 5:32 PM

Unable to use forced parameterization when deploying plan guides in SQL Server 2005

I was working a case last week where I wanted to instate some fairly simple plan guides for a query that had picked a bad plan on a particular deployment of an application. I was thinking it was going to be an easy process. The query in question executed
Posted by grahamk | 1 Comments
Filed under: , ,
Friday, March 27, 2009 4:08 PM

How to Customise SQLDIAG in SQL Server 2008 to collect DBCC MEMORYSTATUS

Although Books Online makes some mention of SQLDIAG customizations, it doesn’t any explicit examples, so here’s one for you. I documented previously here about how to customize your XML configuration file to connect to different machines, and collect
Posted by grahamk | 1 Comments
Wednesday, March 18, 2009 1:59 PM

TechDays Sweden: post presentation questions and follow ups

Following my presentation here in Västerås yesterday there were a few people waiting to speak to me who I didn't have time for. If you were one of those people and want to ask some questions, you're more than welcome to post them here in the comments,
Posted by grahamk | 0 Comments
Filed under:
Monday, March 16, 2009 10:09 AM

Come and say Hi at TechDays Sweden tomorrow....

I'll be presenting (my usual mantra on using SQLDIAG to troubleshoot your own problems) at 16:15 tomorrow. Also the support team will be running a desk where they'll be 3 or 4 of us at all times to answer general support related questions. I've got four
Posted by grahamk | 0 Comments
Filed under:
Tuesday, March 10, 2009 11:14 AM

sys.dm_exec_query_stats DMV can report invalid information for parallel plans

Elisabeth Redei asked me to respond to a question earlier today following a comment on her blog post about performance monitoring using DMVs . The question asked was "when will sys.dm_exec_query_stats be fixed to report worker time (cpu) for queries with
Posted by grahamk | 1 Comments
Thursday, March 05, 2009 8:41 AM

New SQL Blogger - a must read

An ex-colleague of mine Elisabeth Redei, has just opened a new blog at http://sqlblog.com/blogs/elisabeth_redei/default.aspx Elisabeth is extremely knowledgable and has spent many years in Microsoft SQL Server support roles. You should definately add
Posted by grahamk | 1 Comments
Filed under:
 
Page view tracker