SQL Server Monitor Overview
New: 14 April 2006
SQL Server Monitor does not perform monitoring functions, but it hosts modules that do. The SQL Server Monitor modules include Replication Monitor and Database Mirroring Monitor.
To use one of these modules, select that module on the Go menu. The currently selected module owns the content of the navigation and detail panes, user interaction in the detail panes, and the queries for content and status.
- Replication Monitor
To monitor replication, you must be a member of the sysadmin fixed server role at the Distributor or a member of the replmonitor fixed database role in the distribution database. A system administrator can add any user to the replmonitor role, which allows that user to view replication activity in Replication Monitor; however, the user cannot administer replication.
- Database Mirroring Monitor
To monitor database mirroring, you must be a member of either the sysadmin fixed server role or the dbm_monitor fixed database role on the server instance. If you are a member of sysadmin or dbm_monitor on only one of the partner server instances, the monitor can connect only to that partner; the monitor cannot retrieve information from the other partner. For more information, see Database Mirroring Monitor Overview.
SQL Server Monitor has a menu that contains commands that pertain to SQL Server Monitor. This menu may also contain commands from the selected module.
The following menu options pertain to SQL Server Monitor.
This menu contains the Exit command.
Contains the context menu of the node selected in the navigation tree.
Contains a list of monitoring components:
- Database Mirroring
To use SQL Server Management Studio to monitor database mirroring