in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Performance » Database Engine (RSS)

Browse by Tags

  • Parallelism, CPU Time & DMV’s

    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...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Mon, May 30 2011

  • Exploring backup read io performance

    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...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Jan 24 2010
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems