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 |
|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2010-04-01 : 07:29:43
|
| Guysis this possible to know that how much data is being transfered between SQL Server 2005 mirroring ?Like 5kb or 1 MB every time both Principar & Mirror trying to Sync?ThanksSKR |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-04-01 : 08:29:07
|
| Have you looked at the database mirroring monitor?Right click the database that is mirrored and select tasks -> Launch database mirroring monitorOnce you register a database you can see allthe traffic being sent. |
 |
|
|
rikleo2001
Posting Yak Master
185 Posts |
Posted - 2010-04-01 : 08:57:13
|
| Yes, I did had a look.It says Send Rate...15kB/SEC, I beleive this tells me how much data is being set to mirror /sec, so there might be 100 15kb/sec transfers, correct ?What I want how to get that 100 figure? means total KB/MB data transfer to mirror?SKR |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Data transfered in DB mirrroing