Case Study: Part 1: CXPACKET Wait Stats & ‘max degree of parallelism’ Option: Introduction to Using Wait Stats to Identify & Remediate Query Parallelism Bottlenecks

This is the first of a four-part series: Introduction to Query Parallelism (this post) Flipping the Bit Expensive Query Identification & Remediation Summary Query Parallelism The SQL Server configuration option max degree of parallelism determines the maximum number of processors which can participate in query execution.  The default value is 0, allowing SQL Server to…

3

Disk Partition Alignment (Sector Alignment) for SQL Server: Part 3: PASS 2008

I’ve spoken publicly several times this year to crowds large-&-small: TechReady 6 (an internal Microsoft conference) Indy Tech Fest ITT Commencement Last week was my first external international conference, the Professional Association for SQL Server 2008 Community Summit. This is my second summit & first speaking opportunity. The PASS summit is an incredible event. Plan…

5

Disk Partition Alignment (Sector Alignment) for SQL Server: Part 2: Adding HP EVA 8000 to Veritas Enterprise Administrator “Track Alignment Settings” Dialog

  Background In a previous post I documented the importance of disk partition alignment as a foundation for optimal disk I/O performance.  In the lab & in the field we’ve commonly found performance enhancements of 30% – 40% by a variety of metrics.    Though Windows Server 2008 provides for out-of-the-box alignment for new partitions,…

4