Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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

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


asked 21 Nov '15, 14:51

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

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

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 21 Nov '15, 14:51

question was seen: 2,249 times

last updated: 24 Nov '15, 08:24