sp_dbmmonitorhelpmonitoring (Transact-SQL)

Applies to: SQL Server

Returns the current update period.

Transact-SQL syntax conventions

Syntax

syntaxsql

sp_dbmmonitorhelpmonitoring
[ ; ]

Arguments

None.

Return code values

None.

Result set

Returns the current update period, that is, the number of minutes between updates of database mirroring status table. This value ranges from 1 to 120 minutes.

Permissions

Requires membership in the sysadmin fixed server role, or execute permission directly on this stored procedure.

Examples

The following example returns the current update period.

SQL

EXEC sp_dbmmonitorhelpmonitoring;

Related content

• Monitoring Database Mirroring (SQL Server)
• sp_dbmmonitorresults (Transact-SQL)