Skip to main content
How can we help?
< All Topics
Print

Errors

An error can be any error reported to the SQL Server engine. Errors can be syntax errors, permission errors, key relationship errors etc.

To query the Performance Store database for errors, use:

select e.*
from dbo.v_errors e
where 1 = 1
and e.sample_id = '[sample_id]'
and e.server_name = '[server_name]'
and e.database_name = '[database_name]'

A quick overview of the number of errors can be seen on the Overview 1 dashboard:

Login errors are a part of the total errors, but have its own graph on the Overview 1 dashboard:

This is to quickly identify, if connections are trying to be made to e.g. an offline database, or a user or service suddenly can’t connect to a database anymore.

A separate alert is thrown for login errors.

In-depth information about the errors can be seen on the Errors dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents