--- title: "sp_dbmmonitorhelpmonitoring (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/03/2017" ms.prod: sql ms.prod_service: "database-engine" ms.component: "system-stored-procedures" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords: - "sp_dbmmonitorhelpmonitoring" - "sp_dbmmonitorhelpmonitoring_TSQL" dev_langs: - "TSQL" helpviewer_keywords: - "sp_dbmmonitorhelpmonitoring" - "database mirroring [SQL Server], monitoring" ms.assetid: a085cf87-269f-454a-a146-21f80a113b72 caps.latest.revision: 23 author: "stevestein" ms.author: "sstein" manager: craigg --- # sp_dbmmonitorhelpmonitoring (Transact-SQL) [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)] Returns the current update period. ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md) ## Syntax ``` sp_dbmmonitorhelpmonitoring ``` ## Arguments None ## Return Code Values None ## Result Sets 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. ## Examples The following example returns the current update period. ``` EXEC sp_dbmmonitorhelpmonitoring; ``` ## See Also [Monitoring Database Mirroring (SQL Server)](../../database-engine/database-mirroring/monitoring-database-mirroring-sql-server.md) [sp_dbmmonitorresults (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-dbmmonitorresults-transact-sql.md)