Export (0) Print
Expand All

Additional Sources of Information about a Mirrored Database

In addition to using the Database Mirroring Monitor and dbmmonitor stored procedures to monitor a mirrored database and set up alerts on monitored performance variables, Microsoft SQL Server 2008 provides the following:

  • Database mirroring metadata in catalog views. For more information, see "Database Mirroring Metadata," later in this section.

  • Performance counters for database mirroring. For more information, see "Database Mirroring Performance Counters," later in this section.

  • Database mirroring event notifications. For more information, see "Database Mirroring Events," later in this section.

  • Server events for the WMI Provider for Server Events.

Each database mirroring session is described in metadata that is exposed through the following catalog or dynamic management views:

Performance counters let you monitor database mirroring performance. For example, you can examine the Transaction Delay counter to see if database mirroring is impacting performance on the principal server, you can examine the Redo Queue and Log Send Queue counters to see how well the mirror database is keeping up with the principal database. You can examine the Log Bytes Sent/sec counter to monitor the amount of log sent per second.

In Performance Monitor on either partner, performance counters are available in the database mirroring performance object (SQLServer:Database Mirroring). For more information, see SQL Server, Database Mirroring Object.

To start the performance monitor

Event notifications are a special kind of database object. Event notifications execute in response to a variety of Transact-SQL data definition language (DDL) statements and SQL Trace events and send information about server and database events to a Service Broker service.

The following events are available for database mirroring:

For more information about event notifications, see Understanding Event Notifications and Monitoring Events.

Community Additions

ADD
Show:
© 2014 Microsoft