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.
You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery