Investigate

Everything You Need For Issue and Performance Investigation

Dashboards, charts and data for a detailed view of what's happening right now, and what has happened in the recent past!

Dashboards

Multiple dashboards from high level instance summaries and real-time activity through to performance, jobs and security. More dashboards added regularly.

Activity

Current and historical activity. What is running right now. Visual display of blocking chains. Most expensive SQL in terms of CPU and I/O. Copy the SQL to the clipboard for further analysis in SSMS.

Databases

Which databases have overdue backups or CHECKDB. In depth analysis of all database indexes, including missing, duplicates, redundant, unused, hypothetical and most fragmented. Script commands to create or drop indexes and copy to the clipboard.

Performance Metrics

Everything you need to know about CPU, memory and I/O performance. See recent CPU history. Are compilations causing unnecessary overhead? What is using the memory? Which databases are responsible for the most I/O and suffering from the worst latency.

SQL OS

The SQL Server Operating System exposes a wide range of metrics, including wait types, latches, scheduler information and performance counters. SQL CoPilot presents this information at a click of the mouse.

Logs and Ring Buffers

Events are recorded in the error log, agent log, default trace and numerous ring buffers for things like connectivity issues, resource contention and more. SQL CoPilot extracts this data and presents it in an easy to read format.

System Health

An extended event session called system_health runs by default, and SQL CoPilot provides a quick and easy way to access the captured events. Long waits, exceptions, and deadlocks are just some of what is available.

SQL Server Agent

In addition to the job dashboard there are views of the agent log, all jobs with job history, and a graphical timeline of all jobs together in a gantt-style view.

Security

This is a new addition to SQL CoPilot and currently consists of logins, database options, keys, certificates, and a breakdown of public server role permissions. More is due to be added soon and will be sent to customers when completed.

Start your FREE trial today