About Show #195
Richard flies solo to talk to Pam Lahoud about SQL Server performance. Not just fighting slow queries, but planning in advance for poor performance behavior. The conversation digs into techniques to anticipate where performance problems will occur. Pam provides a list of great tools to use for understanding your performance problem in SQL Server, including SQL Nexus (http://sqlnexus.codeplex.com/) and PAL (http://pal.codeplex.com/).
Pam Lahoud is a Program Manager in the Database Systems Group, based in Redmond, WA, USA. She has been with Microsoft since 2006 and is currently responsible for Program Management of database engine features for in-market and vNext versions of SQL Server, with a special focus on the Storage Engine area. She is passionate about SQL Server performance and has focused on performance tuning and optimization, particularly from the developer perspective, throughout her career. She is a SQL 2008 MCM with over 20 years of experience working with SQL Server.