On-demand webcast series: Sherlock Holmes

You’re the Sherlock Holmes of IT, always in demand to solve performance mysteries. But even Sherlock needed Watson to do the footwork for him. In the same way, you need smart tools to keep your database environment running efficiently, so you can spend less time on menial tasks and more time on strategic initiatives. In this first episode, we’ll explore the Foglight® Performance Investigator analytics toolset and how it’ll make you the ultimate database detective. 

In this session, we’re setting up a coding crime lab to investigate plan change. Because running SQL statements with the right execution plan is crucial for database performance. But in some cases, due to various reasons, such as object changes and statistics changes, the database may pick the wrong execution plan. We’ll explore how Foglight Performance Investigator can simplify execution plan analysis and provide powerful clues that help DBAs and developers better understand execution plans.

We’re bringing blocking locks into the interrogation room in this final installment of our webcast series. Blocked SQL statements are a common cause for database performance issues. When an application is poorly written, lock issues can impact the application’s performance. Having the right tool to diagnose lock issues is essential. We’ll show you how Foglight Performance Investigator makes it easy to resolve the root cause of lock issues, bringing law and order back to your database environment.