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

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

Non-buffer pool memory in the SQL Server memory space on 64-bit system

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
Is there a way to tell the amount memory not allocated to the buffer pool within the SQL Server memory space on a 64-bit system?
e.g. to the SQL CLR.

Make everything as simple as possible, but not simpler.
-Albert Einstein

View Complete Post

More Related Resource Links

There is insufficient system memory in resource pool 'internal' to run this query.



I have a .NET application executing a stored procedure on a SQL Server 2008 SP1 64 bit instance (version 10.0.2531.0), and getting the following exception:

There is insufficient system memory in resource pool 'internal' to run this query.

Maximum server memory is set to 4096MB. The server has 4GB of physical RAM available, and is running Windows Server 2008 R2 x64.

The SQL Server instance is only consuming approx 1.5GB RAM and there is 15+% physical RAM unused.

The messages in error.log are as follows:

2010-09-25 03:28:38.15 spid51    Failed allocate pages: FAIL_PAGE_ALLOCATION 1
2010-09-25 03:28:38.15 spid51   
Memory Manager                  KB
---------------------------------------- ----------
VM Reserved                 4277792
VM Committed                1532212
Locked Pages Allocated              0
Reserved Memory                1024
Reserved Memory In Use              0
2010-09-25 03:28:38.15 spid51   
Memory node Id = 0                KB
---------------------------------------- ----------
VM Reserved                 4276704
VM Committed                1531184
Locked Pages Allocated              0
MultiPage Allocator              38992
SinglePage Allocator            1371648
2010-09-25 03:28:38.15 spid51   
---------------------------------------- ----------
VM Res

buffer manager free pages decrease though the sql server has a lot memory

we found the backup frequently fails due to insufficient memory, when checked the buffer memory, found it always decreases, can we purge something in buffer to free more pages?

There is insufficient system memory in resource pool 'internal' to run this query.


Somebody know what kind of Error is "There is insufficient system memory in resource pool 'internal' to run this query."


System.out of memory exception in sql server 2005 repoting services



this is ram,

I am new to the reporting services,just one month back i joined in the company.there i got trained in ssrs 2005 .

nd my pblm is i inserted one of the csv file into the sql server 2005,it contains 102866 records,nd then i started generating summarized record through sql server 2005 reporting services.when i started generating the reports with few columns i didnt get any pblm,but when i started including more columns with aggregate functions i am getting the ecxeption called system out of memory exception.and by google search i found some solutions like enabling the AWE,but still i am getting the same exception

my server configuration is

64 bit windows server 2003,






Crystal Report gives System.AccessViolationException: Attempted to read or write protected memory. T


when a crystal report for same id is opened again at same time or refreshed then it gives the

"System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt."

Stack Trace is :-

Stack Trace:

[AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.]
CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetConnectionInfos(ConnectionInfos ConnectionInfos) +0
CrystalDecisions.CrystalReports.Engine.Table.ApplyLogOnInfo(TableLogOnInfo logonInfo) +362
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetTableLogon(Tables tables, String user, String password, String server, String database, Boolean ignoreCase) +258
CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDatabaseLogon(String user, String password, String server, String database, Boolean ignoreCase) +204

Maximum memory for string ? . System.MemoryOutOfException Occurs when reading the Content of the fil



I have a C++ code which reads a file [vtk file - its similar to text file only]. and try to store it in string.

here's the code:

String^ ParallelProjectionRenderer::GetVolumeDataAsString(String^ FileName)

    vtkSmartPointer<vtkDataSetWriter> sWriter = vtkSmartPointer<vtkDataSetWriter>::New();

    String^ FileName = "D:\\Users\\...";

    char * sptName = static_cast<char *>(Marshal::StringToHGlobalAnsi(FileName).ToPointer());







    String^ result= File::ReadAllText(FileName);   [it breaks here with system.memoryoutofexception when the file size is huge]

    return result;


this code executes fine when the file size is less than 8mb.

I wanted to know whats the maximum memory allocated to the string.

As a workaround i skipped reading out in C++ code. and i tried to read the file contents in asp.net C# code and stor

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.

SQL server memory / speed configuration

