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
Table Tuning Advisors
Aggregate inefficient workload at the table level so that DBAs and developers can see what tuning steps they should take. Features to support 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. Table Tuning Advisors also look across inefficient SQL statements and plans to determine if they have common SQL Server® index recommendations. Table Tuning Advisors can help determine how valid they are and if they impact multiple SQLs.
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.
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 Rob Mandeville's session “Five DevOps Essentials for Better DBA and Developer Collaboration” at PASS Summit
Five DevOps Essentials for Better DBA and Developer Collaboration
For many software-as-a-service (SaaS) and web-enabled businesses, database performance issues in production can cause a steady, relentless drain in business performance. In fact, some estimate that as much as 70% of application performance problems are caused by database problems. These problems that plague application performance have much in common with the problems that have led many CIOs to adopt agile development practices and DevOps approaches to streamlining service delivery.
In this presentation, SolarWinds database evangelist Janis Griffin describes specific actions that can build a proactive application and database performance monitoring practice, which can be shared throughout the development of IT organizations. Such a proactive approach serves to demonstrate the strategic value of IT in developing and delivering business-driven services, and can contribute significantly to an organization’s overall success.
Rob Mandeville is a Senior DBA with over 15 years of broad experience in database technologies. He has served in many roles, including production DBA, development DBA, and architect/data modeler on a variety of platforms. Before coming to SolarWinds, Rob worked in the aerospace, global technology, and geospatial industries. Rob also had the honor of teaching database-related, Master’s-level courses at Regis University.