Machine learning
![]() |
Learn waiting behavior automaticallyIf you rely on generally available knowledge, it is difficult for beginners to acquire. The sheer scale in larger environments prevents a deep, comprehensive understanding. Do without this knowledge and automate the understanding of normal behavior patterns with our machine learning algorithm. Prevent knowledge from leaving the company when an important employee changes jobs. Automate and maintain this knowledge so everyone on your team benefits. |
|
Extension of anomaly detection beyond peak valuesThere may be a tendency to focus on peak database performance. While this is a great way to focus on problem behaviors, it's not the only one. Variations in performance can be expected for most production databases. What is needed is a way to account for the expected fluctuations and report unexpected events. Database anomaly detection reports such events. This gives you several options to determine whether things deviate from the norm. |
![]() |
|
![]() |
Warning in the event of significant changes in behaviorDetecting anomalies is one thing, but since no one is staring at a dashboard around the clock, DPA offers the ability to alert you to any changes in behavior that are detected. Reduce false positives by lowering sensitivity to a level you are comfortable with. Then let DPA do the observation for you. DPA will let you know when the workload changes, when maintenance jobs are running during business hours, or when there are other unexpected changes that you would like to review. |
Optimization tips from experts
![]() |
More precise database optimization using response time analysisResponse time analysis provides a pragmatic approach to optimizing database performance that makes it easier for users to identify problems and achieve measurable results. With the response time analysis you can optimize the database optimization in your DBMS by identifying bottlenecks, pinpointing causes and prioritizing actions - based on the impact of insufficient database performance on end users. Every second, SolarWinds® Database Performance Analyzer (DPA) sorts SQL statement data and identifies which SQL queries to focus on. |
|
Isolate and correct poorly performing SQL statements using database tuning in SQL ServerSolarWinds DPA includes tools and functions that are specifically designed for database optimization in SQL Server and provide insights into important measurement data. Intuitive diagrams in DPA show poorly performing SQL statements, application latencies, and specific wait types / events that could lead to bottlenecks. You can also click areas of the chart to drill down on specific issues and quickly fix them. |
![]() |
|
![]() |
The next step: Optimizing databases using the Table Tuning AdvisorThe Table Tuning Advisor are designed to help you perform complex database optimizations by collecting historical data and presenting information in bar graphs. DPA's Tuning Advisor can provide database administrators with useful, actionable tips to help identify problems that require immediate action. DPA's alerts also allow you to drill down into detailed data related to a problem in real time. |
|
Take steps to optimize database performance to overcome hurdlesThe first step in optimizing database performance is locating the problem. Thanks to the SolarWinds DPA's database anomaly detection with machine learning, you can analyze the latency of your instance to identify what needs to be corrected. You can then use the SQL Tuning Advisor to analyze existing SQL statements and get recommendations for customizing the queries. By following DPA's recommendations, you can better troubleshoot database performance optimization problems, such as poor SQL code or poor connection management. |
![]() |
Support of cloud databases
![]() |
Identify problems in your database environmentProblems can arise in your database environment at any time. Let's face the truth. Nobody works in a static environment. Thanks to round-the-clock monitoring, DPA can identify peak values in waiting time behavior in several dimensions. This makes it easy to focus on the source of the bottleneck and the component involved. Database Performance Analyzer for SQL also monitors deviations from expected behavior patterns. So you can display the extent and warn based on definable precise criteria. |
|
Analysis of the performance to determine the root causeAfter you identify the major problems, you can use the analysis provided by DPA to determine the causes of the problems. Correlated resource metrics provide information on all usage problems. In-depth analysis of blocks and deadlocks enables the impact of blockages on end users to be quantified and the block structure to be visualized to determine which sessions and queries were involved, where to find the cause, and who was harmed. A query-level performance analysis brings together all available data in one view, including answering the question "Why is this query so slow now?" |
![]() |
|
![]() |
Optimize your databasesSearch and analysis is a good place to start, but the ultimate goal should be to optimize or reduce the impact in the future. However, there is not always a cure for inefficiencies. For this reason, the Database Performance Analyzer monitors real-world workloads to highlight queries that collect more data than necessary. These queries are aggregated at the table level so that you can holistically see the best optimization and indexing options. Often times, simple changes have the greatest impact on performance - you just need to know how it works. |
|
Best practices for optimizing tablesHow can you tell if your database tables are applying best practices when you have multiple tables associated with your database? DPA's Tables Optimization Best Practices will match your tables and indexes with best practices for optimizing SQL Server performance. This includes non-indexed foreign keys, indexes with overlap, wide index, tables with no defined indexes, and tables without primary keys. |
![]() |
API to manage automation
![]() |
SQL query optimizationFor effective maintenance of SQL Server and MySQL databases, use the Database Performance Analyzer (DPA) to tune SQL queries before major problems arise. With the Database Performance Analyzer, you can examine and identify inefficient queries that can lead to higher I / O values, longer latencies, deadlocks, or resource conflicts. View query details including runtime, execution statistics and relevant metrics. It is easy to mark specific SQL statements and, if necessary, exclude time-consuming SQL statements. |
|
Response time analysisUse the latency analysis feature in DPA for effective database analysis. The tool polls each instance every second to determine the active session performance and alert you to delays. If the latency of an SQL statement increases significantly, you can quickly investigate the cause. Improve the results of SQL and MySQL database maintenance by correlating the delay in executing queries with the impact on the end user. Additionally, the database anomaly detection algorithm identifies unexpected latency increases compared to normal historical data. You can use the trend graph to easily view changes over time. |
![]() |
|
![]() |
Uniform dashboardUse a straightforward dashboard to manage Windows-specific SQL Server, open source MySQL, Oracle, DB2 or SAP ASE instances. This database maintenance software combines easy-to-read bar charts and color-coded graphic displays with detailed diagnostics, custom warnings and reliable reports. Use the dashboard sharing features to investigate the impact of query optimization with other people in the organization. The entire team can analyze performance changes in on-premises, virtualized and cloud environments and leverage the agentless architecture for secure SQL development, testing and production using the DPA database performance monitoring software. |
|
Practical adviceWith detailed insights, DPA can help you formulate a database maintenance plan that will help prevent performance problems. This SQL database maintenance software is designed to take advantage of historical trends and current data, and to generate SQL Server optimization recommendations. At the end of each day, DPA performs a table optimization analysis and displays table information, inefficient queries, and indexes. Fix both minor and widespread performance issues to better prioritize those issues that need immediate attention. View details about problem queries, and learn whether to tune the query, add an index or columns, handle address fragmentation, and more. |
![]() |
|
![]() |
Automation of database maintenanceThe integrated tools for database maintenance enable monitoring around the clock without a comparable amount of work. You can use the DPA REST API to optimize basic database administration tasks and improve scalability. Set up Python or PowerShell scripts to automate critical database maintenance tasks. Database administrators can also create alerts to monitor the execution time of SQL statements and automatically flag important changes. Database Performance Analyzer is designed to help database administrators stay one step ahead of performance problems. Automatic detection of anomalies in database operations is done using an artificial intelligence algorithm. |
Analyzing database performance doesn't have to be a guessing game.
How can I optimize database performance?
How can I optimize database performance?
There are two forms of database optimization. On the one hand, the quick detection of performance bottlenecks with the determination of their causes, in connection with the prioritization of measures. The second is where you need a solution to proactively optimize low-performing applications by identifying hard-to-detect problems before they become acute.
Can I identify performance issues based on resource usage?
Can I identify performance issues based on resource usage?
The impact of resources on database performance is a critical metric that needs to be monitored and understood. DPA provides comprehensive measurement data on the computing environment, such as CPU, main memory, data carrier and network. Other database-specific measurement data include InnoDB read / write data for MySQL and DTUs for the Azure SQL database.
Where do I start optimizing my database?
Where do I start optimizing my database?
With its anomaly detection based on machine learning and advanced wait state analysis, DPA puts an end to speculation and guesswork when optimizing performance. Quickly identify the most impacting queries and inefficient workloads to increase application performance and further improve the overall database optimization.
How do I get detailed information on various factors contributing to bottlenecks?
How do I get detailed information on various factors contributing to bottlenecks?
With multi-dimensional database performance analysis, you get a central overview of all variables that have an impact on performance. From poorly worded SQL queries to inefficient indexes, DPA finds the culprits that are affecting performance.
How can I get automatic alerts about critical database performance problems?
How can I get automatic alerts about critical database performance problems?
If a problem is detected, the event and resource monitor will alert you immediately. E-mail templates that can be individually adjusted using drag & drop facilitate notification.
How do I get the query optimization tips I need?
How do I get the query optimization tips I need?
DPA processes all the collected data to the second around the clock and offers expert competence in the form of optimization tips for tables. From query recommendations to index recommendations, DPA offers optimization tips coupled with predictions of expected performance improvement.
How do I know the effects of virtualization on my database?
How do I know the effects of virtualization on my database?
With DPA you get a monitoring at the VM level with an indication of the overall health of the virtual machine - for example the CPU utilization - while with an analysis at the host level you can find hard-to-see performance brakes like co-stop.
Follow