Browse by Tags

• /faster
• Best Practices
• Fundamentals
• Performance
• SQL Server
• Tools
• Training

Wait Stats by Joe Sack

Wait stats rock. As I shared recently with friends, when it comes to SQL Server performance, wait stats are the #1 arrow in my quiver, the first tool out of my toolbox, the Vera of guns (see the Firefly episode Our Mrs. Reynolds to divine that reference). Read More...

Posted 27 April 09 11:15 by Jimmy May | 2 Comments   
Filed under Best Practices, Performance, SQL Server, Tools, /faster, Wait Stats
Attachment(s): Joe Sack wait stats.sql

Wait Stats Introductory References

Preamble For those of you who are already facile with SQL Server wait stats, there’s nothing new here. However, if you’re a n00b, this is a great place to start. History As I commented here on SQL MVP Jason Massie’s blog , I first became aware of the Read More...

Posted 26 April 09 06:23 by Jimmy May | 3 Comments   
Filed under Training, Performance, Fundamentals, SQL Server, /faster, Wait Stats

Search

This Blog

• Home
• Email

Tags

• /faster
• Architecture
• Best Practices
• Career
• CPU
• Discipline
• Disk I/O
• Disk Partition Alignment
• DMOs/DMFs/DMVs
• Effectiveness
• Engineering Discipline
• Fundamentals
• Geekly
• Humor
• Hyper-V
• Indexes
• L'Chaim!
• Me
• Memory
• Miscellaneous
• News
• Office Productivity
• Outlook
• PerfMon
• Performance
• Personal Productivity
• Productivity
• Replication
• Scalability
• Speaking
• SQL CAT
• SQL Server
• SQLIOSim
• Table Partitioning
• Tools
• Training
• T-SQL
• VSTS
• Wait Stats
• xperf/ETW/WPA/WPT

Archives

• November 2009 (2)
• October 2009 (1)
• September 2009 (4)
• August 2009 (1)
• May 2009 (5)
• April 2009 (5)
• March 2009 (9)
• February 2009 (3)
• January 2009 (1)
• December 2008 (4)
• November 2008 (3)
• October 2008 (4)
• September 2008 (2)
• June 2008 (1)

Best of Blog

• SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction
• Drum Roll, Please...The Debut of The SQL DMV All-Stars Dream Team!
• PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server
• Disk Partition Alignment (Sector Alignment) for SQL Server: Part 1: Slide Deck
• Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials (Cheat Sheet)
• Disk Partition Alignment (Sector Alignment): Make the Case: Save Hundreds of Thousands of Dollars

Speaking

• ITT 2008 Commencement
• PASS 2008

Syndication

• RSS 2.0
• Atom 1.0