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
Click Start, select Run, and type perfmon.
To add a counter, in the right pane, either right-click or click the plus (+) button on the Toolbar.
In the Add Counters dialog box, in the Performance object drop-down list, select SQLServer.GeneralStatistics.
Click Add and now you can monitor the performance.