Coming back from this weekend I've noticed a very strange thing
with my database statistics. Namely, the total number of buffer
requests is a negative number (a very *large* negative number).
Has anybody seen this before? Should I be very worried?
The following is the result of a 'q db f=d':
Available Space (MB): 15,832
Assigned Capacity (MB): 15,832
Maximum Extension (MB): 0
Maximum Reduction (MB): 2,176
Page Size (bytes): 4,096
Total Usable Pages: 4,052,992
Used Pages: 3,485,725
%Util: 86.0
Max. %Util: 86.3
Physical Volumes: 8
Buffer Pool Pages: 8,192
Total Buffer Requests: -1,848,232,441
Cache Hit Pct.: 0.00
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 101.09
Percentage Changed: 0.74
Last Complete Backup Date/Time: 04/08/1997 04:25:12
"If I could dot the 'i' in a Michigan Thomas A. La Porte
game and the good lord came to take me Archivist, Feature Animation
the next day ... at least I could DreamWorks SKG
die happy." - Beano Cook, ESPN <tlaporte AT anim.dreamworks DOT com>
|