sys.dm_exec_query_stats DMV can report invalid information for parallel plans

  • Article

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 this is that we have already fixed it, but the code has been checked into the next version of SQL Server (i.e. the next major release after SQL 2008). When it was fixed we also fixed another problem where the same DMV can report NULL in the dbid and objectid columns under certain circumstances.

Currently there are no plans to backport this fix into SQL 2005 or 2008.

Comments

  • Anonymous
    March 15, 2009
    Can you please let us know what is the most suitable workaround for this issue on SQL Server 2005 and SQL Server 2008? i.e. how can we get the correct worker time for parallel queries on these two servers. Thanks for your help Nabeel