[Script of Mar. 10] How to detect system health extended event session incorrect event specification

Script Download: CheckIncorrectEventSpecification.zip
https://gallery.technet.microsoft.com/How-to-detect-system-40857284

This T-SQL script will demo how to detect system health extended event session incorrect event specification in SQL Server 2012.

Every instance of SQL Server has a default extended event session created that has the name system_health. This session captures information about the wait_info and wait_info_external events. The definition of the system_health session in SQL Server 2012 contains incorrect map_key specified for the wait_types of interest. The script will help check system health extended event session incorrect event specification in SQL Server 2012.

image image
 image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery