buffer waits. questions for GURU's
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: buffer waits. questions for GURU's

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    Red face

    Does very high buffer gets always mean low busy buffer waits?

    Please explain why

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Buffer wait occours when you don't have sufficient number of buffers available to load the data. Busy wait occours when the buffer need is dirtied and the system is awaiting DBWR to write to the disk. Now Comming to the point, I don't see how a low busy wait could trigger a high buffer wait. Normally, its the high busy wait that would trigger the buffer wait. I could be wrong ...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width