| title | SQL Server, SQL Errors object | ||
|---|---|---|---|
| description | Learn about the SQLServer:SQL Errors object, which provides counters to monitor SQL Errors in SQL Server. | ||
| author | MikeRayMSFT | ||
| ms.author | mikeray | ||
| ms.date | 12/04/2023 | ||
| ms.service | sql | ||
| ms.subservice | performance | ||
| ms.topic | reference | ||
| helpviewer_keywords |
|
[!INCLUDE SQL Server] The SQLServer:SQL Errors object provides counters to monitor errors in Microsoft [!INCLUDE ssNoVersion].
This table describes the [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] 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 [!INCLUDE ssNoVersion] 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%';