sql-server-sql-errors-object.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
SQL Server, SQL Errors object	Learn about the SQLServer:SQL Errors object, which provides counters to monitor SQL Errors in SQL Server.	WilliamDAssafMSFT	wiassaf	12/04/2023	sql	performance	reference	SQL Errors object SQLServer:SQL Errors

SQL Server, SQL Errors object

[!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.

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)