Our regular monthly meeting is tonight featuring David Pless from Microsoft. Here are some notes about his presentation:
This discussion will continue to cover how to troubleshoot performance issues on SQL Server 2005 and SQL Server 2008. In this discussion I cover performance impact analysis using DMVs, SET options in SQL Server, and Profiler and perfmon analysis. In this discussion I will cover SQLNexus, PAL (Performance Analysis of Logs), RML Utilities, SQLDiag, and other tools. Finally I discuss reading query plans graphically and what you can learn from reading the XML plans.
Free pizza, good networking, learn some stuff – hope to see you there!