dbTalk Databases Forums  

Re: Cluster services overhead

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Re: Cluster services overhead in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Keith Kratochvil
 
Posts: n/a

Default Re: Cluster services overhead - 06-11-2004 , 12:33 PM






It is possible, although I would not expect the clustering technology to have a noticable impact on performance. You talk about instances. Are you running multiple instances of SQL Server on the same hardware, or by "instance" do you mean Server A (standalone box) and Server B (clustered box)? If you are talking about multiple instances on one server are the instances configured to use the same amount of resources?

This reply will be posted within .server and it will also be copied to the .clustering newsgroup. Hopefully the experts that hang out there will have additional comments orideas.

--
Keith


"Jack A" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Consider the scenario ...

Instance 1 of Sql Server running on Compaq with MSA1000
disks

Instance 2 of Sql Server running on Compaq with MSA1000
disks BUT in a clustered environment

We are finding that Instance 1 offers better performance
than 2 for the same configuration (memory, sql version,
windows etc). Could the use of cluster services for
clustering be causing the overhead?

TIA,
Jack


Reply With Quote
  #2  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: Cluster services overhead - 06-11-2004 , 01:36 PM






I have never felt the presence of clustering on any of my SQL clusters. The
cluster service has such a small footprint. Could it be that you are not
comparing like DBs?

Cheers,

Rod

"Keith Kratochvil" <sqlguy.back2u (AT) comcast (DOT) net> wrote

It is possible, although I would not expect the clustering technology to
have a noticable impact on performance. You talk about instances. Are you
running multiple instances of SQL Server on the same hardware, or by
"instance" do you mean Server A (standalone box) and Server B (clustered
box)? If you are talking about multiple instances on one server are the
instances configured to use the same amount of resources?

This reply will be posted within .server and it will also be copied to the
..clustering newsgroup. Hopefully the experts that hang out there will have
additional comments orideas.

--
Keith


"Jack A" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Consider the scenario ...

Instance 1 of Sql Server running on Compaq with MSA1000
disks

Instance 2 of Sql Server running on Compaq with MSA1000
disks BUT in a clustered environment

We are finding that Instance 1 offers better performance
than 2 for the same configuration (memory, sql version,
windows etc). Could the use of cluster services for
clustering be causing the overhead?

TIA,
Jack




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.