Configuration set up

Can anyone please let me know what are the different configuration things
that i need to consider when installing multiple instance on the 2nd node
of a cluster. Ex details about how memory allocation, processors etc . This
way it wouldnt impact performance of existing sql running on a
cluster.any help on this will be greatly appreciated.
--
Message posted via http://www.sqlmonster.comJust a few more thigs ot add up. As i saif its an active/passive cluster
set up with currently node 1 online.
System details on Node 1 are
- 8 Processors with 3GHz
- Total Physical Memory = 8,289,320 KB
- Available Physical Memory = 523504 KB
- Total Virtual Memory = 18,483,688 KB
- Available Virtual Memory = 2,888,536 KB
- Page File Space = 10,194,368 KB
System detail on Node 2 are
- Total Physical memory = 8,129,320 KB
- Available Physical memory = 7,626,308 KB
- Total Virtual Memory = 18,484,176 KB
- Available Virtual Memory = 17,292,940 KB
- Page File Space = 10,194,368 KB
My second instance is on Node2 . What should i consider/change so that
there isnt a bad impacted when 2nd instance is up and running and if things
failover from node 1 to Node2.
--
Message posted via http://www.sqlmonster.comsqlsql

Configuration set up

Can anyone please let me know what are the different configuration things
that i need to consider when installing multiple instance on the 2nd node
of a cluster. Ex details about how memory allocation, processors etc . This
way it wouldnt impact performance of existing sql running on a
cluster.any help on this will be greatly appreciated.
Message posted via http://www.sqlmonster.com
Just a few more thigs ot add up. As i saif its an active/passive cluster
set up with currently node 1 online.
System details on Node 1 are
- 8 Processors with 3GHz
- Total Physical Memory = 8,289,320 KB
- Available Physical Memory = 523504 KB
- Total Virtual Memory = 18,483,688 KB
- Available Virtual Memory = 2,888,536 KB
- Page File Space = 10,194,368 KB
System detail on Node 2 are
- Total Physical memory = 8,129,320 KB
- Available Physical memory = 7,626,308 KB
- Total Virtual Memory = 18,484,176 KB
- Available Virtual Memory = 17,292,940 KB
- Page File Space = 10,194,368 KB
My second instance is on Node2 . What should i consider/change so that
there isnt a bad impacted when 2nd instance is up and running and if things
failover from node 1 to Node2.
Message posted via http://www.sqlmonster.com

Configuration set up

Can anyone please let me know what are the different configuration things
that i need to consider when installing multiple instance on the 2nd node
of a cluster. Ex details about how memory allocation, processors etc . This
way it wouldnt impact performance of existing sql running on a
cluster.any help on this will be greatly appreciated.
Message posted via http://www.droptable.comJust a few more thigs ot add up. As i saif its an active/passive cluster
set up with currently node 1 online.
System details on Node 1 are
- 8 Processors with 3GHz
- Total Physical Memory = 8,289,320 KB
- Available Physical Memory = 523504 KB
- Total Virtual Memory = 18,483,688 KB
- Available Virtual Memory = 2,888,536 KB
- Page File Space = 10,194,368 KB
System detail on Node 2 are
- Total Physical memory = 8,129,320 KB
- Available Physical memory = 7,626,308 KB
- Total Virtual Memory = 18,484,176 KB
- Available Virtual Memory = 17,292,940 KB
- Page File Space = 10,194,368 KB
My second instance is on Node2 . What should i consider/change so that
there isnt a bad impacted when 2nd instance is up and running and if things
failover from node 1 to Node2.
Message posted via http://www.droptable.com

Configuration Management

With all the new security patches coming out for windows, how do I test them
for SQL server before installing it in production?
Hi
Install the patches on you test server, and run your applications against
the SQL Server on this test server to see if everything works as expected.
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/
"docsql" <docsql@.noemail.nospam> wrote in message
news:O%23J3%23ifnFHA.3656@.TK2MSFTNGP09.phx.gbl...
> With all the new security patches coming out for windows, how do I test
> them for SQL server before installing it in production?
>
sqlsql

Configuration Management

With all the new security patches coming out for windows, how do I test them
for SQL server before installing it in production?Hi
Install the patches on you test server, and run your applications against
the SQL Server on this test server to see if everything works as expected.
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/
"docsql" <docsql@.noemail.nospam> wrote in message
news:O%23J3%23ifnFHA.3656@.TK2MSFTNGP09.phx.gbl...
> With all the new security patches coming out for windows, how do I test
> them for SQL server before installing it in production?
>

Configuration Management

With all the new security patches coming out for windows, how do I test them
for SQL server before installing it in production?Hi
Install the patches on you test server, and run your applications against
the SQL Server on this test server to see if everything works as expected.
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/
"docsql" <docsql@.noemail.nospam> wrote in message
news:O%23J3%23ifnFHA.3656@.TK2MSFTNGP09.phx.gbl...
> With all the new security patches coming out for windows, how do I test
> them for SQL server before installing it in production?
>