SQL Server performance issues rarely have a single, obvious cause. A sudden increase in query duration may be linked to blocking, resource contention, an execution-plan change or an underlying I/O issue. Identifying the cause requires DBAs to correlate information from multiple sources before deciding what action to take.
As SQL Server estates expand across on-prem, cloud and hybrid environments, this investigation can become increasingly time-consuming. The challenge is not a lack of performance data; it is bringing the relevant data together and using it effectively.
DBPerf is designed to address this challenge by combining SQL Server monitoring, diagnostics, performance analysis, alerting and AI-assisted investigation in a unified platform.
Shifting from monitoring data to diagnosis
Traditional monitoring provides important information about the state of a database, but identifying the root cause of a problem often requires several additional steps.
DBPerf brings the relevant evidence into a single workspace. DBAs can review active requests, wait statistics, blocking chains, CPU and memory utilization, I/O metrics and TempDB activity alongside query and execution-plan information.
This allows related indicators to be examined together. For example, wait types can be correlated with query regressions, blocking, file latency and execution plans to determine where performance is being affected.
The built-in plan viewer can further highlight potential tuning opportunities, including missing indexes, scans, lookups and cardinality estimation anomalies.
Based on this evidence, DBAs can prioritize appropriate remediation, whether that involves query tuning, index optimization, blocking resolution, configuration changes or capacity adjustments.
The approach reduces the need to switch between multiple tools during an investigation and provides a clearer path from identifying a performance issue to determining what to do about it.
A structured approach to reactive troubleshooting
When a performance issue occurs, DBPerf supports a six-step investigation workflow:
- Signal identified
A dashboard indicator, alert or user-reported issue points to a potential performance problem. - Telemetry reviewed
The DBA reviews relevant server information, including active requests, wait statistics, blocking activity, CPU and memory consumption, I/O metrics and TempDB activity. - Root-cause indicators correlated
Wait types, query regressions, blocking chains, file latency and execution plans are examined together within the workspace. - Query and plan analysis performed
Execution plans are reviewed to identify potential tuning opportunities such as missing indexes, scans, lookups and cardinality estimation anomalies. - Action prioritized
The DBA determines the most appropriate remediation based on the available evidence. - Outcome retained
The collected telemetry remains available for post-incident analysis, trend comparison and future investigations.
This creates a repeatable process for moving from an initial symptom to evidence-based remediation.
Proactive risk mitigation
Resolving an incident is only one part of database performance management. The ability to identify deterioration before it affects users can have an even greater operational impact.
DBPerf supports this through scheduled telemetry collection and local performance history. Data collected at configurable intervals can be used to establish a baseline for factors such as wait patterns, resource utilization, query duration, I/O latency, memory pressure and blocking frequency.
Once this baseline is established, deviations from normal behavior can be identified. These may include rising query durations, increasing file latency or persistent blocking.
DBAs can then investigate the change and determine whether preventive action is required before it develops into a business-impacting incident.
Proactive performance intelligence workflow
- Scheduled collection
Collectors run at configurable intervals based on data volatility and operational requirements. - Baseline created
Performance patterns across waits, resources, queries, I/O and blocking establish an operational baseline. - Trend deviation detected
Dashboards and alerts highlight changes from normal behavior. - AI-assisted analysis
Through MCP, an AI client can summarise significant changes over a selected period using locally collected telemetry as the basis for analysis. - Preventive action planned
DBAs can use the evidence to plan tuning, indexing, configuration changes, scaling or application-level remediation before a major impact occurs.
This extends the role of performance monitoring from incident detection to ongoing performance management.
Using AI with the underlying evidence
AI-assisted database operations depend on the quality and context of the data being analyzed. Generic recommendations are of limited value when they are disconnected from the actual behavior of a database environment.
DBPerf uses locally collected telemetry to support AI-assisted analysis through MCP. An AI client can analyze changes within a selected time window and summarise relevant performance patterns, grounding the analysis in the available database evidence.
This can help DBAs interpret large volumes of performance information more efficiently while retaining human oversight over diagnosis and remediation.
The telemetry can also be retained for post-incident analysis, trend comparison and knowledge retention, allowing performance history to remain useful beyond the immediate troubleshooting exercise.
Supporting on-prem, cloud and hybrid environments
Modern SQL Server workloads can span multiple deployment models. Managing performance consistently across these environments requires an approach that can scale without introducing additional operational or governance complexity.
DBPerf is designed to support on-premises, cloud and hybrid environments while providing a consistent experience for database teams.
It is also intended to complement existing tools and practices rather than require organizations to replace their current monitoring investments. This allows teams to consolidate performance information and introduce additional intelligence without creating another complex monitoring layer.
Business benefits
The technical capabilities of DBPerf translate into several operational outcomes:
- Faster issue resolution: A unified view of performance evidence reduces the time spent collecting and correlating information during troubleshooting.
- Improved application performance and availability: Earlier identification of performance degradation can help teams address risks before they affect application responsiveness and end users.
- Lower operational effort: Reducing dependence on fragmented monitoring and manual troubleshooting can simplify database operations and improve resource utilization.
- Higher DBA productivity: With investigation and analysis streamlined, DBAs can spend more time on optimization, modernization and other business-critical initiatives.
- Stronger governance: A lightweight approach to monitoring helps organizations maintain control over operational data while supporting enterprise security, governance and compliance requirements.
- Enterprise-wide visibility: Consolidated monitoring across SQL Server estates gives technology teams a clearer view of performance, helping them prioritize issues and make better-informed operational decisions.
- Foundation for AI-assisted operations: Structured performance telemetry provides a foundation for extending AI-assisted capabilities across database management and automation.
Making performance management more effective
SQL Server monitoring generates the data needed to understand database behavior. The greater challenge is turning that data into decisions.
DBPerf brings monitoring, diagnostics, performance analysis and AI-assisted investigation together to help database teams do that more effectively. It supports both sides of performance management: investigating problems when they occur and identifying performance changes before they become incidents.
For organizations managing SQL Server across on-prem, cloud and hybrid environments, this provides a practical way to reduce troubleshooting effort, improve DBA productivity and build a stronger foundation for intelligent database operations.
DBPerf helps organizations turn SQL Server performance data into evidence-based action, improving reliability today while preparing database operations for AI-assisted management.
