Cluster services overhead

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,
JackIt 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@.discussions.microsoft.com> wrote in message =news:1b07301c44fcf$51c472b0$a601280a@.phx.gbl...
> > 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
>|||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@.comcast.net> wrote in message
news:OYr8Ip9TEHA.716@.TK2MSFTNGP11.phx.gbl...
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@.discussions.microsoft.com> wrote in message
news:1b07301c44fcf$51c472b0$a601280a@.phx.gbl...
> 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
>|||I am unfamiliar with the Compaq hardware mentioned, but I do know that
hardware that uses SCSI technology or host controller based caching can
suffer greatly in a clustered environment. All host caching has to be
turned off in a clustered environment to avoid data integrity problems.
This can severely impact disk performacne, especially with disk writes in a
RAID-5 configuration. While this may not apply to your circumstance, it is
the primary reason I do not recommend clustering with SCSI hardware.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:1b07301c44fcf$51c472b0$a601280a@.phx.gbl...
> 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
>

Cluster Installation Failure

Thanks in advance for any help.
A SQL 2005 Failover Clustering installation (from the RTM disks) failed on
Database Services. Please see messages below. Windows cluster server name
is COMDEVDB01 (Windows 2003), primary node = COMDEVCLU01, secondary node =
COMDEVCLU02. SQL cluster virtual name = COMDEVSQLCLU, named instance =
COMDEVPROD. I installed from COMDEVCLU01. Should I install from COMDEVDB01
while COMDEVCLU01 is the active node (i.e., I will be on COMDEVCLU01)?
Earlier install failed on SQLBrowser errors and rolled back. Before the
cluster install two non-clustered SQL 2005 named instances had been installed
on COMDEVCLU01 and SP2 had been applied (both current versions = 3152).
After the SQLBrowser failure I installed a non-clustered SQL 2005 named
instance on COMDEVCLU02 with Database Services and Integration Services (also
version 3152). After that, the cluster install on COMDEVCLU01 failed with
these errors but did not rollback.
Should I try to install SP2 for the SQL cluster from COMDEVCLU01?
Can I "complete" this installation (save it) or will I have to uninstall and
re-install?
Should I uninstall all SQL Server instances on COMDEVCLU01 and install the
clustered instance first?
summary.txt message:
Machine : COMDEVCLU01
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0006_COMDEVCLU01_SQL.l og
Last Action : ComponentUpgrade
Error String : The setup has encountered an error while Upgrading
Components. The error: -2147019873
Error message: The group or resource is not in the correct state to perform
the requested operation.
Error Number : 29550
SQLSetup0006_COMDEVCLU01_SQL.log message:
MSI (s) (AC:14) [15:52:23:016]: Product: Microsoft SQL Server 2005 - Update
'Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000)' could not
be installed. Error code 1603.
MichaelA_CCGA
Michael:
I will be posting a similar question to yours entitled "Failed SQL Cluster
Advice." That hopefully will get answered as well.
In the meantime you mentioned RTM Disks. Are these CDs and did your install
fail when you put in Disk 2 "Tools" This is my issue and I have googled to
find that this is a known issue and the resolution is copy both disks to a
common path.
Was this your issue as well?
Thanks, emagidson
"MichaelA_CCGA" wrote:

> Thanks in advance for any help.
> A SQL 2005 Failover Clustering installation (from the RTM disks) failed on
> Database Services. Please see messages below. Windows cluster server name
> is COMDEVDB01 (Windows 2003), primary node = COMDEVCLU01, secondary node =
> COMDEVCLU02. SQL cluster virtual name = COMDEVSQLCLU, named instance =
> COMDEVPROD. I installed from COMDEVCLU01. Should I install from COMDEVDB01
> while COMDEVCLU01 is the active node (i.e., I will be on COMDEVCLU01)?
> Earlier install failed on SQLBrowser errors and rolled back. Before the
> cluster install two non-clustered SQL 2005 named instances had been installed
> on COMDEVCLU01 and SP2 had been applied (both current versions = 3152).
> After the SQLBrowser failure I installed a non-clustered SQL 2005 named
> instance on COMDEVCLU02 with Database Services and Integration Services (also
> version 3152). After that, the cluster install on COMDEVCLU01 failed with
> these errors but did not rollback.
> Should I try to install SP2 for the SQL cluster from COMDEVCLU01?
> Can I "complete" this installation (save it) or will I have to uninstall and
> re-install?
> Should I uninstall all SQL Server instances on COMDEVCLU01 and install the
> clustered instance first?
> summary.txt message:
> ----
> Machine : COMDEVCLU01
> Product : Microsoft SQL Server 2005
> Product Version : 9.00.1399.06
> Install : Failed
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Files\SQLSetup0006_COMDEVCLU01_SQL.l og
> Last Action : ComponentUpgrade
> Error String : The setup has encountered an error while Upgrading
> Components. The error: -2147019873
> Error message: The group or resource is not in the correct state to perform
> the requested operation.
> Error Number : 29550
> ----
> SQLSetup0006_COMDEVCLU01_SQL.log message:
> ----
> MSI (s) (AC:14) [15:52:23:016]: Product: Microsoft SQL Server 2005 - Update
> 'Hotfix 3024 for SQL Server Database Services 2005 ENU (KB000000)' could not
> be installed. Error code 1603.
> --
> MichaelA_CCGA
|||Sorry I dropped out of the discussion but I wanted to post the question
before I took a few days off and I'm just now catching up. I have printed
your exchange with Geoff and I will review that in more detail.
I did not have the "2nd CD" problem but the information about uninstalling
may prove very useful.
Thanks again, and I'll check back in tomorrow or Thursday.
MichaelA_CCGA
"EMagidson" wrote:
[vbcol=seagreen]
> Michael:
> I will be posting a similar question to yours entitled "Failed SQL Cluster
> Advice." That hopefully will get answered as well.
> In the meantime you mentioned RTM Disks. Are these CDs and did your install
> fail when you put in Disk 2 "Tools" This is my issue and I have googled to
> find that this is a known issue and the resolution is copy both disks to a
> common path.
> Was this your issue as well?
> Thanks, emagidson
> "MichaelA_CCGA" wrote:

