Compartilhar via


SQL Server, General Statistics Object

The SQLServer:General Statistics object in Microsoft SQL Server provides counters to monitor general server-wide activity, such as the number of current connections and the number of users connecting and disconnecting per second from computers running an instance of SQL Server. This can be useful when you are working on large online transaction processing (OLTP) type systems where there are many clients connecting and disconnecting from an instance of SQL Server.

This table describes the SQL Server General Statistics counters.

SQL Server General Statistics counters

Description

Active Temp Tables

Number of temporary tables/table variables in use.

Event Notifications Delayed Drop

Number of event notifications waiting to be dropped by a system thread.

HTTP Authenticated Requests

Number of authenticated HTTP requests started per second.

Logical Connections

Number of logical connections to the system.

Logins/sec

Total number of logins started per second.

ms190697.note(en-US,SQL.90).gifNote:

This number includes logins from the connection pool.

Logouts/sec

Total number of logout operations started per second.

Mars Deadlocks

Number of Mars Deadlocks detected.

Non-atomic yield rate

Number of non-atomic yields per second.

Processes blocked

Number of currently blocked processes.

SOAP Empty Requests

Number of empty SOAP requests started per second.

SOAP Method Invocations

Number of SOAP method invocations started per second.

SOAP Session Initiate Requests

Number of SOAP Session initiate requests started per second.

SOAP Session Terminate Requests

Number of SOAP Session terminate requests started per second.

SOAP SQL Requests

Number of SOAP SQL requests started per second.

SOAP WSDL Requests

Number of SOAP Web Service Description Language requests started per second.

Temp Tables Creation Rate

Number of temporary tables/table variables created per second.

Temp Tables For Destruction

Number of temporary tables/table variables waiting to be destroyed by the cleanup system thread.

Trace Event Notifications Queue

Number of trace event notification instances waiting in the internal queue to be sent through Service Broker.

Transactions

Number of transaction enlistments (local, DTC, bound all combined).

User Connections

Counts the number of users currently connected to SQL Server.

See Also

Other Resources

Monitoring Resource Usage (System Monitor)

Help and Information

Getting SQL Server 2005 Assistance