Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity

Browse by Tags

Case Study: Part 2: CXPACKET Wait Stats & 'max degree of parallelism' Option: Suppressing Query Parallelism Eliminated CXPACKET Waits & Liberated 30% of CPU: Introduction This is the second of a four-part series: Introduction to Query Parallelism Parallelism Suppression: Analysis, Remediation, & Results (this post) Parallel Query Identification & Remediation Summary Executive Summary In my first post Read More...
Posted 02 December 08 11:49 by Jimmy May | 3 Comments
Filed under CPU, Best Practices, Performance, Fundamentals, SQL Server, /faster
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 Read More...
Posted 28 November 08 01:29 by Jimmy May | 3 Comments
Filed under CPU, Best Practices, Engineering Discipline, Fundamentals, SQL Server, /faster