How do I obtain information using Activity Monitor?
search cancel

How do I obtain information using Activity Monitor?


Article ID: 53930


Updated On:


Activator eTrust ALERT eTrust ALERT for CICS ALERT Archiver ASM/ARCHIVE VSE-ESA OPTION ASM/Archive AutoAction AutoSys Job Management Adapter for AutoXfer Process Automation Manager Portal ARCserve Backup Client CICSORT Clipper COBOLVISION Analyzer CTO Distributed Dart Datesolver/2000 Distribulink EUREKA:Object EPIC VM Enterprise Endevor for Unix Archiver Disk Option EPIC Backup EPIC Access Option EPIC SUPER SYS EPIC for CMS System EPIC TAPE MANAGEMENT eTrust Antivirus Gateway for CVP eTrust Content Inspection Gateway eTrust Content Inspection Gateway Option for MSP/ISA EE eTrust Antivirus Gateway for Netscape eTrust VPN Enterprise Edition FAQS VM FAQS Automated Systems Operation Global Subsystem (GSS) ANDYNE MAINFRAME MISCELLANEOUS Inventory Discovery Server ARS Resource Management JARS Resource Management ACC Option JOBDOC JOBWATCH Look MAZDAMON Service Management Affiliate Technology Partner Fee Service Management Basic Technology Partner Fee Metanet MF - MISC OLD CODES Omniguard for CICS Omniguard Opera Connect PREVAIL Paramount XP CAM FOR DIST SYS Paramount FOR NAVIGRAPH/HOST Research Planmacs Unlimited Project Planner Remote Console PREVAIL/XP-AUTOMATION PHASE 1 Remote Console PREVAIL/XP AUTOMATION-RDF/SSM Raps Research Raveler Generic Non Product SOLVE:EPS Unicenter NetMaster Network Management for SNA Alexandria Sort System SPOOLMAN Storage Mainframe SYSTEM/SCHEDULER SYSTEM/SCHEDULER VSE-ESA OPTION System/Manager Tape/Manager VSE-ESA OPTION Output Management Document Server TNG Network and Systems Management Agent for CA-Datacom DFSMShsm Workstation Network and Systems Management UNIX SMTP Unicenter Management for Microsoft Exchange SMTP Option UNICENTER II Unicenter Network and Systems Management Database Performance Monitor Option UNICENTER OSM Database Command Center Mnt VM:DBA VM:DB Admin VM:DB Center VM:DB Developer VM:DB Editor VM:DB Monitor VM:DB Reorganizer VM:DB Reporter VM:DB Restore VM:DB REXX VM:DB SQLMAP VM:DB Suite VM:Migrate VM:Monitor VM:Notekeeper V/Solver VM:Webserver for Officevision VM:Webserver Secure VM:Webgateway VM:Webserver XMENU for z/VM VISION:COMBO for TSO VISION:DAGER VISION:ELEVEN VISION:EIGHTY VISION:Online VISION:IQ for Informix Automate STORAGE RESOURCE MANAGEMENT SUITE



Use Activity Monitor to obtain information about SQL Server processes and how these processes affect the current instance of SQL Server.
Activity Monitor is a tabbed document window that has the following expandable and collapsible panes:



Release: BRMAPS20100-11.7-Storage Resource Manager-Application Server



  • Overview
    Shows graphical displays of the percent of processor time, number of waiting tasks, database I/O (megabytes per second), and batch requests (number per second).

  • Active User Tasks
    Shows information for active user connections to SQL Server Database Engine.
  • Resource Waits
    Shows wait state information.
  • Data File I/O
    Shows I/O information for database data and log files.
  • Recent Expensive Queries
    Shows information about the most expensive queries.

When you expand a pane, the Activity Monitor queries the instance for information. When you collapse a pane, the Activity Monitor stops all the activities related to querying for that pane. You can also expand one or more panes at the same time to view different kinds of activities on the instance.
You can customize the display of the columns that are included in Active User Tasks, Resource Waits, Data File I/O, and Recent Expensive Queries panes in the following ways:

  • Click the column heading and drag it to another location in the heading ribbon to rearrange the order of the columns.
  • Click the column name to sort on columns.
  • Click the drop-down arrow in the column heading, and then select a value to filter on one or more columns.

    You must have VIEW SERVER STATE permissions to view the Activity Monitor in SQL Server 2005 and SQL Server 2008.