Browse by Tags

All Tags » CPU   (RSS)
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 , , , , ,
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 , , , , ,
PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server
I’m frequently asked questions about which PerfMon counters to use & what thresholds to rely on. I’ve been amalgamating this information for years in the form of an Excel workbook: PerfMon_Counters_Digest_w_Vital_Signs_Correlation_v6.xls . The current Read More...
Posted 15 October 08 09:44 by Jimmy May | 7 Comments   
Filed under , , , , , ,
Attachment(s): PerfMon_Counters_Digest_w_Vital_Signs_Correlation_v6.xls

Search

This Blog

Syndication

Page view tracker