.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 RAM usage is growing rapidly

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :Sql Server

Our SQL 2005 database server appears to have a memory leak, where RAM usage creeping up quite fast.  How do we determine which database is using the memory or what else is?

Any help much appreciated!


View Complete Post

More Related Resource Links

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

Sharepoint Site Usage not working after virtualizing server



I just virtualized(vmware) both front and backend server for Sharepoint  2007 . The issue I'm having is that my Sharepoint Site Usage pages are no longer showing results. 

I tried giving WSS_ADMIN_WPG ans WSS_WPG Full control of the logs folder but still no luck.C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS

I noticed the following 2 event id errors on my front end server

Source: Office Sharepoint Server

Event ID 7888

runtime exception was detected. Details follow.

Message: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Techinal Details:

System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

at Microsoft.SharePoint.SPGlobal.HandleUnauthorizedAccessException(UnauthorizedAccessException ex)

at Microsoft.SharePoint.Library.SPRequest.CrossListQuery(String bstrUrl, String bstrXmlWebs, String bstrXmlLists, String bstrXmlQuery, ISP2DSafeArrayWriter pCallback, Object& pvarColumns)

at Microsoft.SharePoint.SPWeb.GetSiteData(SPSiteDataQuery query)

at Microsoft.SharePoint.Publishing.CrossListQueryCache.GetSiteData(CachedArea cachedArea, SPWeb web, SPSiteDataQuery query)

For more information, see Help and Support Center at

SQL Server 2008 Memory Usage


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

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.


Governing SSIS resource usage vs Dedicated SSIS server


We utilize SSIS extensively to process data feeds and when those files become large, we find the resources on the SQL are pretty well depleted. That in turns causes the application, whcih is connected to that same SQL Server, to suffer from a performance stand point. We have to act on this as the problem will only get worse over time and are considering creating a separate SQL instance for SSIS packages but are also interested if there is anything that can be done now to govern the amount of resources that any given SSIS package can use, with the understanding that doing so will cause them (the SSIS pkgs) to have a longer execution time.

We are using SQL 2008 Enterprise Edition and have been reviewing the Resource Governor within SQL, but it appears that that tool can not govern SSIS package resources, so the question is can anything perform that task?

Thanks in advance for the feedback.


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

Just introduced to XML usage with SQL Server

Hello All, I am doing some work where an XML file needs to create a form for a GUI, includes menu options within that form, and have a parameters list. From that point there is a stored procedure where the parameters need to match those in the XML file, followed by very much logic in the procedure following. While I understand without knowing all of the details, I am a fresh out of college grad with little SQL experience and would like to excel in the database field, and this seems to be my starting point. It seems like Various types of joins will be used, "Case"'s, conditional statements which I did not know until now was possible in SQL server or any database platform for that matter such as IF, ELSE, END. On top of using this as a starting point, I will be taking an additional 4 classes all database related that should answer many of my questions, however I don't believe they will coincide with everything I need on an as needed basis. So that being said, anyone that could provide some insight into the information I have provided, advice on what I can do to help build on the technoologies mentioned and how they are used with each other, I would appreciate ant help anyone can provide. Thanks in advance.

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 - 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

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





Log file is growing in secondary server (MSSQL 2005 log shipping)



logshiping is configured in our enviroment between SQL2005 SP3 Enterprise edition , we made the online secondary server for testing perpose. now again we have restored the latest full backup (size was 1000gb) into secondary server for maintaining the logshipping with norecovery mode . everything was fine and both databases is also in sync mode. but i have shrink the log file into promary server and database size reduced to 700Gb then automated backup happened and same backup is restored into secondry srever but secondry server log file size is still showing 350GB.

plz help us how to reduce the log flle of secondry srever, current status is

Primary server DB size is 750gb (50gb log)

secondary srever Db size 1050gb (350gb log)


What is the usage of RowGUID under SQL Server 2005?


Hi All

What is the usage of Row Guid under SQL Server 2005? It seems not much information state the main purpose of it?





Usage Report "Server Out of Memory



in one of our SiteCollections we cannot start den Usage Report. It says "Server Out of Memory". We have lot of SiteCollections and it happens only in this one. Fyi: We have 16GB RAM.

Any Ideas? Thanks alot..

call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.
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