SQL Version 7 Enterprise on MSCS

[Mark944]

I am looking at running several SQL 7 databases either together on a cluster (Enterprise) or each database on a seperate server (Standard). I have management concerns that there could be contention running the databases on a clustered node, has anyone any experience of this, or can they point me in the right direction.

Mark

 

[TomSark]

I need a little more detail here... Are you running in active/active or active/passive mode? And could you provide more details about the contention concerns you are talking about?

Thanks,

Tom

 

[Mark944]

Tom

Thanks for your prompt reply. I plan to have an active/active cluster. The contention worries stem from the probablity that if one of several databases grabs all available resources the other databases and users connected would suffer.

Mark

 

[foxdev]

I believe that in SQLS 7, clustering is purely for failover support. Each database belongs to only one SQL Server during normal (non failure) situations, so no single database could grab all the resources of both servers during normal operation.

Robert Bradley

http://www.foxdev.com/

 

[TomSark]

Actually, this is a valid concern... say you have databases on Server A, and databases on server B. If a failure occurs on A, then Server B obtains databases and resources required by {A} UNION {B} = {AB}, or something close to that...

You should ensure that both servers can handle the newly required resources (new users, more memory needed, additional disk I/O, etc.) that the other server would consume when you get {AB}.

Tom

 

[foxdev]

Yes, available resources is a concern if a failure occurs, as the second server would need to have the resources to do what was doing + its new task. In reading Mark's followup, I got the impression his concern was resource hogging during normal operation. My apologies if I misunderstood.

Robert Bradley

http://www.foxdev.com/

 

[TomSark]

Under normal operation there shouldn't be any additional resource hogging that I'm aware of... only when failures occur...

Tom