[MUSIC PLAYING] Hi, I'm Nicole Tamms, Senior Product Marketing Manager for Dell. And today I'm going to talk about diagnosing performance bottlenecks in enterprise database environments. Let's start the session by going to Dell XPS One touchscreen and mapping out the capabilities of an effective performance diagnostic solution. First, the solution should let your DBAs easily visualize database performance.
Database performance inefficiency results in slow response times and can lead to downtime, which can be very costly to your business. An analyst estimates 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. And 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, and affective performance diagnostic solution must integrate with other solutions and share diagnostic data with the development and enterprise level monitoring tools. So now that we've covered the requirements of an effective performance diagnostic solution, let's switch to a new board and see how you can proactively diagnosed database performance bottlenecks with Spotlight, the real time graphical diagnostics tool from Dell.
DBAs can visualize database performance in real time with Spotlight's rich graphical interface and can see the data flow rate 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 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 from Dell, including the Toad family of database productivity tools, SQL Optimizer for automated SQL performance tuning, and Foglight Performance Analysis or performance monitoring. Because Spotlight is such a visual tool, I also want to show you a couple of screenshots 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 SQL 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 down time with Spotlight, visit Quest.com/Spotlight. Thanks for watching.