Solution Overview
SolarWinds Database Performance Analyzer
Database and SQL query performance monitoring, analysis, and tuning
At A Glance
SolarWinds® Database Performance Analyzer (formerly Confio Ignite) is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of database operations.
Features Overview
- Expert database and SQL query tuning advisors
- Identify database problems in real-time
- True root cause analysis
- Cross-vendor database support from a single interface
- Low overhead on monitored databases
- Blocking and deadlock analysis
Key Features
Expert database and SQL query tuning advisors
Expert tuning advisors.
SQL query tuning advice for all skill levels helps both novices and experts quickly determine how to tune.
Identify database problems in real-time
Monitors every active session, every second.
A granular polling engine details exactly what’s happening in your database without loading on monitored instances.
True root cause analysis
Multi-dimensional analysis isolates root cause of complex issues.
Correlate wait times, queries, users, files, plans, objects, storage, and time to pinpoint problems.
Cross-vendor database support from a single interface
Monitor all your databases from a single installation.
Monitor Microsoft SQL Server, Oracle, MySQL, PostgreSQL, DB2, and ASE on-premises, virtualized, and in the cloud.
Low overhead on monitored databases
Scalable, agentless architecture.
Whether you are monitoring one or hundreds, DPA Central consolidates performance metrics from thousands of instances.
Blocking and deadlock analysis
Integration with Orion® Platform.
View database performance in the context of nodes and applications by integrating with Server & Application Monitor.
Resources
| GSI Commerce Internet Retail GSI Commerce, a leading provider of e-commerce solutions for retailers, branded manufacturers, entertainment and professional sports organizations, employs Database Performance Analyzer to ensure its Oracle database instances can handle peak loads in high-volume online shopping applications. |
|
| Liquid Digital Media Performance Liquid Digital Media uses Database Performance Analyzer to meet its service commitments to its music download customers by quickly identifying and resolving bottlenecks in its Oracle database instances. |
|
| Fortune 200 Bank Builds Database Performance into Application Development Learn how one of the largest U.S. banks, ranked at 165 on the Fortune 165 list, uses Database Performance Analyzer to gain actionable insights about the performance of its database instances-and the direct impact to its customers-without requiring privileged access to secure production databases or servers |
|
| ProLogis Service Response Acceleration ProLogis, the world’s largest owner, manager and developer of distribution facilities, improved the overall performance of its application 25% by using Database Performance Analyzer to proactively monitor performance in real time, and reduce time to respond and resolve support calls. |
|
| Indiana University Speeds Performance Tuning and Diagnostics With more than 110,000 students, 19,600 employees, eight campuses and 200 research centers, Indiana University uses Database Performance Analyzer to monitor and quickly resolve performance issues on its enterprise-critical Oracle and SQL Server databases running on VMware. |
|
| Financial Organization Boosts Performance with Oracle Databases This U.S. based, Fortune 100 financial services organization with diversified operations in property, casualty and life insurance markets, uses Database Performance Analyzer to boost performance, reduce costs, and improve service of its Oracle databases. |
|
| Case: Norway’s largest auto glass company sees clearly with the help of SolarWinds Andr. L. Riis AS is the largest supplier and fitter of windscreens in Norway. Erik Olne, Andr. L. Riis AS CIO joined the company three years ago and began an intensive renewal program to modernize the company’s IT infrastructure. As the rebuilding phase came to an end, Olne and his team turned their attention to network performance and began looking for a software solution that would help to analyze and maintain their newly built infrastructure. |
| Datasheet: Database Performance Analyzer for Oracle SolarWinds® Database Performance Analyzer for Oracle is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of Oracle operations |
|
| Datasheet: Database Performance Analyzer for SQL Server SolarWinds® Database Performance Analyzer for SQL Server is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of SQL Server operations |
|
| Datasheet: Database Performance Analyzer for IBM DB2 SolarWinds® Database Performance Analyzer for DB2 LUW is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of DB2 LUW database operations. |
|
| Datasheet: Database Performance Analyzer for Sybase SolarWinds® Database Performance Analyzer for Sybase ASE is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of Sybase ASE operations. |
|
| Datasheet: Database Performance Analyzer (formerly Confio Ignite) The SolarWinds® family of database performance solutions improve the productivity and efficiency of IT organizations worldwide. By resolving customer problems faster, speeding development cycles, and squeezing more performance out of expensive database systems running on physical or virtual servers, SolarWinds Database Performance Analyzer (formerly Confio Ignite) makes DBA and development teams more valuable to the IT organization |
|
| Datasheet: Database Performance Analyzer for VM Option SolarWinds® Database Performance Analyzer – VM Option is a performance monitoring tool for database administrators running databases on VMware, helping them achieve high performance and reliability. |
|
| Datasheet: Database Performance Analyzer for MySQL SolarWinds® Database Performance Analyzer (formerly Confio® Ignite) for MySQL® is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers.Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces the overall costs of database operation |
| MySQL Performance Tuning – 12 Step Guide Find and fix query performance faster with SolarWinds Database Performance Analyzer | |
| Oracle Query Performance Tuning: A 12-Step Program Unlike trying to speed Oracle performance by through system-level server tuning, query tuning can have immediate and powerful results, offering as much as 10x increase in performance! Learn the 12 key steps to successful query tuning in this infographic. |
|
| 8 Tips for Faster SQL Server Performance: Without the Expense of Over-provisioning Rapidly declining costs in memory and storage can make it seem attractive to tackle database performance issues by provisioning new hardware. But throwing hardware at slow performance doesn’t always make the database faster. Learn what you can do to assess the true cause of slow performance, and 8 things that will speed performance without new hardware |
|
| How Will DBAs Handle Big Data? What’s hype and what’s fact in the Big Data landscape for the DBA? While the hype is that Big Data will replace relational database management systems (RDBMSs), the fact is that RDBMS is a fundamental technology in most Big Data projects and will continue to be a significant investment. This infographic clarifies the challenges DBAs face in increasingly complex data environments and underscores the need for exceptional and proactive RDBMS performance. |
|
| SQL Server Query Performance Tuning: A 12-Step Program Unlike trying to speed SQL Server performance by through system-level server tuning, query tuning can have immediate and powerful results, offering as much as 10x increase in performance! Learn the 12 key steps to successful query tuning in this infographic. |
| eBook: DBA Survivor Guide: Your First 100 Days This Survivor’s Guide will help you determine how to get started and help you plan for your first 100 days! |
|
| SolarWinds Database Performance Analyzer or Oracle Enterprise Manager? The DBA says the answer is both! The combination of OEM and DPA provides the kind of help DBAs need to better understand database performance issues and save time, money, and frustration. |
|
| SQL Server 2014 Install Guide (by Tom LaRock) This paper discusses best practices and tips for installing and configuring SQL Server 2014 for optimal performance. |
|
| SQL Query Tuning for SQL Server Authored by Dean Richards, Senior DBA, the SQL tuning methods presented in this detailed paper follow a simple, repeatable, four-step process. Several tuning case studies help illustrate how the method works in real applications. This methodology is a valuable time saver because it will help you get it right the first time. |
|
| Response Time Analysis – A Pragmatic Approach for Tuning and Optimizing Oracle Database Performance Response time analysis is an approach that enables DBAs to measure the time spent on query execution and, therefore, measure the performance impact on end users. In this paper, Senior DBA Dean Richard describes response time analysis in detail and provides an overview of the tools available for effective response time analysis within an Oracle database environment |
|
| 5 Risks for Databases on VMware Virtualization makes it much more difficult for DBAs to see the interaction between the database and the underlying server resources. Here are five scenarios that merit attention for DBAs with VMware. |
|
| Monitoring Database Performance on VMware Databases are one of the last frontiers for virtualizing into a VMware environment. They can be very resource intensive, so many companies have been hesitant to move them into a virtual environment. Most of the hesitation has come from poor experiences during initial tests of VMware. Many of our customers are successfully running databases inside VMware and the key for them was monitoring the correct metrics that can help show where the bottlenecks are. This paper will review the VMware metrics that helped many companies have a far better virtualization experience. |
|
| Checklist for SQL Server® 2014 Upgrade: Ensuring the Best Outcome for Your Upgrade This whitepaper will help you create a list of pre- and post-installation tasks to complete when migrating your database server to SQL Server 2014. Preparing and following a checklist is likely to help you avoid most, if not all, potential upgrade issues |
|
| Checklist for SQL Server 2012 Upgrade: Top 11 Tips It can be a daunting task to put together everything you need in a pre-upgrade checklist. This paper compiles the top eleven items that you should include in any checklist for migrating your database server to SQL Server 2012. Including these items is likely to help you avoid many potential upgrade issues. |
|
| SQL Server Query Tuning: A 12-Step Program In this white paper, Tom LaRock, Technical Evangelist and SQL Server MVP, demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the basics and moving to more advanced query tuning techniques like indexing. When you apply this process from start to finish, you will improve query performance in a measurable way, and you will know that you have optimized the query as much as is possible. |
|
| Oracle Exadata Performance – Yes. You still need to tune. One of the selling points of Exadata is that you just install it, drop all your indexes and it will increase your database performance significantly all within about a week. Although part of this statement is correct, if you only follow these steps, not only do you open the door for specific queries to run slower at the start, but there is a good chance even some of the queries that are running ok now will exponentially get worse. |
|
| DevOps Essentials for DBAs and Developers Many CIOs have embraced the need to reposition the IT organization as a strategic component of delivering world-class products and services. For CIOs in SaaS or Web-enabled businesses, an important element in this effort is the transformation from reactive to proactive application performance monitoring and management. This is accomplished by building performance into development from the start and breaking down the silos that separate teams, from architects to developers to QA to DBAs to systems administrators. |
|
| Oracle RAC on VMware with DRS and HA Oracle’s evolving support and licensing policies for Oracle RAC on VMware means you can realize the benefits of virtualization– reducing IT costs while increasing the efficiency, utilization, and flexibility of your existing assets—without risk. |
|
| Oracle RAC Tuning Tips: There is More to Know There are differences between performance tuning on a RAC database versus a single instance. In this paper, Kathy Gibbs, Sr. Oracle DBA, will explore the RAC-only waits as well as some tuning suggestions for code to help your RAC environment run more smoothly. |
|
| SQL Query Tuning for Oracle – Getting It Right the First Time Authored by Dean Richards, Senior DBA, the SQL tuning methods presented in this paper are derived from years of SQL tuning and Oracle database performance consulting. The methodology follows a simple, repeatable, four-step process and is a valuable time saver because you’ll get it right the first time. |
|
| Improve SQL Server Performance Management with Extended Events: A Guide to Getting Started Microsoft SQL Server Extended Events, a replacement for Trace, can provide you with a useful and very customizable framework for managing very technical, low-level event information about a SQL Server database and its instances. In this white paper, Janis Griffin, Senior DBA at Confio, explores how Extended Events are different than Trace, how to best use them as a deep-dive, complementary tool to a lightweight continuous performance monitoring solution such as Confio Ignite, and guidelines for getting started with them. |
|
| Response Time Analysis: A Pragmatic Approach for Tuning and Optimizing Database Performance Response time analysis is an approach that enables DBAs to measure the time spent on query execution and, therefore, measure the performance impact on end users. In this paper, you’ll learn about response time analysis in detail and get an overview of the tools available for effective response time analysis within an Oracle, SQL Server, SAP ASE or DB2 database environment. |
|
| Five Concerns for Production Databases in the Cloud This paper discusses five key concerns that every company should consider when weighing the costs, benefits, and risks of migrating their production database servers to the Cloud, including platform capabilities, data security, total costs (including sometimes hidden costs), recovery options and ability to proactively manage database performance in the Cloud. |
|
| A Comparison of Oracle Performance on Physical and VMware Servers To evaluate the difference in Oracle operation between physical and VMware servers, a direct head-to-head comparison of transaction performance was conducted using both scenarios at separate times on the same physical server. By illustrating how a DBA can visualize the response time, query throughput, and server resources utilized in both scenarios, this paper demonstrates how a DBA team can effectively monitor Oracle on VMware to ensure continued performance. |
- Case Studies
-
GSI Commerce Internet Retail
GSI Commerce, a leading provider of e-commerce solutions for retailers, branded manufacturers, entertainment and professional sports organizations, employs Database Performance Analyzer to ensure its Oracle database instances can handle peak loads in high-volume online shopping applications.Liquid Digital Media Performance
Liquid Digital Media uses Database Performance Analyzer to meet its service commitments to its music download customers by quickly identifying and resolving bottlenecks in its Oracle database instances.Fortune 200 Bank Builds Database Performance into Application Development
Learn how one of the largest U.S. banks, ranked at 165 on the Fortune 165 list, uses Database Performance Analyzer to gain actionable insights about the performance of its database instances-and the direct impact to its customers-without requiring privileged access to secure production databases or serversProLogis Service Response Acceleration
ProLogis, the world’s largest owner, manager and developer of distribution facilities, improved the overall performance of its application 25% by using Database Performance Analyzer to proactively monitor performance in real time, and reduce time to respond and resolve support calls.Indiana University Speeds Performance Tuning and Diagnostics
With more than 110,000 students, 19,600 employees, eight campuses and 200 research centers, Indiana University uses Database Performance Analyzer to monitor and quickly resolve performance issues on its enterprise-critical Oracle and SQL Server databases running on VMware.Financial Organization Boosts Performance with Oracle Databases
This U.S. based, Fortune 100 financial services organization with diversified operations in property, casualty and life insurance markets, uses Database Performance Analyzer to boost performance, reduce costs, and improve service of its Oracle databases.Case: Norway’s largest auto glass company sees clearly with the help of SolarWinds
Andr. L. Riis AS is the largest supplier and fitter of windscreens in Norway. Erik Olne, Andr. L. Riis AS CIO joined the company three years ago and began an intensive renewal program to modernize the company’s IT infrastructure. As the rebuilding phase came to an end, Olne and his team turned their attention to network performance and began looking for a software solution that would help to analyze and maintain their newly built infrastructure. - Data Sheets
-
Datasheet: Database Performance Analyzer for Oracle
SolarWinds® Database Performance Analyzer for Oracle is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of Oracle operationsDatasheet: Database Performance Analyzer for SQL Server
SolarWinds® Database Performance Analyzer for SQL Server is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of SQL Server operationsDatasheet: Database Performance Analyzer for IBM DB2
SolarWinds® Database Performance Analyzer for DB2 LUW is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of DB2 LUW database operations.Datasheet: Database Performance Analyzer for Sybase
SolarWinds® Database Performance Analyzer for Sybase ASE is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers. Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces overall cost of Sybase ASE operations.Datasheet: Database Performance Analyzer (formerly Confio Ignite)
The SolarWinds® family of database performance solutions improve the productivity and efficiency of IT organizations worldwide. By resolving customer problems faster, speeding development cycles, and squeezing more performance out of expensive database systems running on physical or virtual servers, SolarWinds Database Performance Analyzer (formerly Confio Ignite) makes DBA and development teams more valuable to the IT organizationDatasheet: Database Performance Analyzer for VM Option
SolarWinds® Database Performance Analyzer – VM Option is a performance monitoring tool for database administrators running databases on VMware, helping them achieve high performance and reliability.Datasheet: Database Performance Analyzer for MySQL
SolarWinds® Database Performance Analyzer (formerly Confio® Ignite) for MySQL® is a comprehensive database performance monitoring and analysis solution for DBAs, IT managers, and application developers.Database Performance Analyzer eliminates performance bottlenecks, improves application service, and reduces the overall costs of database operation - Infographics
-
MySQL Performance Tuning – 12 Step Guide Find and fix query performance faster with SolarWinds Database Performance Analyzer Oracle Query Performance Tuning: A 12-Step Program
Unlike trying to speed Oracle performance by through system-level server tuning, query tuning can have immediate and powerful results, offering as much as 10x increase in performance! Learn the 12 key steps to successful query tuning in this infographic.8 Tips for Faster SQL Server Performance: Without the Expense of Over-provisioning
Rapidly declining costs in memory and storage can make it seem attractive to tackle database performance issues by provisioning new hardware. But throwing hardware at slow performance doesn’t always make the database faster. Learn what you can do to assess the true cause of slow performance, and 8 things that will speed performance without new hardwareHow Will DBAs Handle Big Data?
What’s hype and what’s fact in the Big Data landscape for the DBA? While the hype is that Big Data will replace relational database management systems (RDBMSs), the fact is that RDBMS is a fundamental technology in most Big Data projects and will continue to be a significant investment. This infographic clarifies the challenges DBAs face in increasingly complex data environments and underscores the need for exceptional and proactive RDBMS performance.SQL Server Query Performance Tuning: A 12-Step Program
Unlike trying to speed SQL Server performance by through system-level server tuning, query tuning can have immediate and powerful results, offering as much as 10x increase in performance! Learn the 12 key steps to successful query tuning in this infographic. - White Papers
-
eBook: DBA Survivor Guide: Your First 100 Days
This Survivor’s Guide will help you determine how to get started and help you plan for your first 100 days!SolarWinds Database Performance Analyzer or Oracle Enterprise Manager?
The DBA says the answer is both! The combination of OEM and DPA provides the kind of help DBAs need to better understand database performance issues and save time, money, and frustration.SQL Server 2014 Install Guide (by Tom LaRock)
This paper discusses best practices and tips for installing and configuring SQL Server 2014 for optimal performance.SQL Query Tuning for SQL Server
Authored by Dean Richards, Senior DBA, the SQL tuning methods presented in this detailed paper follow a simple, repeatable, four-step process. Several tuning case studies help illustrate how the method works in real applications. This methodology is a valuable time saver because it will help you get it right the first time.Response Time Analysis – A Pragmatic Approach for Tuning and Optimizing Oracle Database Performance
Response time analysis is an approach that enables DBAs to measure the time spent on query execution and, therefore, measure the performance impact on end users. In this paper, Senior DBA Dean Richard describes response time analysis in detail and provides an overview of the tools available for effective response time analysis within an Oracle database environment5 Risks for Databases on VMware
Virtualization makes it much more difficult for DBAs to see the interaction between the database and the underlying server resources. Here are five scenarios that merit attention for DBAs with VMware.Monitoring Database Performance on VMware
Databases are one of the last frontiers for virtualizing into a VMware environment. They can be very resource intensive, so many companies have been hesitant to move them into a virtual environment. Most of the hesitation has come from poor experiences during initial tests of VMware. Many of our customers are successfully running databases inside VMware and the key for them was monitoring the correct metrics that can help show where the bottlenecks are. This paper will review the VMware metrics that helped many companies have a far better virtualization experience.Checklist for SQL Server® 2014 Upgrade: Ensuring the Best Outcome for Your Upgrade
This whitepaper will help you create a list of pre- and post-installation tasks to complete when migrating your database server to SQL Server 2014. Preparing and following a checklist is likely to help you avoid most, if not all, potential upgrade issuesChecklist for SQL Server 2012 Upgrade: Top 11 Tips
It can be a daunting task to put together everything you need in a pre-upgrade checklist. This paper compiles the top eleven items that you should include in any checklist for migrating your database server to SQL Server 2012. Including these items is likely to help you avoid many potential upgrade issues.SQL Server Query Tuning: A 12-Step Program
In this white paper, Tom LaRock, Technical Evangelist and SQL Server MVP, demystifies query tuning by providing a rigorous 12-step process that database professionals at any level can use to systematically assess and adjust query performance, starting from the basics and moving to more advanced query tuning techniques like indexing. When you apply this process from start to finish, you will improve query performance in a measurable way, and you will know that you have optimized the query as much as is possible.Oracle Exadata Performance – Yes. You still need to tune.
One of the selling points of Exadata is that you just install it, drop all your indexes and it will increase your database performance significantly all within about a week. Although part of this statement is correct, if you only follow these steps, not only do you open the door for specific queries to run slower at the start, but there is a good chance even some of the queries that are running ok now will exponentially get worse.DevOps Essentials for DBAs and Developers
Many CIOs have embraced the need to reposition the IT organization as a strategic component of delivering world-class products and services. For CIOs in SaaS or Web-enabled businesses, an important element in this effort is the transformation from reactive to proactive application performance monitoring and management. This is accomplished by building performance into development from the start and breaking down the silos that separate teams, from architects to developers to QA to DBAs to systems administrators.Oracle RAC on VMware with DRS and HA
Oracle’s evolving support and licensing policies for Oracle RAC on VMware means you can realize the benefits of virtualization– reducing IT costs while increasing the efficiency, utilization, and flexibility of your existing assets—without risk.Oracle RAC Tuning Tips: There is More to Know
There are differences between performance tuning on a RAC database versus a single instance. In this paper, Kathy Gibbs, Sr. Oracle DBA, will explore the RAC-only waits as well as some tuning suggestions for code to help your RAC environment run more smoothly.SQL Query Tuning for Oracle – Getting It Right the First Time
Authored by Dean Richards, Senior DBA, the SQL tuning methods presented in this paper are derived from years of SQL tuning and Oracle database performance consulting. The methodology follows a simple, repeatable, four-step process and is a valuable time saver because you’ll get it right the first time.Improve SQL Server Performance Management with Extended Events: A Guide to Getting Started
Microsoft SQL Server Extended Events, a replacement for Trace, can provide you with a useful and very customizable framework for managing very technical, low-level event information about a SQL Server database and its instances. In this white paper, Janis Griffin, Senior DBA at Confio, explores how Extended Events are different than Trace, how to best use them as a deep-dive, complementary tool to a lightweight continuous performance monitoring solution such as Confio Ignite, and guidelines for getting started with them.Response Time Analysis: A Pragmatic Approach for Tuning and Optimizing Database Performance
Response time analysis is an approach that enables DBAs to measure the time spent on query execution and, therefore, measure the performance impact on end users. In this paper, you’ll learn about response time analysis in detail and get an overview of the tools available for effective response time analysis within an Oracle, SQL Server, SAP ASE or DB2 database environment.Five Concerns for Production Databases in the Cloud
This paper discusses five key concerns that every company should consider when weighing the costs, benefits, and risks of migrating their production database servers to the Cloud, including platform capabilities, data security, total costs (including sometimes hidden costs), recovery options and ability to proactively manage database performance in the Cloud.A Comparison of Oracle Performance on Physical and VMware Servers
To evaluate the difference in Oracle operation between physical and VMware servers, a direct head-to-head comparison of transaction performance was conducted using both scenarios at separate times on the same physical server. By illustrating how a DBA can visualize the response time, query throughput, and server resources utilized in both scenarios, this paper demonstrates how a DBA team can effectively monitor Oracle on VMware to ensure continued performance.