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