Grant Holman
New Member
Hi, Promon's buffer hit ratio field can be calculated using the _actbuffer VST table as follows:
(_buffer-logicrds - _buffer-osrds) / _buffer-logicrds * 100
The fields are integers therefore limited to approx 2,147,000,000 at which point they start counting back down. This continues up and down then back up etc until the db server is restarted.
Question - am I wrong to think that as soon as either of these fields reaches the Progress int limit and begins reversing it makes a nonsense of the calculation above. i.e. To get a true value you would have to restart server and monitor the calculation before it loops?
(_buffer-logicrds - _buffer-osrds) / _buffer-logicrds * 100
The fields are integers therefore limited to approx 2,147,000,000 at which point they start counting back down. This continues up and down then back up etc until the db server is restarted.
Question - am I wrong to think that as soon as either of these fields reaches the Progress int limit and begins reversing it makes a nonsense of the calculation above. i.e. To get a true value you would have to restart server and monitor the calculation before it loops?