SQL Server Monitoring

Use Today’s Analysis to Inform Tomorrow’s Strategy with SQL Diagnostic Manager Access the reporting capabilities you need to manage databases more efficiently.

SQL Server Diagnostics & Reporting

Your job is to keep things running smoothly, no matter what. And yet to do that, you can’t rely on reactive management of your data environment. Planning for better performance in the future, or even avoiding disaster, requires knowing what has happened in the past and why. Having the right diagnostic tool will save you countless hours hunting down root causes of issues and enable you to make more informed plans for upgrades or improvements.

SQL Server Management

Get access to reliable, real-time information on the status and health of your environment. With the help of our diagnostic tool, you can not only quickly pinpoint and resolve performance issues, but also form a more accurate picture of what’s happening in your environment. These diagnostics grant you the peek-around-the-corner you need to strategize for better-performing, more available databases.
  • Use historical data and multiple baselines to better understand why issues are occurring.
  • Incorporate tools like PowerShell to automate alert response actions.
  • Create smarter, data-informed proposals for upgrades and improvements.
  • Build continuity into every process
  • Customize the diagnostics and reporting features of SQL Diagnostic Manager.

View locks, blocks, and deadlocks

For easy problem identification and resolution, view the complete blocking chain by identifying real-time and historical session locks, blocks, bottlenecks, and deadlocks. Run PowerShell scripts Get even more control over SQL Diagnostic Manager by deploying Microsoft PowerShell, and automate responses to alerts with PowerShell scripts.

View activity timelines

Understand events faster and more intuitively by viewing color-coded performance events on your server in a timeline calendar instead of a list of events. Use a sliding scale to zoom in to specific times.

View fragmentation

Quickly remedy one of the most common causes of performance degradation: View statistics on fragmentation to identify indexes that may need defragmentation.

Browse historical data

Reduce future problems by understanding the multiple factors behind SQL Server database issues. Examine historical trends and drill into the precise time a problem emerged.

Set up multiple baselines

Compare the performance baselines that matter to your business by defining and scheduling multiple baseline periods.

Integrate with SCOM

Share data efficiently with IT operations by propagating the status, health, and events of monitored instances to Microsoft’s System Center Operations Manager (SCOM).

Plan capacity

Confidently plan the future of your storage infrastructure. View charts and create reports with trends and metrics to help forecast future capacity needs.