Printed 2016/05/04 12:43AM

How many mirrored databases can I have on a server?

By Robert Davis, 2008/11/18

 How many mirrrored databases can I have on a server?

10 mirrored databases per server is the recommendation for a 32 bit computer WITH 4 processors or less. 64 bit computers have twice as many threads which means, in theory, that you can have twice as many mirrored databases. Also more processors = more threads = more mirrored databases. I interpolated the recommendations out from the base recommendation to other system profiles as follows: 


32-bit 64-bit
Number of CPUs Default # of Threads Mirrored Databases Default # of Threads Mirrored Databases
<= 4 processors 256 10 512 20
8 processors 288 11 576 22
16 processors 352 13 704 27
32 processors 480 18 960 37

Others are correct to point out that this is a recommendation, not a hard limit. What your server can actually handle depends on the architecture as well as the amount of other traffic being handled by the server.

Please note that this is merely an interpolation of the "official" recommendation originally recommended for database mirroring limits in SQL Server 2005 Books Online. This is not a statement of how many databases you should expect to be able to mirror on any given server. The actual number of databases you can mirror should be much higher than this and relies on many different factors.

For a more complete understanding of how to calculate the number of databases you can mirror on a given server, I recommend reading and investigating the information documented by the SQL Cat team: Mirroring a Large Number of Databases in a Single SQL Server Instance. As always, be sure to test your planned set up with a realistic workload.

Copyright © 2002-2016 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.