Performance,SQL 2005 - Andrew Calvett

Browse by Tags

All Tags » Performance » SQL 2005 (RSS)
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: , , , , , , , , , ,
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: , , , , ,
The evils of implicit conversions
18 January 2009 17:18
I wanted to put up a brief post showing the impact of an implicit conversion on the performance of a query (or not......). In the example i will show an implicit conversion negatively impacting query performance and an implicit conversion that does not impact performance..... So, we need to setup the test environment using the code below. SET ANSI_WARNINGS OFF... Read More...
by ACALVETT | with no comments
Filed under: , , ,
SQL 2005: Procedure cache cleared
05 June 2006 18:15
I don't normally write about a technet article but i must say that 917828 caught my eye and i felt that it was worth highlighting it. The reason it caught my eye is that it describes a number of scenarios where by the whole procedure cache is flushed which will clearly lead to a decrease in query performance whilst the cache builds up again. The most alarming... Read More...
by ACALVETT | with no comments
Filed under: , ,