Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Azure SQL Managed Instance
In Replication Monitor, the main window and detail windows (those windows launched from the main window) can be refreshed automatically or manually. To refresh a window manually, press F5. By default, the main window is refreshed automatically every five seconds; the rate can be customized for each Publisher.
The data displayed in Replication Monitor is queried from a cache; for information about the relationship between the cache and refreshing Replication Monitor, see Caching, Refresh, and Replication Monitor Performance. For information about starting Replication Monitor, see Start the Replication Monitor.
Right-click a Publisher in the left pane of Replication Monitor, and then click Publisher Settings.
In the Publisher Settings dialog box, set the Auto refresh and Refresh rate options. The Auto refresh setting affects the main window in Replication Monitor. The Refresh rate setting also affects any detail windows that are set to refresh automatically (changes to the setting only affect the detail windows opened after the change).
Select OK.
Open a detail window in Replication Monitor. For example:
Expand a Publisher group in the left pane, expand a Publisher, and then click a publication.
Click the All Subscriptions tab.
Right-click a subscription, and then click View Details.
In the Subscription <SubscriptionName> detail window, click Action, and then click Auto Refresh. The refresh rate is determined by the Refresh rate setting in the Publisher Settings dialog box.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Monitor a Microsoft Fabric data warehouse - Training
A data warehouse is a vital component of an enterprise analytics solution. It's important to learn how to monitor a data warehouse so you can better understand the activity that occurs in it.
Documentation
Run replication maintenance jobs (SSMS) - SQL Server
Learn how to start and stop replication maintenance jobs in SQL Server management Studio (SSMS).
Overview of the Replication Monitor Interface - SQL Server
Overview of the Replication Monitor Interface
Allow Non-Administrators use Replication Monitor - SQL Server
Learn how to grant access to non-administrators to the Replication Monitor in SQL Server Management Studio (SSMS).
Monitor Replication Agents - SQL Server
SQL Server Replication Monitor provides a systemic view of replication activity and lets you find information on a specific agent.