Tuesday, March 18, 2008

Script for finding more about current buffer busy waits

Please find the script for finding more about current buffer busy waits.



Script2 : FIND MORE ON BUFFER BUSY WAIT EVENT


Note: Please try the script on your own risk.

2 comments:

  1. Hi, I've got a production OLTP system for work. Hope this script help's me removing my DB memory bottlenecks

    ReplyDelete
  2. Hi, Venkat, This script might be helpful to find the potential problems in your OLTP systems occuring due to the "BUFFER BUSY WAIT EVENTS".
    Regards,
    Ajith Narayanan

    ReplyDelete

Thanks for you valuable comments !