Clustering with many databases | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Clustering with many databases

I must create a multinode Active/Acive cluster to server a very large number of databases (up to 50.000!). To do that I’ll use datacenter with IA-64 processors (16 per cluster). The question I have is the following: When I for example have 9 active instances with 1.000 databases per instance and I’ll try to take the ownership to three instances with on one another node – how long this will stay [?] [?] [?] ? The databases usage will be very low but all must be active. And I have to server 99,9% available. I fI need there some hours to switch this can be a big problem.
I know that this is a misterious scenario. But I must implement this with terabytes of data. Thanks in advance. Jens Tolkmitt
[email protected]
With this number of databases and size of data I would contact Microsoft for their input about setting this up, handling failover and backup/restore scenarios.
I have no idea, I have never worked on such a large scenero. I know there are some ISPs that do this kind of think, but I don’t know now they go about it. If you don’t get any good advice here, you might consider e-mailing some large ISPs, asking them how they handle such situations. If you are persistent enough, you should be able to find someone to provide you some advice. —————————–
Brad M. McGehee, MVP