What is PROPERTY ( 'CompletedReq')?

[Breck_Carter]

...and how is it different from PROPERTY ( 'Req' ) other than being much larger?

SELECT PROPERTY( 'CompletedReq' ), PROPERTY( 'Req' );

PROPERTY('CompletedReq'),PROPERTY('Req')
'15843','10901'

[Former Member]

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.

[Breck_Carter]

You can convert your comment to a question... I just noticed the new icon.

[VolkerBarth]

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?

[graeme_perrow]

I've fixed the question you converted.