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

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

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

Client Render broken after upgrade to Win2K3 Enterprise from Standard

First off, any suggestions are welcome here as we're lost.

We have a farm of 2 Win2k3 (standard) servers that had a couple GB of RAM. We then installed 16GB of RAM and upgraded to Win2k3 Enterprise to handle the upgrade.

Prior to the OS upgrade our reports rendered as expected. Post upgrade, they do not.

Some background on how we render...we open a PDF rendering of a report in a popup via JavaScript.

Also, we have 3 environments running the same code base. The only difference between the 3 is that one environment is the one we upgraded to Win2k3 Enterprise.

Again, any suggestions are much appreciated!

Scott

It would probably be important to note that we're using SQL Server 2005 and SQL RS 2005.|||

Of course, I forgot to add what's probably the biggest key. Only clients have this problem. Let me break that down. We have servers behing a crazy amount of firewall protection. The DB server is NOT on the SQL RS server. The Web server is also a farm, only serving this application.

I think this is the key. I can call the popup report (via the Web app) on any Web server on the farm, and it renders. When I call the report from a client outside of the network, the popup opens and the little green graphic comes up with "Report is being generated". This happens for about 20 seconds, then the graphic and text go away, the status bar says "Done", and there is a solid line at the top of the page...but of course no report (the title of the popup is correct by the way).

Thanks for your time!