Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Server Statistics tool helps you helps you determine the health of your instances by collecting real-time SQL Server statistics, such as the number of jobs assigned to the SQL Server Agent, and performance counters.

How the Server Statistics tool works

The Server Statistics tool searches the selected SQL Servers of server group, and displays a comprehensive list of real-time statistics for many components including your:

  • Backup devices
  • Databases
  • Error Logs
  • Locks
  • Logins
  • Performance counters
  • Processes
  • SQL Server Agent errors

By default, Server Statistics connects to the specified SQL Server instances using the credentials of your currently logged on Windows account, and then collects performance and diagnostic statistics about each instance.

Use the Server Statistics tool

To use Server Statistics:

  1. Open the IDERA SQL Admin Toolset Launchpad, and then click Server Statistics.
  2. Specify the SQL Server instance or server group whose statistics you want to check. To specify multiple SQL Servers, separate each instance name with a semicolon.
  3. Click View Statistics.
  4. View the results. To see details, expand a node in the statistics tree, and select a data point.
  5. If you want to save the results, copy the list to clipboard, or save the results as an XML or CSV file.


Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse