April 2009 - Posts

Presentation Deck for "Performance Tuning with Wait Statistics"
22 April 09 12:00 PM | josephsa | 4 Comments   

Here is a link to the presentation deck for yesterday's Minnesota PASS presentation: " Performance Tuning with Wait Statistics " Was fun to see everyone. Thanks for attending! Read More...

Speaking at PASS MN Tuesday April 21 - Performance Troubleshooting with Wait Statistics
15 April 09 04:24 PM | josephsa | 0 Comments   

If you live in Minnesota or are visiting next Tuesday, April 21st, please stop by the Bloomington Microsoft office and say hello. I'll be presenting on the topic "Performance Troubleshooting with Wait Statistics" (a subject made famous by Tom Davidson). Read More...

Checking for CPU pressure via sys.dm_os_schedulers
08 April 09 03:40 PM | josephsa | 1 Comments   

Do you suspect you are encountering CPU pressure? Some of the more common signs of CPU pressure include: Sustained "% Processor Time" values (>75% for extended periods) High signal wait time percentage from sys.dm_os_wait_stats SOS_SCHEDULER_YIELD Read More...