[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

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

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
tjoseph833
Asked:
tjoseph833
  • 3
  • 2
2 Solutions
 
Anthony PerkinsCommented:
Not sure if you are aware but SQL Server Express will only support 1GB.
0
 
Anthony PerkinsCommented:
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
 
Stef MerlijnDeveloperCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Anthony PerkinsCommented:
Not sure if you noticed but the question has been abandoned for nearly 6 months and the author is MIA.
0
 
Stef MerlijnDeveloperCommented:
Doesn't matter. Anyone who searches for this might find it useful :-)
0
 
tjoseph833Author Commented:
sorry for the late response. the problem wasn't solved.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now