Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL MIrroring Expand / Collapse
Author
Message
Posted Wednesday, December 12, 2012 3:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 1:08 AM
Points: 102, Visits: 416
I recently configured on database in mirroring with automatic failover.I want to push 10 GB of data into primay server and I want to find how much time it would take to synchronise these data to mirror server.

Please help


Post #1395538
Posted Wednesday, December 12, 2012 3:17 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
Akkare (12/12/2012)
I recently configured on database in mirroring with automatic failover.I want to push 10 GB of data into primay server and I want to find how much time it would take to synchronise these data to mirror server.

Please help


depends on below factors.

1) IO speed or disk RPM
2) network speed
3) what other processes running on same machine which are also using resources etc etc


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1395546
Posted Thursday, December 13, 2012 12:11 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
Also edition of mirrored server plays a significant role when it comes to synchrnoization.Enterprise editon will use "Parallel redo" using more threads available to mirroring session If you have more than 5 cpu.
Post #1396009
Posted Thursday, December 13, 2012 12:30 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:48 AM
Points: 2,834, Visits: 3,950
dbasql79 (12/13/2012)
Also edition of mirrored server plays a significant role when it comes to synchrnoization.Enterprise editon will use "Parallel redo" using more threads available to mirroring session If you have more than 5 cpu.
thanks ..New to me ...Any article ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1396014
Posted Thursday, December 13, 2012 1:06 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
Sure,
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx
Post #1396034
Posted Thursday, December 13, 2012 3:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 14, 2013 8:05 AM
Points: 101, Visits: 108
Thanks for the link..
Post #1396080
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse