Wednesday, July 15, 2015

"Latch free"/"Real-time plan statistics latch" wait events seen during slow system performance

Tonight provides us an opportunity to learn more about the SQL Monitor interface from MOS document "Slow Performance Featuring Contention on "latch free" with "Real-time plan statistics latch" Having the Most Sleeps and Causing High Operating System Activity" by searching for article ID 2030320.1 which will lead you not only to the Database SQL Tuning Guide if you were not already familiar with it, but ALSO the section detailing the Real-Time SQL Monitoring and Real-Time Database Operations.  Why would you be concerned with this?  Well, do you know how your system is setup to monitor SQL?  Would you like to AND feel comfortable that this feature will not cause you problems in the future?

No comments:

Post a Comment