.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server 2008 Memory Usage

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server

We are using SQL Server 2008 x64 SP1 CU8 EE, and we have 32 GB of RAM on the server. We currently have the instance restricted to 14 GB of RAM, the "Lock Pages in Memory" security setting on the service account, and AWE enabled in SQL Server. This server is part of a 3 node active/active/passive cluster. My question is:


How do I know how much memory sql server is actually using, or if the server is under memory pressure? 

John M. Couch

View Complete Post

More Related Resource Links

SQL Server 2008 - High Memory Usage


Hi ,

  We are facing problem with the high memory usage with SQL Server 2008. 64 bit , standard edition sp2 . 8 GB RAM , 8 processors .

Memory usage keep on growing ..sometimes it will reach to 7.5 GB also .... and its not coming down ..untill we restart the service...

These are the details of DBCC MEMORYSTATUS :: Please suggest how to overcome this problem

Memory Manager                           KB
---------------------------------------- -----------
VM Reserved                              8484792
VM Committed                             4220368
Locked Pages Allocated                   0
Reserved Memory                          1024
Reserved Memory In Use      &n

SQL Server 2008 R2 on Windows Server 2008 R2 Memory Usage issues and not giving memory back


Okay so i have a physical server i am trying to replace with a virtual server. Its doing a large load process every night, about 190GB on one disk.

The VM is:

On vSphere 4.1 ESXi

O/S is Windows Server 2008 R2 Enterprise

SQL version is SQL Server 2008 R2 Enterprise.

4 vCpus

Now 20GB of memory

Disks assigned to this virtual are all seperate LUNs except for the O/S which is on a shared LUN which is not busy. So 1 LUN/Datastore per 'disk drive on this SQL virtual. Data/Log/TempDB/Backup are on their own LUNs.

All the recommended exclusions are in place for McAfee on a SQL Server.

ESXi 4.1 Enterprise host is not overcommitted. Has 4 x 6core 2.6Ghz AMD processors. BL685c G6 and 128GB of memory. Almost nothing else is running at the time i am testing this load and host is not overcommited or stressed or anywhere near it.

SQLServer process shows 127,236K Working Set and 130,040K Peak working set and memory Private working set 88,828k and Commit Size of 302,792k.

It seems when i check the memory usage in task manager it doesn't show much. In Windows 2003 X64 in would show the GB being used, like 8GB right in task manager. But i don't see that in Windows 2008 R2 task manager. I downloaded SysInternals and it shows the memory on the Windows 2008 r2 box as 15Gb of AWE memory. How can this be? The case is th

WmiPrvSE.exe causes a huge memory leak in SQL server 2008 R2, why?

My OS is windows server 2008 r2 data center 64 bit and my SQL server is server 2008 R2. The problem is when I open sql server, the WmiPrvSE.exe process consumes 20 - 60kbs every second. Several hours later, it eats up at least 200mbs memorry and this process seems like it will never stop. Can any experts give me some ideas to fit this mess? PS: My mainboard is Asus striker II formular, cpu is intel quad-core. Also, all my software are updated to latest version.

Not Releasing memory in sql server 2008 R2

HI I have a server with 8 Gb Ram I installed Sql server 2008 R2 Enterprise Edition on 64 bit platform Enterprise edition,in that for Sql server I allocated 6 GB of Ram I enable the AWE oprtion as well but in processing time it taking above 6 Gb ram like 7.gb or more after query completing its not release the memory how can I resolve this issue. Actually when we running quries it taking the memory and memory increasing gradually after executing the query its not releasing the memory per example I set maximum 6 GB per Sql server then I run the query memory will increase gradually like 3.4 gb,3.7 gb, 4.5gb,and so on it will reach 7.56gb then after it steadily over there not come to down I am using X64 bit windows server 2008 sql server 2008 R2. My system configuration is sql server 2008R2(10.0.3798) windows server 2008 X64 Ram is 8GB