Let me preface this by saying I'm aware of SQL server memory architecture, i.e it takes as much as it can get it's hand's on ...I've read through all the post's on here and they have been very helpful ... However if someone could take a look at these these configuration values ... I'm trying to get a new server dialed in, I'm still having some user end speed issues, and application hangup's that seem sql related ... I'm by no means a dba so if someone who's knowledgeable could point me in the right direction I would appreciate it ... I feel like something is not configured properly ... The box has Microsoft SQL Server 2008 (RTM) 64-bit on Windows NT 6.0 <X64> Service Pack 2 Dell Power Edge R10 16 Logical CPU, 8 Hyperthread 12gig of memory (Right now SQL has 10/12 gig allocated in the task manager ( I know this is not accurate ) I'm adding another 12 gig tomorrow ... So the machine will be running 24 gig) There's two 9 gig databases running on the machine with several 4-6 million row tables .... Server is SQL Dedicated Configuration Values   Page Life Expectancy 18,038 under moderate load, tho I've seen it as low as 1,200 under heavy load .... Buffer Pool Usage CACHESTORE_SQLCP 2778616 OBJECTSTORE_LOCK_MANAGER 38816 MEMORYCLERK_SOSNODE 20936 CACHESTORE_OBJCP 18992 CACHESTORE_PHDR 16472 USERSTORE_SCHEMAMGR 12184 USERSTORE_DBMETADATA 8264 USE

SQL Server Management Studio - Invalid access to memory location

In SQL Server Management Studio (for SQL Server 2008), when I try to open a new query window, or create a new database, I get a popup error box saying the following: "Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (mscorlib)" This just started happening in the last few days, and I have no idea why.  I even uninstalled SQL Server 2008, and then installed SQL Server 2008 R2, and continued to get the exact same error, in the exact same scenarios. Please let me know if you have seen this before, and what I might try to correct it. Thanks, Robert  

Max Server Memory Alteration..

I am running SQL Server 2005 Enterprise on Win Server 2003 SP1 32 bit with 16 GB RAM. I have both /3BG and /PAE enabled. AWE is enabled for SQL Server. I have set the Max Server Memory to 12 GB. When I check the perfmon counters, The Available MBytes is about 2.3 GB. This means that I am not using this 2.3 GB of my 16 GB memory. What I am thinking is that instead of keeping the /3GB switch, I will remove it and make the Max Server Memory to 13 GB. Will this be euqivalent to my prevoius configuration? Will my SQL Server get the same RAM as before? Anyways, what's the advice to achieve optimum utilization of RAM?

SQL Server not releasing memory back!

Hi Guys,   I have done enough research on this topic and understood that SQL Server loves to cache as much memory as it can get hold of , but did not find a straight forward answer to my problem.   To explain things in detail, We are currently using SQL Server 2005 (64 Bit) on Windows 2003 (64 Bit) with 32 GB of RAM. This morning when I checked, it was showing the memory as 1GB RAM.  As soon as I stopped and restarted SQL Sever, I got back all 31GB of it! This is a live mirrored server, and the data is exposed through a .NET Win Application. Also, this is a dedicated SQL Server.   The min and max memory of the SQL Server is set at 16 and 2147483647 respectively.   My questions: 1. What can be done to make SQL Server release the memory back once the process is complete?   2. If this involves setting a limit to the max memory of the SQL Server, what can it be set to? And does setting the max memory low affect the performance of server?   3. I have other servers that are not dedicated SQL Servers which are showing the same 'memory' related problems, what should be the max memory setting on these ?   Any help in this regard is deeply appreciated.   Little_Birdie.

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

Can anyone explain how SQL Server performance scales with CPUs/Cores, memory, disk drives, etc?

I have experienced the situation where our application running on an expensive system with two 4 core CPUs ran slower than on a cheap machine with one dual core CPU. Both machines had similar memory capacity. In each case, the same query was being run by only one user. It would be nice to find a way to increase performance, but if adding cores doesn't help, what can a poor developer do? Customers get annoyed when they spend a truckload of money on a new server and nothing changes... Another potential problem is when customers have an expensive SAN system Sometimes the performance is much slower then on a system with conventional storage. Can anyone explain the relationship between SQL Server perfomance and hardware ?

COM Server process compiled with /clr option doesn't unload itself from memory when last COM client

I created Visual C++ ATL project in VS2010, exe type, imlemented COM object, then added /clr option to project. Project uses other C# dlls (WCF service). When last COM client disconnects and last COM object instance destroys, WCF service stopped, my COM server process doesn't unload itself from memory. All managed threads in C# dll are background, COM object doesn't create threads. How can I unload server process? Thank you in advance. 

how to allocate memory for a dedicated distributor server

Hi all, What is the larget memory consumer in a dedicated distributor server? sql server or the Agent? do i need to grant the 'lock page in memory' permission to sql server account in distributor server(This is a 64 bit box with 32GB memory)? ?dba????(???),???? stswordman#hotmail.com

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

Server Out Of Memory, There is no memory on the server to run your program. Please contact your admi

Hi, I have some MDB files with 100 MB , While clicking on the file to open, it shows. 'Unexpected error has occured', And While downloading a copy, it shows,'Server Out Of Memory, There is no memory on the server to run your program. Please contact your administrator with this problem' . Please help me to resolve this, Thanks in advance.
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