sp_dbmmonitoraddmonitoring (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

sp_dbmmonitoraddmonitoring (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Creates a database mirroring monitor job that periodically updates the mirroring status for every mirrored database on the server instance.

Topic link icon Transact-SQL Syntax Conventions

  
sp_dbmmonitoraddmonitoring [ update_period ]  

update_period
Specifies the interval between updates in minutes. This value can be from 1 to 120 minutes. The default is 1 minute.

System_CAPS_ICON_note.jpg Note


If update period is set too low, the response time might increase for clients.

None

None

This procedure requires that SQL Server Agent is allowed to run on the server instance, and for the database mirroring monitor job to run, Agent must be running.

If database mirroring is started from SQL Server Management Studio, the sp_dbmmonitoraddmonitoring procedure is run automatically. If you start mirroring up manually using ALTER DATABASE statements, to monitor mirrored database on the server instance, you must run sp_dbmmonitoraddmonitoring manually.

System_CAPS_ICON_note.jpg Note


If you run sp_dbmmonitoraddmonitoring before you set up database mirroring, the monitoring job will run but will not update the status table in which database mirroring monitor history is stored.

Requires membership in the sysadmin fixed server role.

The following example starts monitoring with an update period of 3 minutes.

EXEC sp_dbmmonitoraddmonitoring 3;  

Monitoring Database Mirroring (SQL Server)
sp_dbmmonitorchangemonitoring (Transact-SQL)
sp_dbmmonitordropmonitoring (Transact-SQL)
sp_dbmmonitorhelpmonitoring (Transact-SQL)
sp_dbmmonitorresults (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft