x

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.
more ▼

asked Jan 13, 2011 at 03:25 AM in Default

Kev Riley gravatar image

Kev Riley ♦♦
52.7k 47 49 76

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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?
more ▼

answered Jan 13, 2011 at 04:49 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

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!
Jan 13, 2011 at 04:57 AM Kev Riley ♦♦

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.
Jan 13, 2011 at 05:06 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1833
x91
x19

asked: Jan 13, 2011 at 03:25 AM

Seen: 1341 times

Last Updated: Jan 13, 2011 at 03:25 AM