[MUSIC PLAYING] Hi, I'm Nicole Tamms, Senior Product Marketing Manager. And today I'm going to talk about diagnosing performance bottlenecks in Enterprise Database Environments. Let's start the session by mapping out the capabilities of an effective performance diagnostic solution.
First, the solution should let your DBAs easily visualize database performance. Database performance and efficiency results in slow response times, and can lead to downtime, which can be very costly to your business. And analysts estimate between 60% and 90% of database performance issues are actually related to the underlying SQL code. So DBAs can save time and money with a solution that identifies the source of performance issues, even down to line of code.
Second, the solution should help DBAs support multiple platforms. That means letting them manage the diverse groups of databases and larger data sets they're responsible for on a daily basis, and meet their SLAs and ensure availability, regardless of their expertise with the various platforms they're responsible for. Next, an effective solution has to help DBAs prevent inefficiencies and outages in the first place. Most performance bottlenecks don't become apparent until after they've impacted end users, when they can be up to 10 times more expensive to fix.
So an effective solution is one that helps DBAs avoid going into the reactive firefighting mode. By providing predictive diagnostics, DBAs can resolve problems before they affect your end users. An effective solution must also help your DBAs quickly pinpoint the cause of performance bottlenecks. Certainly, the solution should identify the nature of the issue. But it should also let your DBAs drill down to the root cause, even to the SQL code level. Finally, an effective performance diagnostic solution must integrate with other solutions and share diagnostic data with the development and Enterprise level monitoring tools.
So now that we have covered the requirements of an effective performance diagnostic solution, let's switch to a new board and see how you can proactively diagnose database performance bottlenecks with Spotlight, the real time graphical diagnostics tool. DBAs can visualize database performance in real time with Spotlight's rich graphical interface, and can see the data flow between the individual database components with animated illustrations that show CPU, memory, and storage resources. DBAs can also instantly identify performance bottlenecks with audible and visual alerts that signal when a component begins to exceed preset performance thresholds. DBAs can support multiple databases with Spotlight's support for multiple platforms, including Oracle, Oracle RAC, Exadata through the Toad DBA Suite for Oracle, SQL Server, Sybase, IBM DB2 LUW, and MySQL.
DBAs can also prevent performance bottlenecks and end user complaints with Spotlight. They can predict the future performance of individual SQL statements with Spotlight based on current contention rates, and predict system resource requirements through Spotlight's performance modeling. Spotlight also allows DBAs to more quickly pinpoint the root cause of performance issues, with enhanced top SQL drill down that identifies which statements are consuming the most resources. And finally, Spotlight also integrates with several other database development and monitoring tools, including the Toad family of database productivity tools, SQL Optimizer for automated SQL performance tuning, and Foglight Performance Analysis for performance monitoring.
Because Spotlight is such a visual tool, I also want to show you a couple of screen shots that highlight Spotlight's rich user interface. This is the Spotlight overview screen where you can visualize any bottlenecks and see when an object is trending toward an impending bottleneck. Once you've identified a problem, you can click on any component and drill down to the root cause, even down to the line of code causing the issue. By drilling down, DBAs can also see execution rates, time intervals, data volumes, and the top user sessions that are consuming the most resources
Spotlight on Single Server Enterprise Edition lets you connect to multiple SQL Server instances and provides this heat map view, which allows you to see the severity of the alarms on all of your SQL Server instances and drill down into each to see the underlying performance issue. To learn how you can quickly and easily identify performance issues, predict database inefficiencies, and help prevent end user problems and downtime with Spotlight, visit quest.com. Thanks for watching.