Performance Counters for Native XML Web Services

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The following performance counters are added to the SQL Server performance counter in the SQL Server: General Statistics performance object.

Name

Description text

Notes

HTTP Authenticated Requests

Number of authenticated HTTP requests started per second

Incremented for each authenticated HTTP request that is handled by the server per second. Requests that are received during challenge are not counted. The count is reset each second. This includes requests under integrated, digest or basic authentication

SOAP Batch SQL Requests

Number of SOAP ad hoc batch requests started per second

Incremented for each HTTP request that represent an ad hoc batch that is handled by the server. Requests that are received during challenge are not counted. The count is reset each second

SOAP Method Invocations

Number of SOAP method invocations started per second

Incremented for each HTTP request that represents a method invocation that is handled by the server. Requests that are received during challenge are not counted. The count is reset each second.

SOAP WSDL Requests

Number of SOAP Web Service Description Language requests started per second

Incremented for each HTTP request that represents a request for WSDL that is handled by the server. Requests that are received during challenge are not counted. The count is reset each second.

SOAP Requests Executing

Number of SOAP requests currently being processed by the server at a specific time

Incremented for each SOAP request that starts execution and decremented for each request completed.

SOAP Requests Failed

Number of SOAP requests that cause an error condition (SOAP Fault) per second

Incremented for each SOAP request that produces a SOAP fault. The count is reset each second.

SOAP Requests Succeeded

Number of SOAP requests that executed successfully per second

Incremented for each SOAP request that successfully executes. The count is reset each second.

Additionally, Native XML Web Services requests will respect the three existing counters: Logins/sec, Logouts/sec, and User Connections. Each HTTP/SOAP request will be equivalent to a single login and a single logout. For the length of the request, it will also cause an increment in User Connections.

To add the performance counters

  1. Click Start, select Run, and type perfmon.

  2. To add a counter, in the right pane, either right-click or click the plus (+) button on the Toolbar.

  3. In the Add Counters dialog box, in the Performance object drop-down list, select SQLServer.GeneralStatistics.

  4. Click Add and now you can monitor the performance.

See Also

Reference