I see in Sybase Central, on Overview panel, the following information on Statistics frame:
"The current number of uncompleted I/Os issued by the server: 38 The number of requests waiting to be fulfilled: 1"
What does this information mean???? I did not find any explanation on documentatio.
asked 29 May '13, 01:47
The CurrIO property (current number of file I/Os that were issued by the server but haven't yet completed) is not reliable due to a known problem.
At least, it was an acknowledged problem as of Tue, Nov 8, 2011 (in a private email) and I've heard nothing since.
For that reason, CurrIO property, displayed under the title "Active I/O", was removed from Version 2 of Foxhound; there's no point displaying a statistic that has little relationship with reality.
At some point, the problem will surely be fixed, and subsequent releases of Foxhound will start displaying it for target databases running on servers built on or after the fix was made.
For the record, here are a couple of ancient trouble reports...
Sun, Jun 1, 2008 at 8:44 AM
11/07/2011 06:24 AM As of 22.214.171.12498 the CurrIO statistic still regularly reports bogus values like 40, 80, 101, 120 (growing) for an idle server. As such, it is pretty much useless.
Sadly, the Help still talks about watching CurrIO as if it's going to tell you something meaningful:
The value beside "The current number of uncompleted I/Os issued by the server" is the database property 'CurrIO' which is the sum of the read and write requests sent to the OS (usually hard drive access requests) that have not yet completed.
The value beside "The number of requests waiting to be fulfilled" is the 'UnschReq' server property which describes the number of requests that are currently queued waiting for a server worker thread.
Information on accessing other server properties can be found here
Information on accessing other database properties can be found here
answered 29 May '13, 15:08
Thank you guys!
I understood the CurrIO statistic is not reliable. Ok.
About the "The number of requests waiting to be fulfilled", can I do anything to solve the problem of queue of server worker thread?
answered 29 May '13, 16:17