Improve SQL Server Performance with DBI Performance Suite

• SQL Server Performance Analytics and Trending Solution
• SQL Server Tuning, Database tuning, SQL tuning, and Index tuning,
• Provides a major breakthrough in SQL Server performance analysis
• Finds, recommends, and fixes issues for SQL Server health and performance
• Detects SQL Server changes, when it changed, and how they impacted performance
• Historical SQL Server Counters data combined with real-time performance data

Customizable SQL Server Dashboards

• Overview of all monitored databases performance metrics
• View best, worst, and average SQL Server database scores
• Comparative SQL Server Tools, charts, and metrics
• Individual database dashboards with dynamic date ranges
• Trend charts for SQL Server performance metrics

SQL Server Performance Statistics

• Statistics for hundreds of counters with threshold warnings
• Summary views for SQL Server routines, triggers, and Statements
• Support for all types of databases, clustered, simple, etc.
• Powerful search, filtering, sorting, moving and fixing columns
• Grouping of similar metrics for easier comparisons and viewing

SQL Server Responsiveness and SQL Server Availability

• SQL Server Response Time Analysis and SLA Attainment Analysis
• Monitoring of all SQL transaction times broken by SLA levels
• SQL Server transactions average execution times and wait times
• Determine resource bottlenecks for CPU, I/O, Locks, Sorts, etc.
• Sql Server availability for different cumulative time periods

SQL Server Performance Trend Charts

• Chart metrics for a time period to spot any anomalies and trends
• Compare SQL Server Performance counters side by side
• View database and user changes on the same chart timeline
• Pan and zoom to get high level and detailed views of trends
• Navigate to the SQL Server activity to pin point specific issues

SQL Server Performance Advice

• Perform a complete health check for SQL Server improvements
• Perform SQL Server Analysis and provide actionable recommendations
• Provide automated index recommendations for problematic SQL
• Scan the database and report on invalid objects that need attention
• Report on tables and indexes that need reorg or have stale statistics

SQL Server Workbench

• SQL tuner with the ability to format and edit the monitored statements
• Display a searchable explain plan in both tree and graphical formats
• Provide index recommendations with percentage of performance gains
• Ability to create new SQL Server virtual indexes and test them
• Check virtual indexes against all workload statements to detect degradation

Real Time SQL Server Monitoring

• Live SQL Server dashboard to view real time key metrics that affect performance
• Charts with drill-downs to show details of the state of the database
• Summarize the data by Connections, Applications, Statements, etc.
• View database contentions and locks with the ability to release them
• Finds problems, performance issues, or inefficiencies in the database

SQL Server Alerting

• SQL Server Advanced Lights-Out, flexible, and customizable alerting Solution
• Monitors databases 24x7 and sends notifications for performance issues
• Provides alerts in a variety of ways (email, traps, SNMP, etc.)
• Over 200 rules out of the box with the ability to create custom ones
• Ability to suppresses duplicate alerts to minimize the noise