About memory

Hi I have two question:
1. how to know how much memory that sql server is using in the server?
2 in sql server 64 bit, do I need to setup AWE in order to get more memory?
Thanks.One way is to use
SQLServer:Memory Manager
Total Server Memory (KB)
in Windows Performance monitor.
You do not need to set up AWE in 64-bit environments.
Hope this helps,
Ben Nevarez
"Iter" wrote:
> Hi I have two question:
> 1. how to know how much memory that sql server is using in the server?
> 2 in sql server 64 bit, do I need to setup AWE in order to get more memory?
> Thanks.
>|||Using taskman is very easy but also very misleading on x86 systems using
AWE. A relatively easy way is to use DBCC MEMORYSTATUS & multiply the number
of committed buffers by 8192 then dividing by 1048576 to get the buffer
manager's allocation in Mb. Then, assuming the service hasn't been started
with a -g switch (which alters the SQLServr.exe process's "non buffer
managed" memory allocation or "MTL"), just add a few hundred Mb & you should
be close. This technique is a bit rough but works generically for all
versions & editions of SQL Server.
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
Benchmark your query performance
http://www.SQLBenchmarkPro.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:A45E1E8E-8104-446E-B3DF-B05F66D86166@.microsoft.com...
> Hi I have two question:
> 1. how to know how much memory that sql server is using in the server?
> 2 in sql server 64 bit, do I need to setup AWE in order to get more
> memory?
> Thanks.
>