Episode 272: Performance Tuning Scripts
SQL Data Partners Podcast
00:00
Navigating SQL Server Logs and Performance Tuning
This chapter explores the complexities of analyzing SQL Server's extended events and system logs, emphasizing the challenges and solutions for extracting useful information. It introduces the SP Log Hunter stored procedure aimed at simplifying error log analysis and highlights the need for vigilant performance monitoring. The discussion also touches on the difficulties of XML parsing and the perceived stagnation of Microsoft's XML technology.
Transcript
Play full episode
