sysprofile.pagreads value decreases 
Author Message
 sysprofile.pagreads value decreases

I've been monitoring the sysprofile.pagreads value of our database throughout the day and have noticed that this value will increase to the 3 to 4 million range and then quickly drop to just above a million.  What reasons could there be for this value dropping?  Shouldn't it always be an increasing value since reads only accumlate?  Is there some limitation on the size of this value that it is reaching?  (That was my initial thought but there doesn't appear to be a pattern in when it drops.)

Kevin
7.31.UC7



Tue, 22 Jun 2004 03:18:25 GMT
 sysprofile.pagreads value decreases

I had the same on a client prod server, the KBR which was automagically
monitored went negative.  It seems to be a bug, ITS suggested an upgrade

Quote:

> I've been monitoring the sysprofile.pagreads value of our database throughout the day and have noticed that this value will increase to the 3 to 4 million range and then quickly drop to just above a million.  What reasons could there be for this value dropping?  Shouldn't it always be an increasing value since reads only accumlate?  Is there some limitation on the size of this value that it is reaching?  (That was my initial thought but there doesn't appear to be a pattern in when it drops.)

> Kevin
> 7.31.UC7

--
Paul Watson             #          
Oninit Ltd              # Growing old is mandatory
Tel: +44 1436 672201    # Growing up is optional
Fax: +44 1436 678693    #
www.oninit.com          #


Wed, 23 Jun 2004 03:16:38 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. decreasing the seed value of Identity column

2. Questions about sysprofile in sysmaster?

3. Sysprofiles + onstat -p : ovuserthreads

4. Ratio (bufwrites + pagreads)/buffwts

5. sysptprof: bufreads, pagreads and isreads ?

6. problem with onstat -p "pagreads" value decrementing

7. @@trancount doesn't decrease after rollback

8. decrease transaction log

9. decrease run time for querying from linked server

10. How do I decrease Transaction log size?

11. Decrease Costs in INSERTS/UPDATES Queries.

12. Decrease length field


 
Powered by phpBB® Forum Software