Monitoring SQL Server

Drilldown on SQL Server storage.

Drilldown on SQL Server sessions.

Drilldown on SQL Server jobs.

Drilldown on deadlocks. A deadlock occurs when multiple processes are competing for exclusive access to a resource. This results in a standoff where no process can proceed. To alleviate the deadlock, one of the sessions is selected as a deadlock victim and its current transaction is rolled back. When this occurs, all of the locks held by the victim’s session are released, allowing other previously blocked sessions to continue processing.

Drilldown on usage of the TempDB system database. TempDB is a temporary workspace for storing temporary tables that hold intermediate results during sorting or query processing. Tempdb is re-created newly from stored configuration each time the SQL Server service starts.

Drilldown on the availability of a SQL Server instance, its databases and SQL Server services.

Drilldown on key system health issues. Pinpoint and address these issues within your SQL Server infrastructure.

Drilldown on the workload of this SQL Server instance. What work is the database system producing in a given time? What resources are consumed in producing this work?

Drilldown on I/O statistics for each SQL Server database file.