SQL Server, SQL Errors object

Applies to: SQL Server

The SQLServer:SQL Errors object provides counters to monitor errors in Microsoft SQL Server.

This table describes the SQL Server SQL Errors counters.

SQL Server SQL Errors counters Description
Errors/sec Number of errors/sec.

Each counter in the object contains the following instances:

Item Definition
_Total Information for all errors.
DB Offline Errors Tracks severe errors that cause SQL Server to take the current database offline.
Info Errors Information related to error messages that provide information to users but do not cause errors.
Kill Connection Errors Tracks severe errors that cause SQL Server to kill the current connection.
User Errors Information about user errors.

Example

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%SQL Errors%';