SolarWinds Database Performance Analyzer

We used SolarWinds Database Performance Analyzer to monitor our database clusters. Databases that are mission critical to our organization. As the head of the department, I need to be proactive and be alert when a situation happens. My team can't be running monitoring tools on each application or hardware. The best way is to monitor the performance, when something are jumping out of the baseline then we know.

• positive, as the IT head. I like it to be imformed.

Enterprise Service Desk

Spitfire deploys a software platform backed by a Microsoft SQL Database with over 140 tables and more than 650 procedures. The size of the database typically surpasses millions of records and several hundred GB. SQL creates query plans that differ for each client depending upon their unique distribution of data. Some have only a few dozen projects a year - others a couple of thousand. Clients create budgets with different levels of detail and then create material purchases - sometimes one line each, others 500 lines. So a one-size-fits-all query is a challenge. SolarWinds Database Performance Analyzer gives us real-time, ongoing visibility into the performance of our queries across a real-world deployment.

• It is not uncommon to identify a query that is taking 70 seconds and reduce it to under a second. It sounds crazy, but it is true.
• Improving a SQL bottleneck benefits more than just one specific use case! Overall responsiveness of the application improves.

Microsoft SQL Server

We are using Solarwinds Database Performance Analyzer for few of our customers to help in monitoring their Database Environment which includes Microsoft SQL, Postgre SQL, Oracle etc. Solarwinds DPA is primarily used by Database Administrators, Application Engineers (Read Only) and Tools Administrators. There are few interaction with Key Management stakeholders for data analysis but its relatively less.

• Multi Vendor Database Monitoring
• API Integration with Ticketing Tools
• Rich Raw data for reporting
• Flexibility to run DPA on relatively less configuration server

System Center Operations Manager, LogicMonitor, Dynatrace

We use DPA to manage a very large and somewhat cranky SQL environment for ambulatory healthcare end users (from providers and office managers to assistants and front desk personnel). The DB schema dates to the 1990s and requires regular supervision and management at a level the system vendor doesn't provide. Addressed problems include plan management, index addition and revision, partitioning and troubleshooting poor performance.

• DPA allows our DBA to be more agile and find solutions to SQL problems faster. This results in better service to our end users, and better performance on the EHR system to our providers, allowing them to complete chart service for a patient much faster.

Our e-commerce platform = crown jewels (i.e. all revenue flows in via website). Knowing the in/outs of DB performance is a business requirement.

DPA is a *tremendous* tool. It provides a deep dive across all critical metrics on our ORA RDS & EC2. I find the table/query advisories to be of great use.

Would deploy across any DB if I could - the info is gold.

• ROI would be a good widget to add on. Agari has this baked in - figure you could figure that out.

Agari Phishing Defense, Nessus