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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-31 : 09:41:43
|
| sekhar writes "I am planning to set up Active/Active cluster environment with Win2000 Advanced and SQL2000 server. There will be three instances of SQL on NODE-1 and two instances of SQL on NODE-2. I would like to use Component services (previously MTS) of Windows 2000 for connection pooling and transaction support as we are expecting 1200 connections minimum at any given time on each node. Each instance will manage multiple databases which are unique across cluster. Can some one suggest me how to go about this. I am not clear whether I should be running the Component services on each node OR should I use a different server and monitor both nodes from there. Thanks in advance " |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-31 : 11:35:27
|
| I am not what you would call an MTS, or COM+ expert, but I in my understanding, I think that the COM+ (Or component services) layer should be on a seperate machine form your data layer. I know this is not required, but it looks like you have enough going on on the database layer (5 instances of SQL) so I would give the COM+ layer to a different machine.My 2 cents-Chad |
 |
|
|
|
|
|
SQL2000 Cluster and Component Services