Wednesday, March 21, 2012

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

No comments:

Post a Comment