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!
Multiple dashboards from high level instance summaries and real-time activity through to performance, jobs and security. More dashboards added regularly.
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.
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.
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.
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.
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.
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.