Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Productivity
News you can use on implementation of the elusive sqlservr.exe /faster switch & personal effectiveness
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...
Author: Jimmy May Date: 11/28/2008
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...
Author: Jimmy May Date: 11/25/2008
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...
Author: Jimmy May Date: 11/04/2008
Drum Roll, Please...The Debut of The SQL DMV All-Stars Dream Team!
<#Author's note: Though I originally posted this six years ago, it's still one of my most popular...
Author: Jimmy May Date: 10/30/2008
Is Twitter the YouTube of 2008?
Always in pursuit of the elusive creature known as Work/Life Balance, I discard activities which...
Author: Jimmy May Date: 10/19/2008
PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server
I’m frequently asked questions about which PerfMon counters to use & what thresholds to...
Author: Jimmy May Date: 10/15/2008
Disk Partition Alignment (Sector Alignment) for SQL Server: Part 1: Slide Deck
<Note: 20081119: Deck updated w/ new graphics, perf metrics, & dynamic disk info>...
Author: Jimmy May Date: 10/14/2008
SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction
Introduction: The Classic Protocol, Amended Introduction My customers are often surprised to learn...
Author: Jimmy May Date: 09/01/2008