Database Reference
In-Depth Information
16. Further to the replication monitor, the TSQL method also provides the DMVs with the
ability to obtain information on the replication process latency. The useful DMVs to
manage the replication process information are as follows:
sys.dm_repl_articles
sys.dm_repl_schemas
sys.dm_repl_traninfo
sys.dm_repl_tranhash
17. Finally, the agents tab delivers the status of each replication agent and job that are
used by all types of replication, with an additional feature allowance to start and stop
each agent and job.
This completes the set of required steps to manage the SQL Server replication process using
the scripting feature in SSMS.
How it works…
SQL Server Replication Monitor is designed to monitor the replication processes and the
queries that Replication Monitor uses to perform calculations and gather data that is cached
and refreshed on a periodic basis. The tool can be invoked from the command line from the
folder
\Program
Files\Microsoft
SQL
Server\100\Tools\Binn\sqlmonitor.exe
.
The main Replication Monitor window (including all tabs), automatically refreshes by default
every five seconds. Automatic refreshes do not force a refresh of the cache. The user interface
displays the most recent version of the data from the cache. You can customize the refresh
rate used for all windows associated with a Publisher by editing the Publisher settings. You
can also disable automatic refreshes for a Publisher.
Cache refresh is handled by an SQL Server Agent job and the Replication monitoring refresher
for distribution. The job runs continuously, but the cache refresh schedule is based on
waiting for a certain amount of time after the previous refresh. The Replication Monitor detail
windows are not automatically refreshed by default, with the exception of windows related to
the subscriptions that are synchronizing. By default, all the windows in Replication Monitor
can be refreshed by using the
F5
function key, or by right-clicking a node in the Replication
Monitor tree and clicking Refresh. Manual refreshes force a refresh of the cache.
Search WWH ::
Custom Search