SQL Server 2008 Mirroring - Max No of DBs

• KingGorilla

  Old Hand

  Points: 377

  More actions

  March 7, 2011 at 4:22 am

  #236063

  Hi everyone

  I am in the process of setting up mirroring with a witness server as a HA environment for our production SQL Server 2008 Standard install. Is there a recommended max no of DBs which are set up to mirror? we have around 50 DBs on this box which are approx 1Gb in size. I am sure i've read somewhere the recommended best practice limit is to mirror up to 10 DBs?

  The alternative is I use log shipping if 50 is above the recommeded max mirror no.

  Thanks in advance for any advice.

  KG

• M&M

  SSC-Insane

  Points: 21700

  More actions

  March 7, 2011 at 4:29 am

  #1295244

  Below link should answer your question.

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

  M&M

• KingGorilla

  Old Hand

  Points: 377

  More actions

  March 7, 2011 at 4:37 am

  #1295249

  Thank you, ill take a look.

  KG

• Craig Purnell

  SSCrazy

  Points: 2720

  More actions

  March 8, 2011 at 6:09 am

  #1295804

  If you are on 64 bit, you should be ok mirroring 50 databases. The limit we found on 32 bit was around 40.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 8, 2011 at 6:34 am

  #1295815

  One of the factors to consider is the activity on the databases.

  If many are infrequently used, you should be okay. If they are all heavily used with many users, you may have some issues.