|
...and how is it different from PROPERTY ( 'Req' ) other than being much larger? SELECT PROPERTY( 'CompletedReq' ), PROPERTY( 'Req' );
PROPERTY('CompletedReq'),PROPERTY('Req')
'15843','10901'
|
|
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. You can convert your comment to a question... I just noticed the new icon.
(24 Nov '15, 07:17)
Breck Carter
Replies hidden
So I did, and now all the comments below (including Phil's and your answers) are gone... I feel sorry, man. And that looks like a deja-vu of that question: Administrators, is it OK to use the "convert to question" button?
(24 Nov '15, 07:52)
Volker Barth
|
