...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

Breck%20Carter's gravatar image

Breck Carter
26.6k433604879
accept rate: 21%


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.

permanent link

answered 23 Nov '15, 14:12

Phil%20Mitchell's gravatar image

Phil Mitchell
1.9k1831
accept rate: 27%

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
1

I've fixed the question you converted.

(24 Nov '15, 08:24) Graeme Perrow
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×20

question asked: 21 Nov '15, 14:51

question was seen: 613 times

last updated: 24 Nov '15, 08:24