Database Performance Analyzer (DPA) is designed to efficiently and effectively find the bad in your database environments—and it’s proven to excel at this task time and time again. Database Performance Analyzer can also help you analyze and pinpoint the root cause of what’s driving your performance issues. Now, DPA 12.0 can do all this, plus provide the key information DBAs and developers need to make better tuning decisions and optimize their workload.
Come Learn About DPA and some of its key features:
Table Tuning Advisors
Aggregate inefficient workload at the table level so that DBAs and developers can see what tuning steps they should take. Features supporting this include indexing, query tuning, and data model adjustments. Put an “X” marks the spot on your database workload to help identify your best tuning opportunities.
Query Performance Analysis
The query hasn’t changed, so why is there so much more wait time? Query performance analysis gathers the data specific to a query so that a DBA can answer the question, “Why is this query slower?” in just one view, with one click.
Oracle® Database Registration Without SYS
One of the prominent feature requests we’ve heard from our Oracle users has been to not require SYS when registering new instances for monitoring. We listened and corrected this—success!
Come by and see a demo of the great new functionality built into DPA 12.0, as well as any other of our IT monitoring and management tools. In addition to our core IT products, we’d love to share with you our MSP and cloud-native products as well.Also, look for Janis Griffin’s session “Top Five MySQL Query Tuning Tips" at Oracle OpenWorld.
Top Five MySQL Query Tuning Tips
Query tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will share her secrets for determining the best approach for tuning queries by utilizing the performance schema (specifically instrumented wait events and thread states), query execution plans, SQL diagramming techniques, and more.
Regardless of the complexity of your database or your skill level, this systematic approach will lead you safely down the correct tuning path, so you can save countless hours of tuning queries and optimizing performance of your MySQL® databases.
- How to effectively use the performance schema to quickly identify bottlenecks and get clues on the best tuning approach
- Quickly identify inefficient operations through review of query execution plans
- How to use SQL diagramming techniques to find the best execution plan
Janis Griffin has over 25 years of DBA experience, including design, development, and implementation of many critical database applications. She is an Oracle ACE and expert on SAP ASE, SQL Server® and MySQL®. LEARN MORE