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

Server Side Aliases
07 November 2010 21:37

Over the years i have come across a few situations where server side connections to SQL server fail when you use a DNS alias that points back to the server your initiating the connection from but you can connect remotely. Its an annoying problem which has a very unhelpful error message that changed in different versions of SQL. In SQL 2000 you are presented with... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, SQL 2000, Tips, Database Engine, 2008

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