Database Insights for SQL Server Monitor and proactively manage the performance of Microsoft SQL databases.

Features Overview

SolarWinds Database Insights for SQL Server is a package of both Database Performance Analyzer (DPA) and SQL Sentry.

• A solution to scale to the largest enterprise
• SQL Server monitoring that can scale to the largest enterprise environments for SQL servers that can reside on-premises, in hybrid environments, or in the cloud.
• Detailed performance dashboards
• View actionable performance information about your monitored SQL Server environment. High-level dashboards allow click through to dive deep individual database performance.
• Customize to your needs
• No two database environments are alike. With the flexibility to create unique dashboards, alerts, thresholds, and reports, you can rest assure DIS can be tailored to your unique environment and needs.
• Flexible deployment and monitoring
• Databases can reside in several places, and so should your monitoring solution. With the ability to be deployed on-prem or via cloud marketplaces, you can be assured deployment and monitoring locations won’t be an issue.

SQL Server performance monitoring

Powerful and scalable SQL Server performance monitoring

Gain powerful insights into your Microsoft SQL Server performance. From a bird’s-eye view of your entire SQL Server environment down to query execution and explain plans. With complete observability, you can monitor, diagnose, and optimize your entire database environment.

Blocking and deadlock analysis

See what’s causing blocking and deadlocking

Blocking and deadlocking occur in every SQL Server database. Having insights into the hierarchy of blocking and the overall impact will help to provide the information necessary to effectively tune performance.

Index and query tuning advisors

Identify performance opportunities with index and query recommendations

Quickly identify high-impacting and inefficient SQL queries to find the largest opportunities for database performance improvements. Table tuning advisors provide more information on inefficient steps and potential query impact.

Anomaly detection for wait-time analysis

Know when database performance is not normal

Every environment is unique, and anomaly detection power by machine learning understands your environment’s wait-time analysis. Be alerted to when performance deviates from normal patterns and trends.

VMware, Hyper-V, and environment monitoring

Understand and monitor server environment performance data

SQL Server can only perform as well as the software and infrastructure supporting it. With DIS, you can monitor your operating system and databases hypervisor infrastructure to ensure they’re running correctly and aren’t the source of any performance issues.

Visualize Windows and SQL events

Know when to anticipate additional workload impacts

Visibility into when SQL Server and Microsoft Windows tasks are scheduled to run allows you to see the larger picture of performance impacts, helping to resolve potential conflicts faster.