MS SQL Server


Saved search

Description

SQL Hardware Error

Displays events from the SQL server error log, containing the string, “Severity: 24”.

This search can be useful to find the hardware errors with specified severity that might occur due to various reasons.

Included in dashboard: Yes

SQL Server Fatal Error Table Integrity Suspect

Displays events from the SQL server error log, containing the string, “Severity: 22”.

This search can be useful to find the Fatal errors with specified severity.

Included in dashboard: Yes

  • SQL Server Fatal Error in Current Process

Displays events from the SQL server error log, containing the string, “Severity: 20”.

This search can be useful to find the Fatal Error in Current Process with specified severity.

Included in dashboard: Yes

  • SQL Server Fatal Error in Database (dbid) Processes

Displays events from the SQL server error log, containing the string, “Severity: 21”.

This search can be useful to find the Fatal Error in Database (dbid) Processes with specified severity.

Included in dashboard: Yes

  • SQL Server Fatal Error: Database Integrity Suspect

Displays events from the SQL server error log, containing the string, “Severity: 23”.

This search can be useful to find the Fatal Error: Database Integrity Suspect with specified severity.

Included in dashboard: No

Collection profile

Description

Default logs

Contains data collector templates that can be used for collecting data from the SQL server error logs.

The data collector templates collect data from the following location:

MSSQL_SERVER_INSTANCE_PATH\MSSQL\LOG\

Dashboard

Description

  • MS SQL Server View

Provides a summary of the following connection errors related to the SQL Server:

  • SQL Hardware Error
  • SQL Server Fatal Error Table Integrity Suspect
  • SQL Server Fatal Error in Current Process
  • SQL Server Fatal Error in Database (dbid) Processes

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC TrueSight IT Data Analytics Content Pack