Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajantonyv
Starting Member
12 Posts |
 Posted - 2003-01-07 : 13:02:46
|
| Hello,I had couple of questions regarding having multiple instances of SQL 2000 on a single server. The server will be quad processor machine with at least 2GB RAM. There will be one application database that will reside on the named instance while there will be about 6 or 7 application databases residing on the default instance. We are a small organization about 775 employees...1. Are there any things that we should note when it comes to failover/clustering, performance..., with having multiple instances?Thanks and looking forward to your reply,Raj Antony VRajesh Antony Vattakunnel |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-07 : 13:11:32
|
| Well, using multiple instances on the same computer is NOT the same as failover or clustering. If the server fails, the extra instance does no good at all. If you need failover capabilities, you need another physical server.Performance might be less with multiple instances because they are competing for the same, fixed resources of the server (RAM, disk, I/O capacity and bandwidth) but it depends on how you use multiple instances anyway. |
 |
|
|
rajantonyv
Starting Member
12 Posts |
Posted - 2003-01-07 : 13:40:16
|
| Hi,We will have a failover server with the same amount of physical resources. Question regarding failover:1. I believe MSCS supports multiple instances. I am assuming that you need a named instance with the same name on the failover server with the same database and everything. 2. Also, do you know how these instances will replicate/communicate with each other to make themselves synchonized.3. Are there any documentation out there that explains this in more detail? I have pretty much read everything on books online. Thanks and appreciate all your help in advance,Raj Antony VRajesh Antony Vattakunnel |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-01-07 : 16:06:27
|
| With clustering, they share the same drives, so you don't have to worry about replication between the two different SQL servers.I HIGHLY suggest that you work with Dell, Gateway, HP/Compaq and get their help to setup a SQL cluster. We used HP stuff for ours, and it took some serious work to get it up and working flawlessly. I think you can buy a "cluster in a box" these days. it's two servers and everything you need to cluster them. I'd do that if you can afford it.Failover clustering is very expensive, but it's great when it works. We've not had any problems after we got it all setup.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
|
|
|
|
|
Multiple Instances Of SQL Server 2000