ProActive DBA: A Better Performance Monitor
Posted: 2014-08-19
- Innovation – Over the past few years, we have been laser focused on improving and expanding the ProActive DBA family. Here are some of the new products we’ve introduced:TimeLine – a continuous performance monitoring solution that helps identify the root-cause of performance problemsSQL Capture – a no-impact SQL capturing solution that uses network sniffing instead of tracingDiagnostic Monitor – a real-time low-level performance monitor for SAP Sybase ASE
Database Auditor – a no-impact data access auditing solution that can be used for SOX and HIPPA compliance
ProActive DBA Warehouse – an aggregated performance warehouse for analyzing all of the SQL activity and performance metrics we’ve collected in your enterprise. You can obtain high-level baseline and comparison reports on CPU, Disk, Network and many other metrics. And, you can obtain baselines on any SQL query or stored procedure. This valuable data can be used to identify performance problems that will occur if you upgrade your database to a newer version and it will help you pin-point the SQL or procedures responsible.
Ask yourself: Is your performance monitor keeping pace with the complexity of performance problems in the industry? Aside from updates to keep their products functioning on newer database versions, has the vendor released any innovative products in the last 5 or 10 years?
- Last Man Standing – ProActive DBA monitors some of the busiest servers in the world where there is no time for downtime!We’ve seen situations where a database server is so busy that you get timeouts when trying to connect or when executing simple queries like sp_who or select * from sysprocesses. And, performance monitors that rely on the SAP ASE MDAs or MSSQL DMVs can become victims of the performance problem and will be unable to provide you with any details about the cause of the root-cause.ProActive DBA does not rely on a single source for its performance data. It gets the job done and provides useful information about the cause of performance problems.Ask yourself: Does your performance monitor get “bricked” when the database server has major performance issues?
- Choice – because ProActive DBA uses multiple methods to monitor your database server, we give you the choice to pick where our performance data comes from. So, if your organization doesn’t allow you to use the MDA tables on Production servers, then we are the only performance monitor you can use.Ask yourself: Does your performance monitor rely solely on the MDA tables?
- Information – only good quality performance data can be turned into information to help you identify the root-cause of performance problems. The MDAs and DMVs provide very good data, but for some types of data, there are more accurate sources. This is why ProActive DBA collects data from multiple sources to make sure you have the best data available to make informed decisions.Ask yourself: Where does your performance monitor get its data from?
- Ultra-light weight – when your database server is staring into the abyss a of major performance problem, the performance monitor shouldn’t push it over the edge. ProActive DBA is the lightest weight performance monitor available.Ask yourself: How much overhead does your performance monitor incur on your Production server?