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 |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2004-09-29 : 10:33:41
|
| Today we have a cluster runnin on one node SQL Server 2K and on the other node Oracle.We have to face a problem now and decide where to put Lotus Notes and the entire File System.We have 2 possibility, one is to put these 2 new virtual server and applications on the cluster, the other one is to buy another cluster.Regardless of the financial aspect of the problem I am searching for articles, Microsoft notes,IBM notes or guru's advises that can show some good point and some bad points of these 2 possibility.In my opinion I would like to leave SQL Server alone on one Server and Oracle on the other node, buy another cluster and put Lotus Notes on one node and File system on the second node.Can you please help me with this problem?Thank you very much and kind regards.Franco |
|
|
MuadDBA
628 Posts |
Posted - 2004-09-29 : 16:31:07
|
| Yeah, I am sure if you look in the installation guides or best practices guides for either of the two RDBMS, you will find that they recommend that the server runs on dedicated hardware. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-09-30 : 04:05:05
|
| IMHO, i'd say you should have a dedicated machine for your sql server. One thing is for sure, from experience, troubleshooting problems related to sql is already difficult without having to consider if the error was invoked by other applications, and to top it all, this is in a cluster. Implication is that if one application begins to trigger errors, you'll spend more time troubleshooting where the error was invoked, wondering if it was sql or the other apps. And let's say it's the lotus notes and this caused the group to fail, will the 2nd node handle the load?just a thought... |
|
|
|
|
|
|
|
|
Multiple applications on cluster