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 73 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.

Download it today