The Performance Virtual Chapter's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Welcome to the Performance Virtual Chapter

The Performance Virtual Chapter events are held on the 4th Thursday of each month at 2PM ET.  Every month there is a drawing for a $100 Amazon gift card sponsored by Confio a part of SolarWinds.  To be eligible, you just need to attend our monthly webcast.  A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address. 

You can follow us on Twitter @SQLPASS_PVC

Join our Google Group Distribution List for the latest updates and meeting announcements.

Congratulations to this months gift card winner: Desirae Smith.

Next Meeting

Thu, Jul 28 2016 14:00 Eastern Daylight Time

Baselining and Performance Comparison with PAL


Recording: None

Baselining and Performance Comparison with PAL

A common complaint heard by DBAs is "the system is slow and we think it's the database". But is it really the database? How do we quantify what is good and what is slow?

To be able to face this type of scenario in a scientific and logical way, we need to have a proper baseline of our system. And once we have the baseline we also need to be able to compare it to the current situation and decide the best course of action.

The PAL tools enable both of these scenarios by allowing easy capture of relevant performance metrics and even easier analysis of the values. In this session we will go over how to setup a Perfmon trace based on the PAL template for baselining and performance analysis, we will go through the analysis generated by PAL and the main performance counters to look for in your SQL Server performance analysis.

Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, managing multiple customers and instances in many versions and industries while leading a highly talented team of SQL Server DBAs.