Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » dmv   (RSS)
Thursday, September 03, 2009 10:15 AM

Fixed - incorrect CPU time reported by sys.dm_exec_query_stats for parallel plans

I was discussing with Elisabeth back in this blog post about the above problem, and made comments that there were no plans currently to backport this to SQL 2005 or 2008. This changed following feedback both from customers and from us within CSS, and
Posted by grahamk | 0 Comments
Filed under: ,
Friday, April 24, 2009 2:00 PM

New SQL Server 2008 DMV which I noticed this week - sys.dm_os_sys_memory

In the continuing series of "things I notice in SQL Server which I didn't know were there", I noticed the very simple but very useful sys.dm_os_sys_memory earlier this week. Why do I like this? Well obviously you can extract the memory information exposed
Posted by grahamk | 1 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
Wednesday, February 11, 2009 7:43 PM

Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 2

[follow up to RESOURCE_SEMAPHORE_QUERY_COMPILE diagnosis] Last week I wrote about the initial diagnosis of this problem, and now here's the follow up. So if you remember we had a DBCC MEMORYSTATUS and a load of other PSSDIAG data collected and we knew
Posted by grahamk | 1 Comments
Monday, February 02, 2009 4:48 PM

Which sessionid has the most locks in a SQL Server instance

Quick post today. Was playing around with something on Friday night, thinking how to answer this question quickly whilst looking a live performance problem. I have a huge selection of ready to go DMV based queries, aimed at targetting all types of performance
Posted by grahamk | 2 Comments
Filed under: , , ,
 
Page view tracker