| title | SQL Server, SQL Errors object | ||
|---|---|---|---|
| description | Learn about the SQLServer:SQL Errors object, which provides counters to monitor SQL Errors in SQL Server. | ||
| ms.custom | |||
| ms.date | 07/13/2021 | ||
| ms.service | sql | ||
| ms.reviewer | |||
| ms.subservice | performance | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| author | WilliamDAssafMSFT | ||
| ms.author | wiassaf |
[!INCLUDE SQL Server] The SQLServer:SQL Errors object provides counters to monitor errors in Microsoft [!INCLUDEssNoVersion].
This table describes the [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] to kill the current connection. |
| User Errors | Information about user errors. |
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%';