Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-12 : 09:41:31
|
| Matt writes "I am looking for a sql script that will let me know if replication is running and working fine. I have tried:exec sp_MSenum_snapshotselect * from MSsnapshot_history select * from distribution.dbo.msdistribution_status None seem to give me a real-time status if any of the agents fail or transactions are not syncing to the subscriber. Thanks!Matt" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-12 : 11:34:01
|
| I create a heartbeat table and set a job running updating the date every minute.A job then monitors replication by checking that value on the replicated database against the current time.It also shows if updates are stuck due to a large transaction being replicated.Give the users a view on the state from the intranet and they can see if things are behind and how they are catching up and so don't bother you so much.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Transactional Replication Monitoring