SQL Server system health extended event session has incorrect event specification

Applies to: SQL Server 2012 Enterprise

Summary


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. 

More Information


More details about this problem and how it occurred is available in post: Issues with the system_health session in SQL Server 2012
Use the Transact-SQL script to correct the incorrect map_keys in the system_health session.

The following table provides more information about the products or tools that automatically check for this condition on your instance of SQL Server and on the versions of the SQL Server product against which the rule is evaluated.

Rule softwareRule titleRule descriptionProduct versions against which the rule is evaluated
System Center AdvisorSQL Server system health extended event session has incorrect event specificationSystem Center Advisor checks the current definition of the system_health session and generates the alert if the map_kapys for the wait_types are incorrect. Follow the instructions from this article to correct the system_health session definition.SQL Server 2012