Browse by Tags

Parallelism, CPU Time & DMV’s
30 May 2011 12:04

Whilst reviewing the CPU statistics of a system that i knew was CPU bound i found the numbers were not adding up and i was not seeing the code i expected to see as a top CPU consumer so i decided to going digging. I quickly identified that if the query has gone parallel it: Only shows as one thread in sys.dm_exec_requests because sys. dm_exec_requests does not... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tools, Tips, Performance, Database Engine, 2008, 2008 R2, SQL 2008, CPU, Parallelism, DMV