Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server Mirroring Interview Questions > Recommend minimum hardware required for a redundan...

:: Categories ::

Interview Question in SQL Server Mirroring


 

Interview Question :: Recommend minimum hardware required for a redundant MS SQL Server installation


Recommend minimum hardware required for a redundant MS SQL Server installation to handle 300 tps ave, 600 tps pk. Please recommend redundancy type also (e.g., database mirroring, failover clustering, database snapshots).
Answers to "Recommend minimum hardware required for a redundant MS SQL Server installation"
RE: Recommend minimum hardware required for a redundant MS SQL Server installation?

i can't give you hardware recommendations (i'm not a hardware guy,) but i'd guess that is the lessor of your worries. as far as redundancy issues, there are many things to consider. the 300 to 600 tps is the first real requirement. that being the case, i would not recommend a "fail-over" solution. this leaves a very expensive piece of hardware sitting doing nothing to help your response times. so either database mirroring or replication (what you called snapshots?) we have tried both, and decided that replication is the better choice, and cheaper btw, since the database supports this natively without additional software.



so, go with a load-balancing solution that allows both (or more) of your servers to do work for you rather than one working and the other(s) sitting and waiting. next, if you go with replication, i would recommend using merge rather than snapshot replication as this will enable transactions to replicate quicker. you will, of course, use a snapshot to initialize any form of replication, but use merge to continuously keep your data in sync.



good luck
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License