April 15, 2009 at 7:11 am
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
June 26, 2009 at 9:52 pm
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply