question

Kev Riley avatar image
Kev Riley asked

SQL 2008 and DB2 on same cluster - advice needed

Looking for some advice: Any issues running SQL Server 2008 STD x64 on a standard active passive windows server r2 x64 cluster along side a DB2 install on same cluster? Apart from performance.
sql-server-2008clusterdb2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
Why shouldn't it work? As far as clustering is concerned, they are cluster services which will then be failed over as normal if needed/wanted. As you say, performance could be an issue, but you'll be looking at splitting the resources as necessary so as long as that is ok that should be fine. I don't have Win 2k8r2 for my cluster, but 2k8 has been ***rock*** solid from day one. I cannot see there being any issues there. Are you adding both to a new cluster, or adding SQL Server to a current DB2 cluster?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
To be honest I don't really know - I was asked the question by a friend who thinks I know something about databases - so I thought I would throw it out here. My gut feel is that if there is enough resources (cpu/disk/ram) for both, and they can be configured not to clash, then it's a suck-it-and-see approach!
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
I think so too - it is similar to running SQL and Exchange on the same box (I think that cluster or not is irrelevant really). It can be done, you just have to be careful. They just have to be aware that the resources are going to be crunched by both in a way they/their cluster/san admins may not expect. I wouldn't recommend it though - troubleshooting any issues is going to cause a lot of finger pointing / energetic gesturing, unless both systems and the underlying hardware have *bloody* good metrics and baselines.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.