Your database is slow, almost to the point of non-responsive. The sessions are all waiting for latch contention. How do you diagnose and resolve the issue? In this session you will learn what latches and mutextes are and how they create problems. It will also present an example of a real issue encountered earlier and how it was resolved with actual code and output. At the end, attendees will be able to do their own troubleshooting with ease. All the concepts will be explained with live demos and scripts will be downloadable.
Value
Latch contention is a potentially serious detriment to the database performance but most users have little idea how to properly diagnose it. This session aims to assist the users with a proper understanding of latches and scripts to help in the troubleshooting. Finally, live demos will further cement the understanding.