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

Exploring backup read io performance
24 January 2010 14:12

I was recently exploring how to increase the backup read throughput on one of our SQL servers. Below are some interesting facts i found. I would say that one of the most important reminders that came from the exercise is, do not assume that 2 databases being backup up on the same server using an identical backup command means that the processes are identical... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, Tips, Performance, Database Engine, 2008, Backup