Improve company productivity with a Business Account.Sign Up

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
?
283 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
  • 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:Stef Merlijn
Stef Merlijn 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
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
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:Stef Merlijn
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

607 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