Prev: Execute job from osql
Next: Database Queries with database views, that base on many databa
From: bob123 on 12 Jun 2010 09:41
Hi,

I use SS 2005
on W2003 EE 6GB with /PAE /3GB

I set:
max mem 2147483647 MB
awe is checked
SS is using only 100MB about

from task manager : 5 GB is used
the sum of all wotking set for all process is about 500MB
any clue ?

Thanks in advance


From: Erland Sommarskog on 12 Jun 2010 16:58
bob123 (bob123(a)gmail.com) writes:
> I use SS 2005
> on W2003 EE 6GB with /PAE /3GB
>
> I set:
> max mem 2147483647 MB
> awe is checked
> SS is using only 100MB about
>
> from task manager : 5 GB is used
> the sum of all wotking set for all process is about 500MB
> any clue ?

You are fine. When you use AWE with SQL Server 32-bit, the "extra"
memory allocated through AWE does not display in the process list
in Task Manager.

But if Page File Usage is 5GB, SQL Server is really using the memory -
unless you can see that some other process have all that memory.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: bob123 on 13 Jun 2010 05:06
Erland,
you are right
from perfmon I see 2.9GB
as Virtual size

"Erland Sommarskog" <esquel(a)sommarskog.se> a �crit dans le message de news:
Xns9D95E9A31B7CAYazorman(a)127.0.0.1...
> bob123 (bob123(a)gmail.com) writes:
>> I use SS 2005
>> on W2003 EE 6GB with /PAE /3GB
>>
>> I set:
>> max mem 2147483647 MB
>> awe is checked
>> SS is using only 100MB about
>>
>> from task manager : 5 GB is used
>> the sum of all wotking set for all process is about 500MB
>> any clue ?
>
> You are fine. When you use AWE with SQL Server 32-bit, the "extra"
> memory allocated through AWE does not display in the process list
> in Task Manager.
>
> But if Page File Usage is 5GB, SQL Server is really using the memory -
> unless you can see that some other process have all that memory.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>


From: DBATAG on 13 Jun 2010 13:57
IF AWE is enabled, you can not see memory utilization in Task Manager.
For more information about SQL Server Memory Management, visit this
link

http://sqlservertrainings.com/?p=71

Thanks
DBATAG
www.sqlServer-Training.com
Email : info(a)sqlServer-Training.com
 | 
Pages: 1
Prev: Execute job from osql
Next: Database Queries with database views, that base on many databa