David Pless presents Baselining and Troubleshooting at Tampa Bay SQL UG

Clearwater, FL

Bummer! Sales have ended.

Unfortunately, tickets for this event are no longer on sale.

View upcoming events Create an event

Event Details

David Pless will start the discussion on some of the engine changes to SQL Server 2012. David will be talking about leveraging SQLDIAG with the Perf Stats Script and customizing PAL for analyzing perfmon logs. SQLDIAG similar to PSSDIAG is a built-in SQL Server tool that allows you to create a custom server side trace. We will cover how to edit the trace file templates and adding the Perf Stats script to get additional information when baselining and troubleshooting SQL Server performance. We will cover what you can learn from the output and the next steps that can be taken when troubleshooting SQL Server. The PAL tool developed by Clint Huffman, has been a strong tool used to analyze SQL Server perfmon performance. We will cover how to modify the existing templates and the new SQL Server 2008 R2 threshold files. Additionally, David will cover how this information can be aligned with wait statistics and some additional data from dynamic management views.

 

Food and drinks will be provided. New SWAG has been added to the box courtesy of TechEd NA.

Please plan on joining us at Courtside Grill afterwards for the meeting after the meeting.
 
The doors are open at 6:00pm. Food will arrive shortly after that. The meeting will officially start at 6:30pm and will end no later then 9:00pm.