AWE - SQL Server 2000 - Memory usage

Hi all!
We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
Microsoft gave the advise to enable the "AWE" sql server option and the
"/3GB" windows option.
(http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
But when I go to the task manager I see SQL server is only using about 144
mb ?
And the total system memory usage is 2.6 GB... and i cannot see the process
that is using that amount of memory.....
-How can I see what it using so much memory?
-Is this a normal situation when you enablee /3GB and AWE or do you see
sqlserver.exe consuming more memory in your task manager?
I want to know if there is something wrong with our configuration.
Thanks in advance for your answer!
Best regards
Floris van HaasterTask Manager isn't AWE aware. Use Perf Mon instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
> Hi all!
> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
> Microsoft gave the advise to enable the "AWE" sql server option and the "/3GB" windows option.
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
> But when I go to the task manager I see SQL server is only using about 144 mb ?
> And the total system memory usage is 2.6 GB... and i cannot see the process that is using that
> amount of memory.....
> -How can I see what it using so much memory?
> -Is this a normal situation when you enablee /3GB and AWE or do you see sqlserver.exe consuming
> more memory in your task manager?
> I want to know if there is something wrong with our configuration.
> Thanks in advance for your answer!
> Best regards
> Floris van Haaster
>|||Ok thanks,
But what meter shows the correct value?
When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
(KB)" it's value = 1175344 KB and that's only 1 GB or so...
Or do i have to look at another counter?
Best regards
Floris
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
> Task Manager isn't AWE aware. Use Perf Mon instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>> Hi all!
>> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
>> Microsoft gave the advise to enable the "AWE" sql server option and the
>> "/3GB" windows option.
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
>> But when I go to the task manager I see SQL server is only using about
>> 144 mb ?
>> And the total system memory usage is 2.6 GB... and i cannot see the
>> process that is using that amount of memory.....
>> -How can I see what it using so much memory?
>> -Is this a normal situation when you enablee /3GB and AWE or do you see
>> sqlserver.exe consuming more memory in your task manager?
>> I want to know if there is something wrong with our configuration.
>> Thanks in advance for your answer!
>> Best regards
>> Floris van Haaster
>>
>|||Use "Buffer Manager: Total Pages" or DBCC MEMORYSTATUS command
(http://support.microsoft.com/?id=271624), check Buffer Counts, Committed,
which should be close to what you are consuming through AWE. Assuming AWE is
enabled.
Later versions (service packs) of SQL Server 2000 also have Visible counter
in DBCC MEMORYSTATUS output which will show how much of AWE-allocated memory
is actually mapped into virtual address space of SQL Server.
HTH,
Boris.
Boris Baryshnikov
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
news:435e27bf$0$11063$e4fe514c@.news.xs4all.nl...
> Ok thanks,
> But what meter shows the correct value?
> When i take a look @. "SQLServer:Memory Manager > Maximum Workspace memory
> (KB)" it's value = 1175344 KB and that's only 1 GB or so...
> Or do i have to look at another counter?
> Best regards
> Floris
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schreef
> in bericht news:%230isnEU2FHA.3228@.TK2MSFTNGP15.phx.gbl...
>> Task Manager isn't AWE aware. Use Perf Mon instead.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Floris van Haaster" <floris@.NO-SPAM-datasmit.nl> wrote in message
>> news:435de4b3$0$11072$e4fe514c@.news.xs4all.nl...
>> Hi all!
>> We have a SQL Server 2000 Enterprise machine with 3.75 GB of ram in it.
>> Microsoft gave the advise to enable the "AWE" sql server option and the
>> "/3GB" windows option.
>> (http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech)
>> But when I go to the task manager I see SQL server is only using about
>> 144 mb ?
>> And the total system memory usage is 2.6 GB... and i cannot see the
>> process that is using that amount of memory.....
>> -How can I see what it using so much memory?
>> -Is this a normal situation when you enablee /3GB and AWE or do you see
>> sqlserver.exe consuming more memory in your task manager?
>> I want to know if there is something wrong with our configuration.
>> Thanks in advance for your answer!
>> Best regards
>> Floris van Haaster
>>
>