Cluster Install

We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
logical disks defined outside of the quorum. When I install the Virtual
server, I select the parent group of the disks which happens to be the SQL
Server resource group which contains all resources except the clsuter
specific items. When I finish, I can only see one logical disk from within
EM even though both are on the node I am working from . Any thoughts on how
to see multiple logical disks?Starting with a LUN that is a cluster resource. Add the disk resource to
the SQL Resource group if it is not there already. Make the SQL Service
dependent on the additionan disk resource (just like the existing disk.)
You will have to stop SQL to change the dependencies.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:D52638EE-3297-4D6E-9971-7B7759DDD7A6@.microsoft.com...
> We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
> logical disks defined outside of the quorum. When I install the Virtual
> server, I select the parent group of the disks which happens to be the SQL
> Server resource group which contains all resources except the clsuter
> specific items. When I finish, I can only see one logical disk from
> within
> EM even though both are on the node I am working from . Any thoughts on
> how
> to see multiple logical disks?

Cluster Install

We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
logical disks defined outside of the quorum. When I install the Virtual
server, I select the parent group of the disks which happens to be the SQL
Server resource group which contains all resources except the clsuter
specific items. When I finish, I can only see one logical disk from within
EM even though both are on the node I am working from . Any thoughts on how
to see multiple logical disks?Starting with a LUN that is a cluster resource. Add the disk resource to
the SQL Resource group if it is not there already. Make the SQL Service
dependent on the additionan disk resource (just like the existing disk.)
You will have to stop SQL to change the dependencies.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:D52638EE-3297-4D6E-9971-7B7759DDD7A6@.microsoft.com...
> We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
> logical disks defined outside of the quorum. When I install the Virtual
> server, I select the parent group of the disks which happens to be the SQL
> Server resource group which contains all resources except the clsuter
> specific items. When I finish, I can only see one logical disk from
> within
> EM even though both are on the node I am working from . Any thoughts on
> how
> to see multiple logical disks?

Cluster Install

We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
logical disks defined outside of the quorum. When I install the Virtual
server, I select the parent group of the disks which happens to be the SQL
Server resource group which contains all resources except the clsuter
specific items. When I finish, I can only see one logical disk from within
EM even though both are on the node I am working from . Any thoughts on how
to see multiple logical disks?
Starting with a LUN that is a cluster resource. Add the disk resource to
the SQL Resource group if it is not there already. Make the SQL Service
dependent on the additionan disk resource (just like the existing disk.)
You will have to stop SQL to change the dependencies.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:D52638EE-3297-4D6E-9971-7B7759DDD7A6@.microsoft.com...
> We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
> logical disks defined outside of the quorum. When I install the Virtual
> server, I select the parent group of the disks which happens to be the SQL
> Server resource group which contains all resources except the clsuter
> specific items. When I finish, I can only see one logical disk from
> within
> EM even though both are on the node I am working from . Any thoughts on
> how
> to see multiple logical disks?
sqlsql

Cluster DR

My production cluster disks are corruptd - i would like to find out how to
restore from backups
I have all system backups and mdf and ldf files of the databases - I would
like to keep the logins, jobs etc
Thanks
Restoring a cluster is almost exactly the same as restoring a stand-alone
SQL Server. The only difference is that when you restire the master
database, the disks have to be online using the cluster tool, but leave the
SQL Server service offline. You then start and stop it in single-user mode
using the command-line. See BOL for details on how to restore a SQL Server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"John Smith" <bukusu@.gmail.com> wrote in message
news:el5gBC7GGHA.532@.TK2MSFTNGP15.phx.gbl...
> My production cluster disks are corruptd - i would like to find out how to
> restore from backups
> I have all system backups and mdf and ldf files of the databases - I would
> like to keep the logins, jobs etc
>
> Thanks
>

cluster ? on muliple data disks

Hi,
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?
The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?
|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:

> The "trick" is twofold. First, you have to make the disks Cluster Resources
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Service
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
>
>

cluster ? on muliple data disks

Hi,
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:
> The "trick" is twofold. First, you have to make the disks Cluster Resources
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Service
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> > Hi,
> > I have setup a 2 node a/p cluster. During install i picked the s drive as
> > the data drive, and the L drive as the log drive.
> > i was able to create a db on the S drive
> > now i want to create a database and use the z drive. but it won't show me
> > the Z drive as a option when i try to browse to a different drive as part
> > of
> > the create new db steps.
> >
> > both disks are disk resources managed by the cluster
> >
> > in the past, i have been able to do it on a non clustered server
> >
> > what is the trick with a cluster?
>
>

cluster ? on muliple data disks

Hi,
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:

> The "trick" is twofold. First, you have to make the disks Cluster Resourc
es
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Servi
ce
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
>
>