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%';

Related content

• Monitor Resource Usage (Performance Monitor)