Check SQL Servers Quickly and Easily Instant information at your fingertips
20 years experience as a DBA packed into an easy-to-use SQL Server tool.
I find SQL CoPilot invaluable and have come to rely on it daily. Indeed, I
wonder how I ever managed to survive without it! I shall certainly not
hesitate in recommending it to my colleagues. S.B. - Database Administrator, UK
Here's how SQL CoPilot can help you:
See the Big Picture Get an instant view of instance and database health, overdue backups, suspect pages, unsynchronized mirrors, breakdown of errors from the logs, number of deadlocks, failed jobs and more. Drilldown into each for more detail.
Databases A big collection of reports showing files, options, tables, indexes, statistics, fragmentation, index and plan analysis.
Performance Start with a performance overview and then look in detail at CPU, memory, I/O, wait stats, latch stats, and performance counters.
Current and Historical Activity See currently running requests, sessions, locks, transactions, blocking chains, waiting tasks and connections. Drill down for more detail, including the SQL being executed. See the most expensive queries in terms of duration, CPU and I/O.
"10 Second" Snapshots Activity is monitored over a 10 second period, showing virtual file stats, wait stats, performance counters, active queries and operational statistics of lock and latch waits. Very useful for investigating performance issues.
Agent Jobs See failed, cancelled and long running jobs. View a graphical timeline showing when all jobs started and stopped in a gantt-style chart.
Logs View the error log with all the noise removed. Display the default trace without the need for scripts. Extract deadlocks, errors and long waits from the system_health extended event session. Look at the ring buffers to see connection failures, resource monitor and more.
I have been using the product almost non-stop since I purchased it a week or so ago.
I am finding it tremendously helpful. D.J. - Database Administrator, PA
With a total of 72 immensely useful custom reports and full integration into Management Studio, there is no doubt that your own effectiveness
and visibility as a DBA will improve, and give you increased confidence in the health, stability and performance of your SQL Servers.