Performance - SQLServer:Buffer Manager Free pages

Hi
Envinnment : Windows 2003 SQLServer 2000 sp3 with AWE enabled
While performance monitoring in the low peak time, I saw the SQLServer:
Buffer Manager - Free pages = 1768 and came down till 500 and back to 1398.
I gathered form sysperfinfo the following
Buffer Cache database pages 8360 MB
Free pages 10 MB
Procedure Cache Allocated 1377 MB
Is any thing wrong with Buffer Manger? because of free space came down? Is
there any lower limit for free pages?
Thanks for looking this issue
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1sorry to add total memory . 12GB
Dedicated to SQL = 10.5 GB
kpxus wrote:
>Hi
>Envinnment : Windows 2003 SQLServer 2000 sp3 with AWE enabled
>While performance monitoring in the low peak time, I saw the SQLServer:
>Buffer Manager - Free pages = 1768 and came down till 500 and back to 1398.
>I gathered form sysperfinfo the following
>Buffer Cache database pages 8360 MB
>Free pages 10 MB
>Procedure Cache Allocated 1377 MB
>Is any thing wrong with Buffer Manger? because of free space came down? Is
>there any lower limit for free pages?
>Thanks for looking this issue
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1|||Hi
To use the Buffer Cache Hit Ratio.
I use that along with SQLServer:MemoryManager\Total Server Memory(KB)
and SQLServer:MemoryManager\Target Server Memory(KB). Total and Target
values should be equal.
Target should never be higher than Total. Target is how much SQL
Server would like to use and Total is how much it currently has.
HTH
From
Doller|||Total and target memory are same 10.506 MB
doller wrote:
>Hi
>To use the Buffer Cache Hit Ratio.
>I use that along with SQLServer:MemoryManager\Total Server Memory(KB)
>and SQLServer:MemoryManager\Target Server Memory(KB). Total and Target
>values should be equal.
> Target should never be higher than Total. Target is how much SQL
>Server would like to use and Total is how much it currently has.
>HTH
>From
>Doller
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1