Browse by Tags

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 the fix was made part of SQL Server 2008 SP1. You...

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 by the OS in a number of different places...

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 parallel execution plans?" The answer to...

[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 that the procedure cache seemed to be constantly...

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 problems, but this was one I didn't have...