November 2008 - Posts

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 , , , , ,
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 Read More...
Posted 25 November 08 12:24 by Jimmy May | 5 Comments   
Filed under , , , , , , , ,
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 Read More...
Posted 04 November 08 04:05 by Jimmy May | 4 Comments   
Filed under , , , ,

Search

This Blog

Syndication

Page view tracker