...and how is it different from PROPERTY ( 'Req' ) other than being much larger?
SELECT PROPERTY( 'CompletedReq' ), PROPERTY( 'Req' ); PROPERTY('CompletedReq'),PROPERTY('Req') '15843','10901'
asked 21 Nov '15, 14:51
Req is the total number times the server started processing a request that came from a connection. This could be higher than the actual number of requests because the server might start processing a request more than once.
CompletedReq is the total number of times the server finished processing any request, which includes internally-generated requests. This will count each request only once.
The reason CompletedReq would be larger than Req is that it includes internally-generated requests. This includes, for example, the cleaner, events, etc.... Depending on your criteria, CompletedReq may give a better overall impression of how much work is getting done by the server.
answered 23 Nov '15, 14:12