Cluster 2005 and another instance

[timscronin]

We have a 3rd pary app coming in that needs to run on several sql 2005 Servers. Our network ops wants to run one active/active cluster and then another instance of sql 2005 on the same box. I didn't think this was possible? Any opinions appreciated

 

[mrdenny]

You can run more than one instance on a cluster.

Each instance can be on one node, or all instances can be on one node. Each instance can run on no more than one node at a time.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[timscronin]

I thought you could but I have concerns.
One application, all db's doing different function. The problem is that on the active/active there will be a db that the oltp is on. The other db server would be a logging server, which does and audit log of each transaction. The other db server is a reporting server. I am not comfortable with either one of these sitting on an oltp cluster.

THe real question is whether or not this is a good idea

 

[mrdenny]

OLTP and Reporting should be seperate. They should never be on the same hardware.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com