How do I obtain information using Activity Monitor?

Products

• 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

Issue/Introduction

Description

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:

 

Environment

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

Resolution

Solution

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