Today, I received the official word that I will be presenting two sessions in the SQLServerCentral.com track at the SQL Server Connections conference on November 1-4. I feel quite humbled to be included with the other great speakers at the conference. The SQLServerCentral.com track includes myself (blog | twitter), Allen White (blog | twitter), Buck Woody (blog | twitter), and Brad McGehee (blog | twitter).
My two sessions are:
SDB310: Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues with High Volume OLTP Workloads
Originally introduced in SQL Server 2005, and enhanced in SQL Server 2008 and SQL Server 2008 R2, Dynamic Management Views (DMVs) allow you to take an in-depth look at exactly what is happening inside your SQL Server instances and databases. In this session, you will learn over 30 different DMV queries you can execute to quickly and easily to detect and diagnose performance issues in your OLTP environment. For example, you will learn how to identify top wait states, most CPU intensive stored procedures, find missing and unused indexes, and many more. The scripts will be available for download so you can put them to immediate use.
SDB205: Selecting and Sizing Database Hardware for OLTP Performance
The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in processors and chipsets, along with improvements in magnetic and SSD storage, have dramatically changed the evaluation and selection process as compared to the past. Many DBAs struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later, so don’t let this happen to you! This session covers current and upcoming hardware from both Intel and AMD, and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.
The entire list of sessions is available here.