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 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...
>
>

No comments:

Post a Comment