| Author |
Topic |
|
cipo2k4
Starting Member
4 Posts |
 Posted - 2007-08-06 : 13:51:35
|
| I need to know how can i see the replication status. I have 4 servers with ms sql 200 standard server and hundreds of commnad to replicate. Sometime is important to know how mush of this commnads is replicated. Thank You. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-06 : 13:54:00
|
| Open up Replication Monitor to view the replication status.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-06 : 14:15:12
|
| Enterprise MGr -> Replication --> Replication Monitor -> PublisherDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
cipo2k4
Starting Member
4 Posts |
Posted - 2007-08-06 : 14:22:54
|
| Yes...In replication monitor - Publisher i see delivering replicated transaction, but no ex: transmited 10 commnads from 200 commands total...or something like this. i need to know how many commnads is replicated from oune server to other.thank you |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-06 : 14:29:08
|
| Your question is not clear. What doesn't Replication Monitor show?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-06 : 14:40:46
|
| If you refresh the page do you see the number of replicated commands changing..?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
cipo2k4
Starting Member
4 Posts |
Posted - 2007-08-06 : 14:47:34
|
| no...i can't see until is finish. after last commnd is delivered i can see total commands, latency, etc... i need to know in the midlle of Delivering how many commnads is tranmited and what is total number of commands for delivery. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-06 : 14:50:40
|
| What do you mean by >>> need to know in the midlle of Delivering The commands are delivered in batches. As long as you dont see any errors there, dont mess with Replication.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
cipo2k4
Starting Member
4 Posts |
Posted - 2007-08-06 : 15:09:37
|
| is importnat for me... because i have many location for replication and i wan to stop 1 or more replication for accelerate others. for bandwith management... do you undertand me??? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-06 : 16:30:02
|
| You may need look for third party tools if there is any. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-03 : 17:09:25
|
| dig up some of the sys tables for replication, it's there somewhere... I remember looking for the same thing before...sorry couldn't help more, been a while since I touched replication--------------------keeping it simple... |
|
|
|
|
replication status