Check SQL Servers Quickly and Easily Instant information at your fingertips
20 years experience as a DBA packed into the most useful and easy-to-use SQL Server tool available.
Join over 5000 DBAs and developers today.
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
SQL CoPilot is for database administrators, developers and all support roles:
One tool for all of your instances All of your instances are accessible from one screen and can be tagged, and filtered by name, version and edition.
See the Big Picture Get an instant view of instance and database health, and drilldown for more detail.
Databases A big collection of screens showing files, options, tables, indexes, statistics, fragmentation, index and plan analysis.
Performance See a performance overview showing CPU, memory, I/O, current waits and tempdb usage. Drilldown into each for more detail.
Current and Historical Activity See currently running requests, sessions, locks, transactions, blocking chains, waiting tasks and connections. Click on a session for more detail, including the SQL being executed. See the most expensive queries in terms of duration, CPU and I/O.
SQL OS Dive into the SQL OS, viewing essential data about waits, latches, schedulers, performance counters and tempdb.
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 all this information available in one place 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.