Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL server error - There is insufficient system memory in resource pool 'internal' to run this query

Posted on 2014-01-09
6
Medium Priority
?
149 Views
Last Modified: 2015-08-29
Hi, am having problems running a SQL query in a .NET application. Getting the above error -
'There is insufficient system memory in resource pool 'internal' to run this query'

My machine has SQL Server Express 2008 R2 with 4GB RAM. Also installed latest service packs (SP2) - http://support.microsoft.com/kb/982854. Then changed the min and max memory for SQL Server. Also increased the virtual memory and ran Windows Update.

The same application and query works on other machines except this. Any idea why??
0
Comment
Question by:tjoseph833
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 236 total points
ID: 39768937
Not sure if you are aware but SQL Server Express will only support 1GB.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39768945
But I would start, by posting the query that is causing you problems and some details about the tables involved (any indexes, row count) and expected output.
0
 

Assisted Solution

by:Delphiwizard
Delphiwizard earned 234 total points
ID: 40169103
You might also want to analyse your query with Activty Monitor in SSMS.
http://msdn.microsoft.com/en-us/library/ms175518.aspx
Have a look in "Recent Expensive Queries"
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40170992
Not sure if you noticed but the question has been abandoned for nearly 6 months and the author is MIA.
0
 

Expert Comment

by:Delphiwizard
ID: 40171356
Doesn't matter. Anyone who searches for this might find it useful :-)
0
 

Author Comment

by:tjoseph833
ID: 40953500
sorry for the late response. the problem wasn't solved.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question