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 jens.tolkmitt@msx-info.de
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 Webmaster SQL-Server-Performance.Com
