Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Since i upgraded to SQL Server 2012 I've noticed that it almost doesn't consume any memory at all. Before when i used SQL Server 2008 R2 it used at least 2-4 GB of RAM and now it only used like 150 MB or something.

I haven't really noticed any performance problem or something like that and i'm just curious if they changed something and that you can't look at the SQL Server process to see memory usage anymore or something?

I have of course tried to Google it but hasn't found anything useful.

share|improve this question
    
Where exactly are you looking to see memory usage? (If task manager, what is the exact column name?) –  David Schwartz Oct 23 '12 at 8:37
    
Its sqlservr.exe screencast.com/t/UncBHzC30X –  Stuck Oct 24 '12 at 9:09
    
that doesn't show the name of the column that 120,920 KB is in –  BeowulfNode42 Jul 11 '13 at 22:42

1 Answer 1

I assume this is because your running SQL server under an account which locks pages in memory, e.g. system account.

If so then you will see SQL using very little memory in task manager, however using a tool like RAMMAP shows that an amount of memory consumed by AWE (please see below). In SQL 2012 this happens on 64 bit instances.

Running DBCC memorystatus will indeed show that the memory consumed by AWE is being allocated by SQL.

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.