Tool
|
Functionality - Database Administration
|
BACKUP
|
The BACKUP tool returns information about previous BACKUP operations.
|
RESTORE
|
The RESTORE tool generates a series of RESTORE statements from the BACKUP history.
|
MetricsNow
|
The MetricsNow tool gathers diagnostics on the fly and returns several result sets.
|
MetricsHistory
|
The MetricsHistory tool is a complete monitoring/alerting system for historic diagnostics.
|
Auditor
|
The Auditor tool returns information about server audits and database audits.
|
SQLAgent
|
The SQLAgent tool returns information about SQL Server Agent jobs/schedules.
|
Bufferin
|
The Bufferin tool returns information about what's in the SQL Server buffer cache.
|
Databases
|
The Databases tool returns information about user databases and tempdb.
|
Sessions
|
The Sessions tool returns information about what SQL Server is currently doing.
|
Snooper
|
The Snooper tool returns information about configuration and usage of memory and tempdb.
|
WaitingRoom
|
The WaitingRoom tool returns information about waits experienced by current sessions.
|
Resources
|
The Resources tool does on-the-fly monitoring to watch for excessive use of memory or tempdb.
|
Blocking
|
The Blocking tool does on-the-fly monitoring to watch for excessive blocking of other sessions.
|
Locksmith
|
The Locksmith tool returns information about locks, granted and/or waiting, in the instance.
|
Deadlocks
|
The Deadlocks tool returns information about recent SQL Server deadlocks.
|
Planner
|
The Planner tool returns aggregations for what’s in the SQL Server execution plan cache.
|
AGLatency
|
The AGLatency tool returns information about databases in Always On Availability Groups.
|