FireBoard
Welcome, Guest
Please Login or Register.    Lost Password?
formula ratio buffer pool hit ratio (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: formula ratio buffer pool hit ratio
#7798
eric (Visitor)
Click here to see the profile of this user
Birthdate:
formula ratio buffer pool hit ratio  
Hi there, BP hit ratio = 1 - (BP physical reads / BP logical reads). If all the BP physical reads are asynchronous, it should mean that the pages are brought up to the bufferpool before the data_base_ manager needs them. But in that case, the BP hit ratio will be 0% (BP physical reads = BP async. physical reads = BP logical reads). Could this formula BP hit ratio = 1 - ((BP physical reads - BP async. physical reads) / BP logical reads) be more accurate or am I missing a point ? Thanks for your help, Eric
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    thread link
formula ratio buffer pool hit ratio
eric 2009/09/27 05:27
    thread link
thread linkthread link formula ratio buffer pool hit ratio
Ian 2009/09/27 05:27
    thread link
thread linkthread link formula ratio buffer pool hit ratio
eric 2009/09/27 05:27
    thread link
thread linkthread link formula ratio buffer pool hit ratio
PM-pm3iinc-nospam 2009/09/27 05:27
    thread link
thread linkthread link formula ratio buffer pool hit ratio
eric 2009/09/27 05:27
    thread link
thread linkthread link formula ratio buffer pool hit ratio
Todd McNeill 2009/09/27 05:27
    thread link
thread linkthread link formula ratio buffer pool hit ratio
Mark A 2009/09/27 05:27
    thread link
thread linkthread link formula ratio buffer pool hit ratio
Ian 2009/09/27 05:27
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop