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 1234»»»

Database Mirroring Expand / Collapse
Author
Message
Posted Tuesday, July 31, 2012 2:53 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:44 AM
Points: 91, Visits: 322
Hi Gurus,

Due to some network glitch mirroring connection is disable. Is it possible establish the connection automatically once network connected or should i manually establish a mirroring connection.

I have one more question:

We are planning to mirroring totally 1000 databases to our DR site. I want know approximately how much bandwidth and disk size (Each database is 8 GB) is required.

We are using SQL 2005 standard edition with SP2 and 32 bit OS.

Please advice on this....

Advance thanks.




Pradeep
Post #1337737
Posted Tuesday, July 31, 2012 3:23 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 42,462, Visits: 35,522
pradeep.mohan (7/31/2012)
We are planning to mirroring totally 1000 databases to our DR site. I want know approximately how much bandwidth and disk size (Each database is 8 GB) is required.


No way to answer that, you'll have to test it out per database first.

I do hope those 1000 aren't on the same instance...



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1337749
Posted Tuesday, July 31, 2012 5:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:44 AM
Points: 91, Visits: 322
We have 2 servers per server 3 instance

Pradeep
Post #1337811
Posted Tuesday, July 31, 2012 6:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 42,462, Visits: 35,522
So you have around 200 databases per instance that you plan to mirror. Err, good luck with that...

http://support.microsoft.com/kb/2001270
http://sqlcat.com/sqlcat/b/technicalnotes/archive/2010/02/10/mirroring-a-large-number-of-databases-in-a-single-sql-server-instance.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1337826
Posted Tuesday, July 31, 2012 6:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:44 AM
Points: 91, Visits: 322
Thanks Gil,

Any idea about my first point which i was post early....


Pradeep
Post #1337836
Posted Tuesday, July 31, 2012 6:18 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 42,462, Visits: 35,522
It should reconnect once the network connection becomes available again.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1337838
Posted Tuesday, July 31, 2012 6:26 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:44 AM
Points: 91, Visits: 322
How many databases can i run on a single instance?

I read about max on 32 bit, use not more then 10 database, but is there a max on 64 bit servers?

I thought i heard about 32 databases and then you have to make another instance. Is that the case?


Pradeep
Post #1337846
Posted Tuesday, July 31, 2012 6:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 12:44 AM
Points: 91, Visits: 322
Is it possible to having any data loss during the network failure?
Is it synchronizing all the data's after reconnecting the mirror (network connection becomes available again.
)
Is it required any manual action like full & log backup restoration before establish a connection?

Thanks.


Pradeep
Post #1337853
Posted Tuesday, July 31, 2012 7:38 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:16 AM
Points: 1,612, Visits: 1,537
How many databases you can mirror on a single server relies on many factors such as workload, the number of CPUs, the capabilities of the server. You need to test it with a production workload to see how many databases are feasible with your environment.

You will not lose data during a network outage unless you lose the principal database. All of the transactions not yet mirrored will be preserved in the log file until mirroring reconnects and the transactions are transferred to the mirror.

I highly recommend you get a copy of my book. You can download the ebook version directly from the publisher.




My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1337898
Posted Tuesday, July 31, 2012 11:00 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 42,462, Visits: 35,522
pradeep.mohan (7/31/2012)
How many databases can i run on a single instance?

I read about max on 32 bit, use not more then 10 database, but is there a max on 64 bit servers?

I thought i heard about 32 databases and then you have to make another instance. Is that the case?


Did you read the articles I linked to?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1338052
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse