PART II

Troubleshooting Tools and Lessons from the Field

• CHAPTER 9: Troubleshooting Methodology and Practices
• CHAPTER 10: Viewing Server Performance with PerfMon and the PAL Tool
• CHAPTER 11: Consolidating Data Capture with SQLdiag
• CHAPTER 12: Bringing It All Together with SQL Nexus
• CHAPTER 13: Diagnosing SQL Server 2012 Using Extended Events
• CHAPTER 14: Enhancing Your Troubleshooting Toolset with PowerShell
• CHAPTER 15: Delivering a SQL Server Health Check
• CHAPTER 16: Delivering Manageability and Performance
• CHAPTER 17: Running SQL Server in a Virtual Environment