Hi,
We have a cluster (2node, 8Way, 8GB) running windows 2000 Advanced. We would
like to upgrade to windows 2003 Enterprise Edition
Whats the easiest way to accmplish this ? what are the options ? are there
any links ?
The easiest way is to upgrade in place. I don't like that technique, so I
usually recommend a two-step upgrade. First, upgrade each node in place to
Windows 2003. Then uninstall SQL from one node, evict it, rebuild it, add
it back to the cluster, and finally re-install SQL and any hotfixes. Repeat
with the other node. That way, you get an upgraded cluster with newly
rebuilt nodes. You can even change the hardware nodes at this time by using
new ones when you replace the original nodes.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Seme Rollansa" <bukusu@.gmail.com> wrote in message
news:OWfS9$6GGHA.3828@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> We have a cluster (2node, 8Way, 8GB) running windows 2000 Advanced. We
> would like to upgrade to windows 2003 Enterprise Edition
> Whats the easiest way to accmplish this ? what are the options ? are there
> any links ?
>
Showing posts with label running. Show all posts
Showing posts with label running. Show all posts
Thursday, March 29, 2012
Cluster testing
I need to setup a 2 node cluster for testing.
I have 2 identical servers running Win2k3, but I have a question about the
shared disk device.
For the shared disk can I use a NAS device, one that connects thru a cat5,
or do I need a device that uses scsi?
Remember this is for a short term test.
Thanks
SQL Clustering won't support NAS. SCSI would work, but why not try Virtual
Server 2005? That works great!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"dutch" <dutch@.discussions.microsoft.com> wrote in message
news:2CCAEA46-6F5F-44D6-86A1-5BBAD07F8B18@.microsoft.com...
>I need to setup a 2 node cluster for testing.
> I have 2 identical servers running Win2k3, but I have a question about the
> shared disk device.
> For the shared disk can I use a NAS device, one that connects thru a cat5,
> or do I need a device that uses scsi?
> Remember this is for a short term test.
> Thanks
sqlsql
I have 2 identical servers running Win2k3, but I have a question about the
shared disk device.
For the shared disk can I use a NAS device, one that connects thru a cat5,
or do I need a device that uses scsi?
Remember this is for a short term test.
Thanks
SQL Clustering won't support NAS. SCSI would work, but why not try Virtual
Server 2005? That works great!
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"dutch" <dutch@.discussions.microsoft.com> wrote in message
news:2CCAEA46-6F5F-44D6-86A1-5BBAD07F8B18@.microsoft.com...
>I need to setup a 2 node cluster for testing.
> I have 2 identical servers running Win2k3, but I have a question about the
> shared disk device.
> For the shared disk can I use a NAS device, one that connects thru a cat5,
> or do I need a device that uses scsi?
> Remember this is for a short term test.
> Thanks
sqlsql
Tuesday, March 27, 2012
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? =20
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.
--=20
Keith
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message =
news:1b07301c44fcf$51c472b0$a601280a@.phx
.gbl...
>=20
> Consider the scenario ...
>=20
> Instance 1 of Sql Server running on Compaq with MSA1000=20
> disks=20
>=20
> Instance 2 of Sql Server running on Compaq with MSA1000=20
> disks BUT in a clustered environment
>=20
> We are finding that Instance 1 offers better performance=20
> than 2 for the same configuration (memory, sql version,=20
> windows etc). Could the use of cluster services for=20
> clustering be causing the overhead?
>=20
> 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 hav
e
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
>
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? =20
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.
--=20
Keith
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message =
news:1b07301c44fcf$51c472b0$a601280a@.phx
.gbl...
>=20
> Consider the scenario ...
>=20
> Instance 1 of Sql Server running on Compaq with MSA1000=20
> disks=20
>=20
> Instance 2 of Sql Server running on Compaq with MSA1000=20
> disks BUT in a clustered environment
>=20
> We are finding that Instance 1 offers better performance=20
> than 2 for the same configuration (memory, sql version,=20
> windows etc). Could the use of cluster services for=20
> clustering be causing the overhead?
>=20
> 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 hav
e
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 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,
Jack
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? =20
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.
--=20
Keith
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message =
news:1b07301c44fcf$51c472b0$a601280a@.phx.gbl...
>=20
> Consider the scenario ...
>=20
> Instance 1 of Sql Server running on Compaq with MSA1000=20
> disks=20
>=20
> Instance 2 of Sql Server running on Compaq with MSA1000=20
> disks BUT in a clustered environment
>=20
> We are finding that Instance 1 offers better performance=20
> than 2 for the same configuration (memory, sql version,=20
> windows etc). Could the use of cluster services for=20
> clustering be causing the overhead?
>=20
> 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
>
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
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? =20
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.
--=20
Keith
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message =
news:1b07301c44fcf$51c472b0$a601280a@.phx.gbl...
>=20
> Consider the scenario ...
>=20
> Instance 1 of Sql Server running on Compaq with MSA1000=20
> disks=20
>=20
> Instance 2 of Sql Server running on Compaq with MSA1000=20
> disks BUT in a clustered environment
>=20
> We are finding that Instance 1 offers better performance=20
> than 2 for the same configuration (memory, sql version,=20
> windows etc). Could the use of cluster services for=20
> clustering be causing the overhead?
>=20
> 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 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
>
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 service error
I had a Windows Server 2003 (Enterprise ed) cluster with 2 nodes
running.
When I try to start the service through Cluster Administrator, which
is
installed on the local machine, I get "Error 1060: The specified
service does
not exist as an installed service"
The cluster service does not appear to be installed.but the same is
installed in other node .
Shouldn't this service be installed along with the OS and if so what
do you
suggest'
Any help on this would be appreciated as I cannot find any info on
this
problem anywhere......Hi,
I'm not quite sure which service you try to start, but the SQL server
services will not be runnning on the passive node of the cluster. when
you move your ressources to that node, the services will be started ( -
and will be stopped on the node that now is the passive ).
The cluster service will be running on both servers though.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
get2rajesh@.gmail.com wrote:
> I had a Windows Server 2003 (Enterprise ed) cluster with 2 nodes
> running.
> When I try to start the service through Cluster Administrator, which
> is
> installed on the local machine, I get "Error 1060: The specified
> service does
> not exist as an installed service"
> The cluster service does not appear to be installed.but the same is
> installed in other node .
> Shouldn't this service be installed along with the OS and if so what
> do you
> suggest'
> Any help on this would be appreciated as I cannot find any info on
> this
> problem anywhere......
>|||On Mar 7, 5:25 pm, "Steen Schl=FCter Persson (DK)"
<steen@.REMOVE_THIS_asavaenget.dk> wrote:
> Hi,
> I'm not quite sure whichserviceyou try to start, but the SQL server
> services will not be runnning on the passive node of thecluster. when
> you move your ressources to that node, the services will be started ( -
> and will be stopped on the node that now is the passive ).
> Theclusterservicewill be running on both servers though.
> --
> Regards
> Steen Schl=FCter Persson
> Database Administrator / System Administrator
>
> get2raj...@.gmail.com wrote:
> > I had a Windows Server 2003 (Enterprise ed)clusterwith 2 nodes
> > running.
> > When I try to start theservicethroughClusterAdministrator, which
> > is
> > installed on the local machine, I get "Error1060: The specified
> >servicedoes
> > not exist as an installedservice"
> > Theclusterservicedoes not appear to be installed.but the same is
> > installed in other node .
> > Shouldn't thisservicebe installed along with the OS and if so what
> > do you
> > suggest'
> > Any help on this would be appreciated as I cannot find any info on
> > this
> > problem anywhere......- Hide quoted text -
> - Show quoted text -
Hi Steen
The cluster server is not starting on the node-1. when i try to start
the service it says cluster service does not exist as an installed
service. As I tried to start the service from C:\WINDOWS\Cluster still
it is not starting is there a way to install these service which i am
not able to see on NODE-1 but it is present on NODE-2 which is active
but all drives are offline expect.
1)cluster IP Address
2)Cluster name
3)Disk Q (Quram)
4)MSDDTC
I think if the service starts on NODE-1 the cluster will be up.
Thanks,
Rajesh|||<get2rajesh@.gmail.com> wrote in message
news:1173271137.650631.212640@.v33g2000cwv.googlegroups.com...
On Mar 7, 5:25 pm, "Steen Schlüter Persson (DK)"
<steen@.REMOVE_THIS_asavaenget.dk> wrote:
> Hi,
> I'm not quite sure whichserviceyou try to start, but the SQL server
> services will not be runnning on the passive node of thecluster. when
> you move your ressources to that node, the services will be started ( -
> and will be stopped on the node that now is the passive ).
> Theclusterservicewill be running on both servers though.
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator
>
> get2raj...@.gmail.com wrote:
> > I had a Windows Server 2003 (Enterprise ed)clusterwith 2 nodes
> > running.
> > When I try to start theservicethroughClusterAdministrator, which
> > is
> > installed on the local machine, I get "Error1060: The specified
> >servicedoes
> > not exist as an installedservice"
> > Theclusterservicedoes not appear to be installed.but the same is
> > installed in other node .
> > Shouldn't thisservicebe installed along with the OS and if so what
> > do you
> > suggest'
> > Any help on this would be appreciated as I cannot find any info on
> > this
> > problem anywhere......- Hide quoted text -
> - Show quoted text -
Are you sure NODE-1 is setup to be part of the SQL Cluster.
(keep in mind clustering SQL is two steps, creating nodes as a window
cluster and then defining/creating the SQL cluster.
For example, you could have 3 nodes in a windows cluster, A, B, C. A,B
could be setup as a SQL cluster and B,C as an exchange cluster.)
And all services should start on any valid cluster, there is no preferred
cluster.
Hi Steen
The cluster server is not starting on the node-1. when i try to start
the service it says cluster service does not exist as an installed
service. As I tried to start the service from C:\WINDOWS\Cluster still
it is not starting is there a way to install these service which i am
not able to see on NODE-1 but it is present on NODE-2 which is active
but all drives are offline expect.
1)cluster IP Address
2)Cluster name
3)Disk Q (Quram)
4)MSDDTC
I think if the service starts on NODE-1 the cluster will be up.
Thanks,
Rajesh
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
running.
When I try to start the service through Cluster Administrator, which
is
installed on the local machine, I get "Error 1060: The specified
service does
not exist as an installed service"
The cluster service does not appear to be installed.but the same is
installed in other node .
Shouldn't this service be installed along with the OS and if so what
do you
suggest'
Any help on this would be appreciated as I cannot find any info on
this
problem anywhere......Hi,
I'm not quite sure which service you try to start, but the SQL server
services will not be runnning on the passive node of the cluster. when
you move your ressources to that node, the services will be started ( -
and will be stopped on the node that now is the passive ).
The cluster service will be running on both servers though.
--
Regards
Steen Schlüter Persson
Database Administrator / System Administrator
get2rajesh@.gmail.com wrote:
> I had a Windows Server 2003 (Enterprise ed) cluster with 2 nodes
> running.
> When I try to start the service through Cluster Administrator, which
> is
> installed on the local machine, I get "Error 1060: The specified
> service does
> not exist as an installed service"
> The cluster service does not appear to be installed.but the same is
> installed in other node .
> Shouldn't this service be installed along with the OS and if so what
> do you
> suggest'
> Any help on this would be appreciated as I cannot find any info on
> this
> problem anywhere......
>|||On Mar 7, 5:25 pm, "Steen Schl=FCter Persson (DK)"
<steen@.REMOVE_THIS_asavaenget.dk> wrote:
> Hi,
> I'm not quite sure whichserviceyou try to start, but the SQL server
> services will not be runnning on the passive node of thecluster. when
> you move your ressources to that node, the services will be started ( -
> and will be stopped on the node that now is the passive ).
> Theclusterservicewill be running on both servers though.
> --
> Regards
> Steen Schl=FCter Persson
> Database Administrator / System Administrator
>
> get2raj...@.gmail.com wrote:
> > I had a Windows Server 2003 (Enterprise ed)clusterwith 2 nodes
> > running.
> > When I try to start theservicethroughClusterAdministrator, which
> > is
> > installed on the local machine, I get "Error1060: The specified
> >servicedoes
> > not exist as an installedservice"
> > Theclusterservicedoes not appear to be installed.but the same is
> > installed in other node .
> > Shouldn't thisservicebe installed along with the OS and if so what
> > do you
> > suggest'
> > Any help on this would be appreciated as I cannot find any info on
> > this
> > problem anywhere......- Hide quoted text -
> - Show quoted text -
Hi Steen
The cluster server is not starting on the node-1. when i try to start
the service it says cluster service does not exist as an installed
service. As I tried to start the service from C:\WINDOWS\Cluster still
it is not starting is there a way to install these service which i am
not able to see on NODE-1 but it is present on NODE-2 which is active
but all drives are offline expect.
1)cluster IP Address
2)Cluster name
3)Disk Q (Quram)
4)MSDDTC
I think if the service starts on NODE-1 the cluster will be up.
Thanks,
Rajesh|||<get2rajesh@.gmail.com> wrote in message
news:1173271137.650631.212640@.v33g2000cwv.googlegroups.com...
On Mar 7, 5:25 pm, "Steen Schlüter Persson (DK)"
<steen@.REMOVE_THIS_asavaenget.dk> wrote:
> Hi,
> I'm not quite sure whichserviceyou try to start, but the SQL server
> services will not be runnning on the passive node of thecluster. when
> you move your ressources to that node, the services will be started ( -
> and will be stopped on the node that now is the passive ).
> Theclusterservicewill be running on both servers though.
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator
>
> get2raj...@.gmail.com wrote:
> > I had a Windows Server 2003 (Enterprise ed)clusterwith 2 nodes
> > running.
> > When I try to start theservicethroughClusterAdministrator, which
> > is
> > installed on the local machine, I get "Error1060: The specified
> >servicedoes
> > not exist as an installedservice"
> > Theclusterservicedoes not appear to be installed.but the same is
> > installed in other node .
> > Shouldn't thisservicebe installed along with the OS and if so what
> > do you
> > suggest'
> > Any help on this would be appreciated as I cannot find any info on
> > this
> > problem anywhere......- Hide quoted text -
> - Show quoted text -
Are you sure NODE-1 is setup to be part of the SQL Cluster.
(keep in mind clustering SQL is two steps, creating nodes as a window
cluster and then defining/creating the SQL cluster.
For example, you could have 3 nodes in a windows cluster, A, B, C. A,B
could be setup as a SQL cluster and B,C as an exchange cluster.)
And all services should start on any valid cluster, there is no preferred
cluster.
Hi Steen
The cluster server is not starting on the node-1. when i try to start
the service it says cluster service does not exist as an installed
service. As I tried to start the service from C:\WINDOWS\Cluster still
it is not starting is there a way to install these service which i am
not able to see on NODE-1 but it is present on NODE-2 which is active
but all drives are offline expect.
1)cluster IP Address
2)Cluster name
3)Disk Q (Quram)
4)MSDDTC
I think if the service starts on NODE-1 the cluster will be up.
Thanks,
Rajesh
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
Sunday, March 25, 2012
Cluster Node Tuning
Hi,
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Server
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
John
1. Background Services
2. Programs
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John
|||Thanks Mike. That's what I had.
John
"Mike Epprecht (SQL MVP)" wrote:
> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
>
>
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Server
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
John
1. Background Services
2. Programs
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John
|||Thanks Mike. That's what I had.
John
"Mike Epprecht (SQL MVP)" wrote:
> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
>
>
Cluster Node Tuning
Hi,
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Server
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
--
John1. Background Services
2. Programs
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John|||Thanks Mike. That's what I had.
--
John
"Mike Epprecht (SQL MVP)" wrote:
> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> > Hi,
> > I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> > has
> > 8GB of RAM, and each node is the preferred owner of one of the two SQL
> > Server
> > instances, each of which are AWE enabled and have min and max server
> > memory
> > set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> > is
> > via FC direct attached SAN. My question:
> > Under System Properties/Advanced/Performance Options:
> > 1. Should I set Processor Scheduling to Programs or Background Services?
> > 2. Should I set Memory Usage to Programs or System Cache?
> >
> > Thank you!
> > --
> > John
>
>
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Server
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
--
John1. Background Services
2. Programs
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John|||Thanks Mike. That's what I had.
--
John
"Mike Epprecht (SQL MVP)" wrote:
> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> > Hi,
> > I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> > has
> > 8GB of RAM, and each node is the preferred owner of one of the two SQL
> > Server
> > instances, each of which are AWE enabled and have min and max server
> > memory
> > set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> > is
> > via FC direct attached SAN. My question:
> > Under System Properties/Advanced/Performance Options:
> > 1. Should I set Processor Scheduling to Programs or Background Services?
> > 2. Should I set Memory Usage to Programs or System Cache?
> >
> > Thank you!
> > --
> > John
>
>
Cluster Node Tuning
Hi,
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Serve
r
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
--
John1. Background Services
2. Programs
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John|||Thanks Mike. That's what I had.
--
John
"Mike Epprecht (SQL MVP)" wrote:
> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
>
>
I have a 2 node failover cluster running SQL2000 EE with SP4. Each node has
8GB of RAM, and each node is the preferred owner of one of the two SQL Serve
r
instances, each of which are AWE enabled and have min and max server memory
set to 3GB. PAE and /3GB switch are also enabled on each node. Storage is
via FC direct attached SAN. My question:
Under System Properties/Advanced/Performance Options:
1. Should I set Processor Scheduling to Programs or Background Services?
2. Should I set Memory Usage to Programs or System Cache?
Thank you!
--
John1. Background Services
2. Programs
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JT" <Jthayer@.online.nospam> wrote in message
news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
> Hi,
> I have a 2 node failover cluster running SQL2000 EE with SP4. Each node
> has
> 8GB of RAM, and each node is the preferred owner of one of the two SQL
> Server
> instances, each of which are AWE enabled and have min and max server
> memory
> set to 3GB. PAE and /3GB switch are also enabled on each node. Storage
> is
> via FC direct attached SAN. My question:
> Under System Properties/Advanced/Performance Options:
> 1. Should I set Processor Scheduling to Programs or Background Services?
> 2. Should I set Memory Usage to Programs or System Cache?
> Thank you!
> --
> John|||Thanks Mike. That's what I had.
--
John
"Mike Epprecht (SQL MVP)" wrote:
> 1. Background Services
> 2. Programs
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JT" <Jthayer@.online.nospam> wrote in message
> news:F0EE0BDB-79DE-4E7D-BE5E-6D9F9DF95C5D@.microsoft.com...
>
>
Cluster Name Failing...
Hi All, Cluster Group is failing to come online due to cluster name.
Unfortunately running MSCS on Win2k Adv Server so most of the help mentioned
is towards Win2k3...Any luck guys...?
Event ID: 1052 and 1069
TIA
CLuster name failing is a Cluster service issue, not SQL, yes?
SQL Name failing is different.
What to the application and system event logs say?
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Vai2000" <nospam@.microsoft.com> wrote in message
news:%23MuguCnMGHA.500@.TK2MSFTNGP15.phx.gbl...
> Hi All, Cluster Group is failing to come online due to cluster name.
> Unfortunately running MSCS on Win2k Adv Server so most of the help
> mentioned
> is towards Win2k3...Any luck guys...?
> Event ID: 1052 and 1069
> TIA
>
Unfortunately running MSCS on Win2k Adv Server so most of the help mentioned
is towards Win2k3...Any luck guys...?
Event ID: 1052 and 1069
TIA
CLuster name failing is a Cluster service issue, not SQL, yes?
SQL Name failing is different.
What to the application and system event logs say?
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Vai2000" <nospam@.microsoft.com> wrote in message
news:%23MuguCnMGHA.500@.TK2MSFTNGP15.phx.gbl...
> Hi All, Cluster Group is failing to come online due to cluster name.
> Unfortunately running MSCS on Win2k Adv Server so most of the help
> mentioned
> is towards Win2k3...Any luck guys...?
> Event ID: 1052 and 1069
> TIA
>
Cluster memory issue
I'm currently running 2 SQl Instance as an active/active
cluster.
Both servers are identical running windows 2000 Advance
server.
SQL Server Enterprise 2000 with settings exactly the same
on both servers,
8GB of memory, both servers are new builds, Windows sees
all the memory, boot.ini as /3gb /pae switches and SQL's
are awe configured.
Instance 1 running as default virtual server on node 1
Max Server memory 7406
SQL runs using 7.23GB of memory.
Instance 2 running as named instance of virtual server on
node 2
Max Server memory 7406
SQL runs using only 3.73 GB as max
How can I get node 2 to also use 7.23GB.
But I'm getting excessive paging so would use more memory
if it could get it.
First, you must use Performance monitor to get true memory settings. Task
manager will not report correct settings. If you are paging, you need to
back down on the max memory setting. I would recommend 6.5 GB for an 8GB
system as a starting point. You can adjust upwards until the system begins
to page then back down slightly. The server needs some memory for the OS
and some for non-sql apps (like the login console). Also, you really should
run these systems at about 3.5GB each so in case one fails over, you can
hold both on the same server. Right now, you may not be able to
successfully fail over since neither system has enough free memory to start
the other instance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ray" <anonymous@.discussions.microsoft.com> wrote in message
news:27e1401c46401$a942d1d0$a501280a@.phx.gbl...
> I'm currently running 2 SQl Instance as an active/active
> cluster.
> Both servers are identical running windows 2000 Advance
> server.
> SQL Server Enterprise 2000 with settings exactly the same
> on both servers,
> 8GB of memory, both servers are new builds, Windows sees
> all the memory, boot.ini as /3gb /pae switches and SQL's
> are awe configured.
> Instance 1 running as default virtual server on node 1
> Max Server memory 7406
> SQL runs using 7.23GB of memory.
> Instance 2 running as named instance of virtual server on
> node 2
> Max Server memory 7406
> SQL runs using only 3.73 GB as max
> How can I get node 2 to also use 7.23GB.
> But I'm getting excessive paging so would use more memory
> if it could get it.
>
|||I agree with Geoff. The main reason that you are using SQL Server Failover Clustering is that High Availability is your highest priority. So, you do not want to compromise that. In this scenario, it is recommended
that each instance of SQL Server on either node use upto 3.5GB of memory.
Here is an example from " Microsoft SQL Server 2000 High Availability (MS Press) ISBN 0-7356-1920-4 " that will make this easier to understand.
Consider this example: you have a two-node cluster with three SQL Server instances. Instance 1, which currently resides on Node 1, has 7 GB of memory configured using AWE. Node 2 houses Instance 2, which
has 5 GB of memory allocated with AWE, and one instance that is not using any advanced options and is currently using 1.5 GB of memory. Each node individually has a total of 8 GB of physical memory. A
problem occurs on Node 1, causing a failover. The instance tries to restart on Node 2, but it cannot. You now have a failed set of SQL Server resources that cannot come online, causing an availability problem.
Why? Well, to use AWE, you need to guarantee that the memory you told SQL Server to use will be there. A failover is basically a stop and start on another server. In this case, you were already using 6.5 of the
available 8 GB of memory. 6.5 + 7 does not equal 8, and it does not matter how big your page file is. Your instance will not grab the memory for AWE. It might, however, start up, but it will only grab the amount of
memory that it can up to 2 GB . Now you are risking memory starvation of the operating system, and this can affect all instances.
So how do you prevent this? By planning, these are the types of scenarios you need to play out in your head when proposing the number of instances on a cluster. Your management might see a two-node cluster
and say, "Hey, why is this second server doing nothing? Get something on there!", leaving you in the state of the previous example. The way you can balance memory in this case would be to give two
instances that need a fixed amount of memory 3 GB each and let the other one be dynamic (or set it to 1 GB or 1.5 GB to allow room for the operating system).If you cannot live with this, you will need another cluster
or set of servers to handle this workload. The recommendation was basically to halve the memory,which might lead some to believe that you are wasting resources, but again, is performance or availability your
goal? By definition, if you are reading this book and implementing things like a cluster, you are probably saying that availability is your highest priority. If you never have to failover and you left the instances at 7
GB, 5 GB, and dynamic, things would work great. But once a failover happened, all bets would be off.
Additional Information
=======================
-- In your case, you do not need to use /3GB. AWE and /PAE should be sufficient.
-- When starting with both the /PAE and the /3GB switches, the system may not start
http://support.microsoft.com/?kbid=817566
HOW TO: Configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/?kbid=274750
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Microsoft Webcasts
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
http://support.microsoft.com/?kbid=243218
Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?kbid=260758
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
cluster.
Both servers are identical running windows 2000 Advance
server.
SQL Server Enterprise 2000 with settings exactly the same
on both servers,
8GB of memory, both servers are new builds, Windows sees
all the memory, boot.ini as /3gb /pae switches and SQL's
are awe configured.
Instance 1 running as default virtual server on node 1
Max Server memory 7406
SQL runs using 7.23GB of memory.
Instance 2 running as named instance of virtual server on
node 2
Max Server memory 7406
SQL runs using only 3.73 GB as max
How can I get node 2 to also use 7.23GB.
But I'm getting excessive paging so would use more memory
if it could get it.
First, you must use Performance monitor to get true memory settings. Task
manager will not report correct settings. If you are paging, you need to
back down on the max memory setting. I would recommend 6.5 GB for an 8GB
system as a starting point. You can adjust upwards until the system begins
to page then back down slightly. The server needs some memory for the OS
and some for non-sql apps (like the login console). Also, you really should
run these systems at about 3.5GB each so in case one fails over, you can
hold both on the same server. Right now, you may not be able to
successfully fail over since neither system has enough free memory to start
the other instance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ray" <anonymous@.discussions.microsoft.com> wrote in message
news:27e1401c46401$a942d1d0$a501280a@.phx.gbl...
> I'm currently running 2 SQl Instance as an active/active
> cluster.
> Both servers are identical running windows 2000 Advance
> server.
> SQL Server Enterprise 2000 with settings exactly the same
> on both servers,
> 8GB of memory, both servers are new builds, Windows sees
> all the memory, boot.ini as /3gb /pae switches and SQL's
> are awe configured.
> Instance 1 running as default virtual server on node 1
> Max Server memory 7406
> SQL runs using 7.23GB of memory.
> Instance 2 running as named instance of virtual server on
> node 2
> Max Server memory 7406
> SQL runs using only 3.73 GB as max
> How can I get node 2 to also use 7.23GB.
> But I'm getting excessive paging so would use more memory
> if it could get it.
>
|||I agree with Geoff. The main reason that you are using SQL Server Failover Clustering is that High Availability is your highest priority. So, you do not want to compromise that. In this scenario, it is recommended
that each instance of SQL Server on either node use upto 3.5GB of memory.
Here is an example from " Microsoft SQL Server 2000 High Availability (MS Press) ISBN 0-7356-1920-4 " that will make this easier to understand.
Consider this example: you have a two-node cluster with three SQL Server instances. Instance 1, which currently resides on Node 1, has 7 GB of memory configured using AWE. Node 2 houses Instance 2, which
has 5 GB of memory allocated with AWE, and one instance that is not using any advanced options and is currently using 1.5 GB of memory. Each node individually has a total of 8 GB of physical memory. A
problem occurs on Node 1, causing a failover. The instance tries to restart on Node 2, but it cannot. You now have a failed set of SQL Server resources that cannot come online, causing an availability problem.
Why? Well, to use AWE, you need to guarantee that the memory you told SQL Server to use will be there. A failover is basically a stop and start on another server. In this case, you were already using 6.5 of the
available 8 GB of memory. 6.5 + 7 does not equal 8, and it does not matter how big your page file is. Your instance will not grab the memory for AWE. It might, however, start up, but it will only grab the amount of
memory that it can up to 2 GB . Now you are risking memory starvation of the operating system, and this can affect all instances.
So how do you prevent this? By planning, these are the types of scenarios you need to play out in your head when proposing the number of instances on a cluster. Your management might see a two-node cluster
and say, "Hey, why is this second server doing nothing? Get something on there!", leaving you in the state of the previous example. The way you can balance memory in this case would be to give two
instances that need a fixed amount of memory 3 GB each and let the other one be dynamic (or set it to 1 GB or 1.5 GB to allow room for the operating system).If you cannot live with this, you will need another cluster
or set of servers to handle this workload. The recommendation was basically to halve the memory,which might lead some to believe that you are wasting resources, but again, is performance or availability your
goal? By definition, if you are reading this book and implementing things like a cluster, you are probably saying that availability is your highest priority. If you never have to failover and you left the instances at 7
GB, 5 GB, and dynamic, things would work great. But once a failover happened, all bets would be off.
Additional Information
=======================
-- In your case, you do not need to use /3GB. AWE and /PAE should be sufficient.
-- When starting with both the /PAE and the /3GB switches, the system may not start
http://support.microsoft.com/?kbid=817566
HOW TO: Configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/?kbid=274750
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Microsoft Webcasts
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
http://support.microsoft.com/?kbid=243218
Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?kbid=260758
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
Cluster Log error message
Hello to all,
I'm investigating an application outage issue on a 2-node W2K Adv Server
cluster. A Generic Application is running on the cluster in a remote site,
and connects to a UNIX-based Oracle db at my site. There are intermittent
MRxSMB 3019 Event IDs which I'm not too worried about. I just used Q138365
to adjust the autodisconnect value to -1.
But I'm finding this error message in the Cluster log:
Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS PTR
record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status 9005
I can't find anything documented about this error, so I can't tell if this
is something to be concerned about. Is it nothing, a cluster service
problem, DNS registraion problem?
Any thoughts would be greatly appreciated.
Thanks in advance.
Hey I had this error as well when I was setting up my cluster
To fix it:
o Right-click the network connection for your heartbeat adapter, and then
click Properties.
o Click Internet Protocol (TCP/IP), and then click Properties
o On the DNS tab, verify that no values are defined. Make sure that the
Register this connection's address in DNS is cleared.
Hope this helps!!
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:932C28D9-F8C2-4F83-BE57-AA149AF27065@.microsoft.com...
> Hello to all,
> I'm investigating an application outage issue on a 2-node W2K Adv Server
> cluster. A Generic Application is running on the cluster in a remote
site,
> and connects to a UNIX-based Oracle db at my site. There are intermittent
> MRxSMB 3019 Event IDs which I'm not too worried about. I just used
Q138365
> to adjust the autodisconnect value to -1.
> But I'm finding this error message in the Cluster log:
> Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS
PTR
> record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status
9005
> I can't find anything documented about this error, so I can't tell if this
> is something to be concerned about. Is it nothing, a cluster service
> problem, DNS registraion problem?
> Any thoughts would be greatly appreciated.
> Thanks in advance.
sqlsql
I'm investigating an application outage issue on a 2-node W2K Adv Server
cluster. A Generic Application is running on the cluster in a remote site,
and connects to a UNIX-based Oracle db at my site. There are intermittent
MRxSMB 3019 Event IDs which I'm not too worried about. I just used Q138365
to adjust the autodisconnect value to -1.
But I'm finding this error message in the Cluster log:
Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS PTR
record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status 9005
I can't find anything documented about this error, so I can't tell if this
is something to be concerned about. Is it nothing, a cluster service
problem, DNS registraion problem?
Any thoughts would be greatly appreciated.
Thanks in advance.
Hey I had this error as well when I was setting up my cluster
To fix it:
o Right-click the network connection for your heartbeat adapter, and then
click Properties.
o Click Internet Protocol (TCP/IP), and then click Properties
o On the DNS tab, verify that no values are defined. Make sure that the
Register this connection's address in DNS is cleared.
Hope this helps!!
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:932C28D9-F8C2-4F83-BE57-AA149AF27065@.microsoft.com...
> Hello to all,
> I'm investigating an application outage issue on a 2-node W2K Adv Server
> cluster. A Generic Application is running on the cluster in a remote
site,
> and connects to a UNIX-based Oracle db at my site. There are intermittent
> MRxSMB 3019 Event IDs which I'm not too worried about. I just used
Q138365
> to adjust the autodisconnect value to -1.
> But I'm finding this error message in the Cluster log:
> Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS
PTR
> record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status
9005
> I can't find anything documented about this error, so I can't tell if this
> is something to be concerned about. Is it nothing, a cluster service
> problem, DNS registraion problem?
> Any thoughts would be greatly appreciated.
> Thanks in advance.
sqlsql
Cluster install fails
I'm running into issues installing SQL 2005 Enterprise on a Win2003 server. They seem to be related to missing rights. I've done a lot of research and have come up empty. Does anyone know why I'm getting these log entries? Thanks for any help.
Running: OpenPipeAction at: 2006/0/31 11:35:35
Complete: OpenPipeAction at: 2006/0/31 11:35:35, returned false
Error: Action "OpenPipeAction" failed during execution.
Error: 0x80070005 TaskScheduler::SetTargetComputer for \\SERVER
Complete: RunRemoteSetupAction at: 2006/0/31 11:35:35, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Error: 80070005 Access is denied.
Skipped: InstallASAction.11
Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received: 1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.
Source File Name: remotemessagelib\overlappedpipelistener.cpp
Compiler Timestamp: Fri Jul 29 01:13:51 2005
Function Name: sqls::OverlappedPipeListener::writePipe
Source Line Number: 294
Notification failed to send.
I am having the same issue, can you post which Registry Hive areas where affected by your Domain Policy? I wanted to limit the amount of access that I grant to allow the installation to complete.
Thanks!
NED
|||I don't know how helpful this will be, but this was the list that didn't have default values.
machine\software
machine\software\classes
machine\software\classes\.hlp
machine\software\classes\helpfile
machine\software\microsoft\command processor
machine\software\microsoft\cryptography
machine\software\microsoft\driver signing
machine\software\microsoft\enterprisecertificates
machine\software\microsoft\netdde
machine\software\microsoft\non-driver signing
machine\software\microsoft\ole
machine\software\microsoft\protected storage system provider
machine\software\microsoft\rpc
machine\software\microsoft\secure
machine\software\microsoft\systemcertificates
machine\software\microsoft\windows nt\currentversion
machine\software\microsoft\windows nt\currentversion\accessibility
machine\software\microsoft\windows nt\currentversion\aedebug
machine\software\microsoft\windows nt\currentversion\asrcommands
machine\software\microsoft\windows nt\currentversion\classes
machine\software\microsoft\windows nt\currentversion\drivers32
machine\software\microsoft\windows nt\currentversion\efs
machine\software\microsoft\windows nt\currentversion\font drivers
machine\software\microsoft\windows nt\currentversion\fontmapper
machine\software\microsoft\windows nt\currentversion\image file execution options
machine\software\microsoft\windows nt\currentversion\inifilemapping
machine\software\microsoft\windows nt\currentversion\perflib
machine\software\microsoft\windows nt\currentversion\perflib\009
machine\software\microsoft\windows nt\currentversion\ports
machine\software\microsoft\windows nt\currentversion\profilelist
machine\software\microsoft\windows nt\currentversion\secedit
machine\software\microsoft\windows nt\currentversion\setup\recoveryconsole
machine\software\microsoft\windows nt\currentversion\svchost
machine\software\microsoft\windows nt\currentversion\time zones
machine\software\microsoft\windows nt\currentversion\windows
machine\software\microsoft\windows nt\currentversion\winlogon
machine\software\microsoft\windows\currentversion
machine\software\microsoft\windows\currentversion\explorer\user shell folders
machine\software\microsoft\windows\currentversion\group policy
machine\software\microsoft\windows\currentversion\installer
machine\software\microsoft\windows\currentversion\policies
machine\software\microsoft\windows\currentversion\runonce
machine\software\microsoft\windows\currentversion\runonceex
machine\software\policies
machine\system
machine\system\clone
machine\system\controlset001
machine\system\controlset002
machine\system\controlset003
machine\system\controlset004
machine\system\controlset005
machine\system\controlset006
machine\system\controlset007
machine\system\controlset008
machine\system\controlset009
machine\system\controlset010
machine\system\currentcontrolset\control\class
machine\system\currentcontrolset\control\computername
machine\system\currentcontrolset\control\contentindex
machine\system\currentcontrolset\control\keyboard layout
machine\system\currentcontrolset\control\keyboard layouts
machine\system\currentcontrolset\control\print\printers
machine\system\currentcontrolset\control\productoptions
machine\system\currentcontrolset\control\securepipeservers\winreg
machine\system\currentcontrolset\control\session manager\executive
machine\system\currentcontrolset\control\timezoneinformation
machine\system\currentcontrolset\control\wmi\security
machine\system\currentcontrolset\enum
machine\system\currentcontrolset\hardware profiles
machine\system\currentcontrolset\services\eventlog
machine\system\currentcontrolset\services\tcpip
users\.default
users\.default\software\microsoft\netdde
users\.default\software\microsoft\protected storage system provider
Are you use any antivirus software. I found blocking actions in the logs of my McAfee VirusScan Enterprise.
Unfortunately I still have a same problem after uninstalling of the antivirus sw.
Cluster install fails
I'm running into issues installing SQL 2005 Enterprise on a Win2003 server. They seem to be related to missing rights. I've done a lot of research and have come up empty. Does anyone know why I'm getting these log entries? Thanks for any help.
Running: OpenPipeAction at: 2006/0/31 11:35:35
Complete: OpenPipeAction at: 2006/0/31 11:35:35, returned false
Error: Action "OpenPipeAction" failed during execution.
Error: 0x80070005 TaskScheduler::SetTargetComputer for \\SERVER
Complete: RunRemoteSetupAction at: 2006/0/31 11:35:35, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Error: 80070005 Access is denied.
Skipped: InstallASAction.11
Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received: 1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.
Source File Name: remotemessagelib\overlappedpipelistener.cpp
Compiler Timestamp: Fri Jul 29 01:13:51 2005
Function Name: sqls::OverlappedPipeListener::writePipe
Source Line Number: 294
Notification failed to send.
I am having the same issue, can you post which Registry Hive areas where affected by your Domain Policy? I wanted to limit the amount of access that I grant to allow the installation to complete.
Thanks!
NED
|||I don't know how helpful this will be, but this was the list that didn't have default values.
machine\software
machine\software\classes
machine\software\classes\.hlp
machine\software\classes\helpfile
machine\software\microsoft\command processor
machine\software\microsoft\cryptography
machine\software\microsoft\driver signing
machine\software\microsoft\enterprisecertificates
machine\software\microsoft\netdde
machine\software\microsoft\non-driver signing
machine\software\microsoft\ole
machine\software\microsoft\protected storage system provider
machine\software\microsoft\rpc
machine\software\microsoft\secure
machine\software\microsoft\systemcertificates
machine\software\microsoft\windows nt\currentversion
machine\software\microsoft\windows nt\currentversion\accessibility
machine\software\microsoft\windows nt\currentversion\aedebug
machine\software\microsoft\windows nt\currentversion\asrcommands
machine\software\microsoft\windows nt\currentversion\classes
machine\software\microsoft\windows nt\currentversion\drivers32
machine\software\microsoft\windows nt\currentversion\efs
machine\software\microsoft\windows nt\currentversion\font drivers
machine\software\microsoft\windows nt\currentversion\fontmapper
machine\software\microsoft\windows nt\currentversion\image file execution options
machine\software\microsoft\windows nt\currentversion\inifilemapping
machine\software\microsoft\windows nt\currentversion\perflib
machine\software\microsoft\windows nt\currentversion\perflib\009
machine\software\microsoft\windows nt\currentversion\ports
machine\software\microsoft\windows nt\currentversion\profilelist
machine\software\microsoft\windows nt\currentversion\secedit
machine\software\microsoft\windows nt\currentversion\setup\recoveryconsole
machine\software\microsoft\windows nt\currentversion\svchost
machine\software\microsoft\windows nt\currentversion\time zones
machine\software\microsoft\windows nt\currentversion\windows
machine\software\microsoft\windows nt\currentversion\winlogon
machine\software\microsoft\windows\currentversion
machine\software\microsoft\windows\currentversion\explorer\user shell folders
machine\software\microsoft\windows\currentversion\group policy
machine\software\microsoft\windows\currentversion\installer
machine\software\microsoft\windows\currentversion\policies
machine\software\microsoft\windows\currentversion\runonce
machine\software\microsoft\windows\currentversion\runonceex
machine\software\policies
machine\system
machine\system\clone
machine\system\controlset001
machine\system\controlset002
machine\system\controlset003
machine\system\controlset004
machine\system\controlset005
machine\system\controlset006
machine\system\controlset007
machine\system\controlset008
machine\system\controlset009
machine\system\controlset010
machine\system\currentcontrolset\control\class
machine\system\currentcontrolset\control\computername
machine\system\currentcontrolset\control\contentindex
machine\system\currentcontrolset\control\keyboard layout
machine\system\currentcontrolset\control\keyboard layouts
machine\system\currentcontrolset\control\print\printers
machine\system\currentcontrolset\control\productoptions
machine\system\currentcontrolset\control\securepipeservers\winreg
machine\system\currentcontrolset\control\session manager\executive
machine\system\currentcontrolset\control\timezoneinformation
machine\system\currentcontrolset\control\wmi\security
machine\system\currentcontrolset\enum
machine\system\currentcontrolset\hardware profiles
machine\system\currentcontrolset\services\eventlog
machine\system\currentcontrolset\services\tcpip
users\.default
users\.default\software\microsoft\netdde
users\.default\software\microsoft\protected storage system provider
Are you use any antivirus software. I found blocking actions in the logs of my McAfee VirusScan Enterprise.
Unfortunately I still have a same problem after uninstalling of the antivirus sw.
Cluster install fails
I'm running into issues installing SQL 2005 Enterprise on a Win2003 server. They seem to be related to missing rights. I've done a lot of research and have come up empty. Does anyone know why I'm getting these log entries? Thanks for any help.
Running: OpenPipeAction at: 2006/0/31 11:35:35
Complete: OpenPipeAction at: 2006/0/31 11:35:35, returned false
Error: Action "OpenPipeAction" failed during execution.
Error: 0x80070005 TaskScheduler::SetTargetComputer for \\SERVER
Complete: RunRemoteSetupAction at: 2006/0/31 11:35:35, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Error: 80070005 Access is denied.
Skipped: InstallASAction.11
Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received: 1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.
Source File Name: remotemessagelib\overlappedpipelistener.cpp
Compiler Timestamp: Fri Jul 29 01:13:51 2005
Function Name: sqls::OverlappedPipeListener::writePipe
Source Line Number: 294
Notification failed to send.
I am having the same issue, can you post which Registry Hive areas where affected by your Domain Policy? I wanted to limit the amount of access that I grant to allow the installation to complete.
Thanks!
NED
|||I don't know how helpful this will be, but this was the list that didn't have default values.
machine\software
machine\software\classes
machine\software\classes\.hlp
machine\software\classes\helpfile
machine\software\microsoft\command processor
machine\software\microsoft\cryptography
machine\software\microsoft\driver signing
machine\software\microsoft\enterprisecertificates
machine\software\microsoft\netdde
machine\software\microsoft\non-driver signing
machine\software\microsoft\ole
machine\software\microsoft\protected storage system provider
machine\software\microsoft\rpc
machine\software\microsoft\secure
machine\software\microsoft\systemcertificates
machine\software\microsoft\windows nt\currentversion
machine\software\microsoft\windows nt\currentversion\accessibility
machine\software\microsoft\windows nt\currentversion\aedebug
machine\software\microsoft\windows nt\currentversion\asrcommands
machine\software\microsoft\windows nt\currentversion\classes
machine\software\microsoft\windows nt\currentversion\drivers32
machine\software\microsoft\windows nt\currentversion\efs
machine\software\microsoft\windows nt\currentversion\font drivers
machine\software\microsoft\windows nt\currentversion\fontmapper
machine\software\microsoft\windows nt\currentversion\image file execution options
machine\software\microsoft\windows nt\currentversion\inifilemapping
machine\software\microsoft\windows nt\currentversion\perflib
machine\software\microsoft\windows nt\currentversion\perflib\009
machine\software\microsoft\windows nt\currentversion\ports
machine\software\microsoft\windows nt\currentversion\profilelist
machine\software\microsoft\windows nt\currentversion\secedit
machine\software\microsoft\windows nt\currentversion\setup\recoveryconsole
machine\software\microsoft\windows nt\currentversion\svchost
machine\software\microsoft\windows nt\currentversion\time zones
machine\software\microsoft\windows nt\currentversion\windows
machine\software\microsoft\windows nt\currentversion\winlogon
machine\software\microsoft\windows\currentversion
machine\software\microsoft\windows\currentversion\explorer\user shell folders
machine\software\microsoft\windows\currentversion\group policy
machine\software\microsoft\windows\currentversion\installer
machine\software\microsoft\windows\currentversion\policies
machine\software\microsoft\windows\currentversion\runonce
machine\software\microsoft\windows\currentversion\runonceex
machine\software\policies
machine\system
machine\system\clone
machine\system\controlset001
machine\system\controlset002
machine\system\controlset003
machine\system\controlset004
machine\system\controlset005
machine\system\controlset006
machine\system\controlset007
machine\system\controlset008
machine\system\controlset009
machine\system\controlset010
machine\system\currentcontrolset\control\class
machine\system\currentcontrolset\control\computername
machine\system\currentcontrolset\control\contentindex
machine\system\currentcontrolset\control\keyboard layout
machine\system\currentcontrolset\control\keyboard layouts
machine\system\currentcontrolset\control\print\printers
machine\system\currentcontrolset\control\productoptions
machine\system\currentcontrolset\control\securepipeservers\winreg
machine\system\currentcontrolset\control\session manager\executive
machine\system\currentcontrolset\control\timezoneinformation
machine\system\currentcontrolset\control\wmi\security
machine\system\currentcontrolset\enum
machine\system\currentcontrolset\hardware profiles
machine\system\currentcontrolset\services\eventlog
machine\system\currentcontrolset\services\tcpip
users\.default
users\.default\software\microsoft\netdde
users\.default\software\microsoft\protected storage system provider
Are you use any antivirus software. I found blocking actions in the logs of my McAfee VirusScan Enterprise.
Unfortunately I still have a same problem after uninstalling of the antivirus sw.
Thursday, March 22, 2012
Cluster install fails
I'm running into issues installing SQL 2005 Enterprise on a Win2003 server. They seem to be related to missing rights. I've done a lot of research and have come up empty. Does anyone know why I'm getting these log entries? Thanks for any help.
Running: OpenPipeAction at: 2006/0/31 11:35:35
Complete: OpenPipeAction at: 2006/0/31 11:35:35, returned false
Error: Action "OpenPipeAction" failed during execution.
Error: 0x80070005 TaskScheduler::SetTargetComputer for \\SERVER
Complete: RunRemoteSetupAction at: 2006/0/31 11:35:35, returned false
Error: Action "RunRemoteSetupAction" failed during execution. Error information reported during run:
Attempting to determine log files for remote install.
Connection to remote computer's scheduler service.
Error: 80070005 Access is denied.
Skipped: InstallASAction.11
Waiting for actions from remote setup(s)
Breaking wait state and aborting package due to cancel code received: 1602
Remote setup(s) are ready
Notify package action is determined: 1602
Error Code: 0x800700e9 (233)
Windows Error Text: No process is on the other end of the pipe.
Source File Name: remotemessagelib\overlappedpipelistener.cpp
Compiler Timestamp: Fri Jul 29 01:13:51 2005
Function Name: sqls::OverlappedPipeListener::writePipe
Source Line Number: 294
Notification failed to send.
I am having the same issue, can you post which Registry Hive areas where affected by your Domain Policy? I wanted to limit the amount of access that I grant to allow the installation to complete.
Thanks!
NED
|||I don't know how helpful this will be, but this was the list that didn't have default values.
machine\software
machine\software\classes
machine\software\classes\.hlp
machine\software\classes\helpfile
machine\software\microsoft\command processor
machine\software\microsoft\cryptography
machine\software\microsoft\driver signing
machine\software\microsoft\enterprisecertificates
machine\software\microsoft\netdde
machine\software\microsoft\non-driver signing
machine\software\microsoft\ole
machine\software\microsoft\protected storage system provider
machine\software\microsoft\rpc
machine\software\microsoft\secure
machine\software\microsoft\systemcertificates
machine\software\microsoft\windows nt\currentversion
machine\software\microsoft\windows nt\currentversion\accessibility
machine\software\microsoft\windows nt\currentversion\aedebug
machine\software\microsoft\windows nt\currentversion\asrcommands
machine\software\microsoft\windows nt\currentversion\classes
machine\software\microsoft\windows nt\currentversion\drivers32
machine\software\microsoft\windows nt\currentversion\efs
machine\software\microsoft\windows nt\currentversion\font drivers
machine\software\microsoft\windows nt\currentversion\fontmapper
machine\software\microsoft\windows nt\currentversion\image file execution options
machine\software\microsoft\windows nt\currentversion\inifilemapping
machine\software\microsoft\windows nt\currentversion\perflib
machine\software\microsoft\windows nt\currentversion\perflib\009
machine\software\microsoft\windows nt\currentversion\ports
machine\software\microsoft\windows nt\currentversion\profilelist
machine\software\microsoft\windows nt\currentversion\secedit
machine\software\microsoft\windows nt\currentversion\setup\recoveryconsole
machine\software\microsoft\windows nt\currentversion\svchost
machine\software\microsoft\windows nt\currentversion\time zones
machine\software\microsoft\windows nt\currentversion\windows
machine\software\microsoft\windows nt\currentversion\winlogon
machine\software\microsoft\windows\currentversion
machine\software\microsoft\windows\currentversion\explorer\user shell folders
machine\software\microsoft\windows\currentversion\group policy
machine\software\microsoft\windows\currentversion\installer
machine\software\microsoft\windows\currentversion\policies
machine\software\microsoft\windows\currentversion\runonce
machine\software\microsoft\windows\currentversion\runonceex
machine\software\policies
machine\system
machine\system\clone
machine\system\controlset001
machine\system\controlset002
machine\system\controlset003
machine\system\controlset004
machine\system\controlset005
machine\system\controlset006
machine\system\controlset007
machine\system\controlset008
machine\system\controlset009
machine\system\controlset010
machine\system\currentcontrolset\control\class
machine\system\currentcontrolset\control\computername
machine\system\currentcontrolset\control\contentindex
machine\system\currentcontrolset\control\keyboard layout
machine\system\currentcontrolset\control\keyboard layouts
machine\system\currentcontrolset\control\print\printers
machine\system\currentcontrolset\control\productoptions
machine\system\currentcontrolset\control\securepipeservers\winreg
machine\system\currentcontrolset\control\session manager\executive
machine\system\currentcontrolset\control\timezoneinformation
machine\system\currentcontrolset\control\wmi\security
machine\system\currentcontrolset\enum
machine\system\currentcontrolset\hardware profiles
machine\system\currentcontrolset\services\eventlog
machine\system\currentcontrolset\services\tcpip
users\.default
users\.default\software\microsoft\netdde
users\.default\software\microsoft\protected storage system provider
Are you use any antivirus software. I found blocking actions in the logs of my McAfee VirusScan Enterprise.
Unfortunately I still have a same problem after uninstalling of the antivirus sw.
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?
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?
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
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 Group and SQL Question
We have a cluster that has been running for a couple of years. It has MSDE
running on one node of the cluster. This cluster only has one group on it
and want to install SQL 2005. Would it install into this group? Is it
possible to have more than one group on one device? I was able to get DTC
working so I was thinking I could install SQL.
thanks
Yes, you can install SQL Server 2005 into that cluster. However, the SQL
Server requires its own disk resources that are not shared with anything
else. You can't configure a disk device into multiple groups.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Roger" <roger@.nospam.com> wrote in message
news:%23T7iPR$JGHA.668@.TK2MSFTNGP11.phx.gbl...
> We have a cluster that has been running for a couple of years. It has
> MSDE running on one node of the cluster. This cluster only has one group
> on it and want to install SQL 2005. Would it install into this group?
> Is it possible to have more than one group on one device? I was able to
> get DTC working so I was thinking I could install SQL.
> thanks
>
>
|||Would I have to rebuild the cluster to get another disk device if everything
is allocated now? It was not known at the time when the cluster was built
that we were going to install SQL.
thanks
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:ecxJngBKGHA.3728@.tk2msftngp13.phx.gbl...
> Yes, you can install SQL Server 2005 into that cluster. However, the SQL
> Server requires its own disk resources that are not shared with anything
> else. You can't configure a disk device into multiple groups.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Roger" <roger@.nospam.com> wrote in message
> news:%23T7iPR$JGHA.668@.TK2MSFTNGP11.phx.gbl...
>
|||No, the cluster doesn't need to be rebuilt. You just have to add the disk
resource into the cluster before you can use it with the failover cluster
instance.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Roger" <roger@.nospam.com> wrote in message
news:%236s%23kwLKGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Would I have to rebuild the cluster to get another disk device if
> everything is allocated now? It was not known at the time when the
> cluster was built that we were going to install SQL.
> thanks
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:ecxJngBKGHA.3728@.tk2msftngp13.phx.gbl...
>
|||Where would I get the disk resource from? I know if I add more disks I can
use that. I have 60 gig free on what I currenly have and I was thinking to
delete and redo the partitions to get what I would need for SQL.
thanks again for your help.
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:uA7unAvKGHA.3912@.TK2MSFTNGP10.phx.gbl...
> No, the cluster doesn't need to be rebuilt. You just have to add the disk
> resource into the cluster before you can use it with the failover cluster
> instance.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Roger" <roger@.nospam.com> wrote in message
> news:%236s%23kwLKGHA.1288@.TK2MSFTNGP09.phx.gbl...
>
running on one node of the cluster. This cluster only has one group on it
and want to install SQL 2005. Would it install into this group? Is it
possible to have more than one group on one device? I was able to get DTC
working so I was thinking I could install SQL.
thanks
Yes, you can install SQL Server 2005 into that cluster. However, the SQL
Server requires its own disk resources that are not shared with anything
else. You can't configure a disk device into multiple groups.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Roger" <roger@.nospam.com> wrote in message
news:%23T7iPR$JGHA.668@.TK2MSFTNGP11.phx.gbl...
> We have a cluster that has been running for a couple of years. It has
> MSDE running on one node of the cluster. This cluster only has one group
> on it and want to install SQL 2005. Would it install into this group?
> Is it possible to have more than one group on one device? I was able to
> get DTC working so I was thinking I could install SQL.
> thanks
>
>
|||Would I have to rebuild the cluster to get another disk device if everything
is allocated now? It was not known at the time when the cluster was built
that we were going to install SQL.
thanks
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:ecxJngBKGHA.3728@.tk2msftngp13.phx.gbl...
> Yes, you can install SQL Server 2005 into that cluster. However, the SQL
> Server requires its own disk resources that are not shared with anything
> else. You can't configure a disk device into multiple groups.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Roger" <roger@.nospam.com> wrote in message
> news:%23T7iPR$JGHA.668@.TK2MSFTNGP11.phx.gbl...
>
|||No, the cluster doesn't need to be rebuilt. You just have to add the disk
resource into the cluster before you can use it with the failover cluster
instance.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Roger" <roger@.nospam.com> wrote in message
news:%236s%23kwLKGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Would I have to rebuild the cluster to get another disk device if
> everything is allocated now? It was not known at the time when the
> cluster was built that we were going to install SQL.
> thanks
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:ecxJngBKGHA.3728@.tk2msftngp13.phx.gbl...
>
|||Where would I get the disk resource from? I know if I add more disks I can
use that. I have 60 gig free on what I currenly have and I was thinking to
delete and redo the partitions to get what I would need for SQL.
thanks again for your help.
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:uA7unAvKGHA.3912@.TK2MSFTNGP10.phx.gbl...
> No, the cluster doesn't need to be rebuilt. You just have to add the disk
> resource into the cluster before you can use it with the failover cluster
> instance.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Roger" <roger@.nospam.com> wrote in message
> news:%236s%23kwLKGHA.1288@.TK2MSFTNGP09.phx.gbl...
>
Subscribe to:
Posts (Atom)