Memory consuming very hign after installing the SQL Server 2008 R2 64 bit

Hi all I have a  Server with  SQLServer 2005 64 bit and I installed SQL Server 2008 R2 64bit and I moved the Databases and logins to SQL Server 2008 R2.After that (to night) I ran Integrity check + rebuild index + update statistics jobs. after that I found SQL Server consumed more memory and not released.what was the reason behind and how to clean that memory. Please guide with query or with an idea, your help is greatefull for me.   Thanks in Advance    SNIVAS

SQL Server 2008 R2 on Window Server 2008 Physical Memory keep growing


We are running SQL Server 2008 R2 on on Window Server 2008 (x64).

Once in every 2 weeks we end up restarting the SQL Server, due to  Physical Memory keep growing.

Is there a good way to pinpoint the problem what cause this Physical Memory to grow?

Thank you

Armine Bell

What are the memory limits of SQL Server 2008 Workgroup edition (32 bit/non-R2) running on Windows S


We have a situation where one of our customers is running Windows 2003 Enterprise Edition 32bit with 8 GBs of physical RAM. Upgrading to Windows Server 2008 64bit is not an immediate option (although I wish it were). All the documentation about SQL Server 2008 Workgroup edition indicates that the new version will address 4 GBs of memory however it does not distinguish between 32bit vs 64bit.

Previously we have run SQL Workgroup 2005 under Windows 2003 and have applied the /3gb switch in boot.ini to get SQL to recognize the maximum amount of memory possible. Now that we are using SQL 2008 with the /pae switch, do we need to still specify the /3gb switch or can SQL 2008 32bit actually see more than the 3GBs and address 4? I haven't been able to find any information on this configuration.




SSAS 2008 taking all server memory


We just upgraded to SSAS 2008 64 bit (and windows 2008 R2) a couple of weeks ago and now we have an issue that I can't seem to figure out.  Our cubes have not changed at all.  Previous to the upgrade we were running server 2003 and SSAS 2005 54 bit.

The issue is over the past week the SSAS servers have decided to take up almost all the memory (about 90%) on the server and render itself useless.  It is the SSAS service that is taking up almost all the memory and if I stop other services to free up some it just takes that up too.  So here is a break down of the issue and what I have tried.  The issue seems to be happening faster and faster now so I am at a loss currently.

Setup that has issue:

  • SSAS 2008 SP1 64 bit on SQL 2008 R2
  • Default configs as that worked previously in 2005
  • not structure changes
  • machine has 2 quad core procs and 16 GB mem
  • accessed via web calls and linked server on SQL server on different machine

What I have tried

  • install CU10 (due to other issue)
  • rebuild aggregations
  • reduce memory limits to 40% for low and 50% for max respectively

Results of what I have tried so far: memory still hits the 90% within 24 hours so that tells me the changes have done nothing.  I don't know what to do. <

sql server high memory usage


Hello Guys

just wondering how do you handle similar situation, we had a call from angry client saying they are unable to do anything and things take too long to complete. when i logged in i noticed that sql server taking all memory (6GB) for some reason. interestingly CPU usage is normal.

I know i can run profiler to see what queries are taking such huge memory before it happens but what if it already happened and you want to see whats currently eating all that memory ? thanks for the advise.

sql server is 2008 and our desktop app is C# 2008.


SQL Server 2008 R2 Disk Usage report showing incorrect data file


When I go to ANY database (System, AdventureWorks*, user) in Managemant Studio, I right-click on the db, select Reports, select Standard Reports, and select Disk Usage.  The disk usage report shows the correct db on top, but always only shows AdventureWorks_Data.mdf when I expand Disk Space Used by Data Files section.  This happens to any db I try.  When I look at Database Properties/Files for that database, the logical and physical file names are correct.

Since the correct files appear in Database Properties/Files, I'm hoping it's just a bug in the report.  Same thing happens if I run a Disk Usage by Table report for ANY database,  The tables for AdventureWorks always only appear,

