Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. SQL Server system health extended event session has incorrect event specification

SQL Server system health extended event session has incorrect event specification

View products that this article applies to.

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. 

↑ Back to the top

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




↑ Back to the top

Keywords: kb, kbtshoot

↑ Back to the top

Article Info
Article ID : 2692112
Revision : 3
Created on : 11/20/2019
Published on : 11/20/2019
Exists online : False
Views : 299