in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Performance » SQL 2005 (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

  • Disk Partition Alignment Best Practices for SQL Server whitepaper

    This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis, and remediation; and it describes how Windows Server...
    Posted to sqldbatips.com blog (Weblog) by sqldbatips on Tue, May 12 2009

  • The evils of implicit conversions

    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...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Jan 18 2009

  • SQL 2005: Procedure cache cleared

    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...
    Posted to Andrew Calvett (Weblog) by ACALVETT on Mon, Jun 5 2006
Page 1 of 1 (5 items)
Powered by Community Server (Commercial Edition), by Telligent Systems