Thanks,  Mike

Usage of SQL Express from Microsoft Windows Server 2008 R2 Enterprise Edition (64-bit) to Windows 7

Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website? Kindly guide me.

Configuring AWE and memory usage in SQL Server 2005

Dear Sirs,
I installed SQL Server 2005 Enterprise Edition (with SP3) on a server running Windows Server 2003 Enterprise Editon SP2 with 8GB RAM and with "Physical Address Extension".
I want the SQL Server 2005 makes use of memory that is in excess of 4 GB and will perform the following steps to accomplish this:

1) I'll add the SQL service account to the
policy "lock his pages in memory"

2) I'll include the /PAE switch in Boot.ini

3) I'll change the "awe enabled" with the following commands:

sp_configure 'show advanced options', 1
sp_configure 'awe enabled', 1

4) I'll change "min server memory" and "max server memory" with the following commands:

sp_configure 'min server memory', 1024
sp_configure 'max server memory', 8192

SQL Server 2008 R2 Express - Protected Memory error


Am trying to install SQL Server 2008 R2 Express Database with Advanced Services 64-bit on Win7 Enterprise N 64-bit standalone.

Had previously installed SQL 2005 Express with tools, but that has been completely uninstalled and computer restarted.

Have Msoft .NET Framework 4 Client Profile plus Msoft SQL Server native Client currently installed.

Chose download from here (http://www.microsoft.com/express/Database/InstallOptions.aspx) and everything seemed to be running smoothly until during New Installation phase of SQL Server Installation Center, setup encountered "Attempted to read or write protected memory...Error code 0x84B10001."

Have been searching for solutions, but most are dated back in 2007-2009, and I'm hoping (!) there are some later solutions available. What are my options?

Thanks in advance!           ~chornung

ASP.NET Server Memory usage



My name is Johnathan and I work as an asp.net web devoloper.

My company is starting to transfer from classic asp to asp.net 4.0 in our websites. During the transition I have encountred a few issues:

  1. It seems that asp.net uses a lot more memory then classic asp on the server that hosts the websites. Is that true, and if so how can I minimize the memory usage?
  2. Does asp.net 4 transitiond out of the beta phase? I have a website that is built in the asp.net 4.0 technology that is running smooth on the localhost, but on the server sometimes it doesn't connect to the database. Does this mean it is the host provider's fault or is it something in the code? (here is the website: http://www.sospets2.co.cc/)

Thanks alot and have a nice day!


SQL Server 2000 is getting very slow, memory usage also very high but restarted db service it comes



I am facing slow down problem in SQL Server 2000. SQL Server is very very slow during that time memory also very high usage but when I restart SQL Service it comes to normal. Please advice, if anyone who has experienced in this type of situation. Appreciate if you help to resolve this problem. Thanks





SQL server 2008 memory management


I want to talk about one of the most discussed SQL issues. Memory memory management.

I am working on a SQL server 2008 R2 with all the combined DBs of 60GB. User activity is not very high. This is sharepoint DB. Most of the time CPU utilization is not very high but memory is consumed around 98%.

Current memory is 12GB. How can I calculate the memory required on this server.

Rama DBA

Server: The operation has been cancelled due to memory pressure. (SSAS 2008)


Hello Friends, I need your help!!!

I have a cube that works good in SQL Server 2005 SP3 Standard Edition on Windows 2003 R2 32 bit, 1 GB RAM but in SQL Server 2008 R2 Standard Edition on Windows 2008 R2 with 6 GB and 64-bit one query doesnt work correctly. when I execute it show me that error Server: The operation has been cancelled due to memory pressure. (SSAS 2008).

I notice that the process "msmdsrv.exe" consumen almost all memory RAM, I dont know what can I do, please if anyone can help me I appreciate a lot.


Sukey Nakasima

Sukey Nakasima
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend