in

SQL Server Blogs

Voices from the UK SQL Server Community

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
  • 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
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems