The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

...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.6k418576824
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: 531 times

last updated: 24 Nov '15, 08:24