SQL 2005 or 2008 Database mirroring limitation?

  • Just doing some reading and found that there exists an 10 database limit for DB mirroring on SQL 2005/2008 32 bit version.

    We have a 2005 32bit SQL server that is currently mirroring close to 30 databases with no problems. When I try to add one more i get Out of Memory errors which prompted me to do some research and find this limitation.

    Do the 64 bit versions have any limit? This might be a good question for the QOD. 🙂

    Thank you

    Steve

  • Did some reading myself on this subject and found basically the same thing you did. The following is from BOL:

    Restrictions

    On a 32-bit system, database mirroring can support a maximum of about 10 databases per server instance because of the numbers of worker threads that are consumed by each database mirroring session.

    Based on this information, I'd say that there is no hard limit, but would be based on the amount of memory available on the 64-bit system.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply