This session is a look at performance tuning (i.e. performance troubleshooting) from the beginning. This session will go into detail about how to capture the current transactions with tools like sp_WhoIsActive stored procedure, Wait Stats, performance counters and Extended Events. This is a very demo intensive session to investigate some basic issues and performance analysis that would be used as a starting point for performance tuning. There will be homework!
Mike Lawell is a Data Platform MCSE and has been working with SQL Server since 1996 on Version 6.5. He is an independent consultant working for SolidQ, Linchpin People, Intellinet, Microsoft Consulting Services and others. His clients range from mid-size to large fortune 500 corporations. He specializes in performance tuning, high availability, database infrastructure design, security and much more.
Hope you can make it to our last official meeting of 2016!