hi pf usage

Hi all,
I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB RAM.
I have enabled AWE & PAE. The performance monitor shows a constant usage of
7.55GB of on the pagefile. Is this normal'
TIA!Yo have SP4. Did you apply KB 899761?
http://support.microsoft.com/kb/899761/
FIX: Not all memory is available when AWE is enabled on a computer that is
running a 32-bit version of SQL Server 2000 SP4
Use Performance Monitor to look into
SQLServer:Memory Manager - Total Server Memory (KB)
to verify SQL Server is using all the memory you are giving to it
Ben Nevarez, MCDBA, OCP
Database Administrator
"param@.community.nospam" wrote:
> Hi all,
> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB RAM.
> I have enabled AWE & PAE. The performance monitor shows a constant usage of
> 7.55GB of on the pagefile. Is this normal'
> TIA!
>
>|||Yes, I have SP4 and have applied that hotfix. Perfmon shows 7534008 KB. What
could be up?
Thanks
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:81D4043B-3C8B-466C-A3E0-A5F3826E3F40@.microsoft.com...
> Yo have SP4. Did you apply KB 899761?
> http://support.microsoft.com/kb/899761/
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> Use Performance Monitor to look into
> SQLServer:Memory Manager - Total Server Memory (KB)
> to verify SQL Server is using all the memory you are giving to it
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "param@.community.nospam" wrote:
>> Hi all,
>> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB
>> RAM.
>> I have enabled AWE & PAE. The performance monitor shows a constant usage
>> of
>> 7.55GB of on the pagefile. Is this normal'
>> TIA!
>>|||OK, here is the weird part. I checked my 2nd node of the cluster and its PF
usage is only at about 400MB. What is weird is that I am running an
Active-Active mixed cluster. Server1 is running SQL2000 SP4 and has the
issue with high memory usage. Server2 is running SQL2005 SP1 and seems fine
on memory usage. Both the servers are identical machines.
TIA!
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:81D4043B-3C8B-466C-A3E0-A5F3826E3F40@.microsoft.com...
> Yo have SP4. Did you apply KB 899761?
> http://support.microsoft.com/kb/899761/
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> Use Performance Monitor to look into
> SQLServer:Memory Manager - Total Server Memory (KB)
> to verify SQL Server is using all the memory you are giving to it
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "param@.community.nospam" wrote:
>> Hi all,
>> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB
>> RAM.
>> I have enabled AWE & PAE. The performance monitor shows a constant usage
>> of
>> 7.55GB of on the pagefile. Is this normal'
>> TIA!
>>

HF for SQL2000 on Windows 2003 Cluster

We just build our first 2 nodes cluster on Windows 2003 / SQL2000 SP3a + HF
818.
Does anybody knows if there is any other HF need to be applied on Windows or
SQL running cluster services before we go live?
Thanks
Ayad
That depends on whether you are experiencing any problems that are covered
by a later hotfix. I generally don't apply a hotfix unless I need the
specific functionality it covers. Service Packs are a different issue.
Those go in as soon as they are carefully tested.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:%23MoDxbWsEHA.2800@.tk2msftngp13.phx.gbl...
> We just build our first 2 nodes cluster on Windows 2003 / SQL2000 SP3a +
HF
> 818.
> Does anybody knows if there is any other HF need to be applied on Windows
or
> SQL running cluster services before we go live?
> Thanks
> Ayad
>