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