April 5, 2017 at 3:15 pm
Since migrating to sql 2014 with SP2 we are getting this error (There is insufficient system memory in resource pool 'internal' to run this query) from our asp.net applications when using a linked server connection to DB2. The Test Connection works for the linked server. Sql Server is 64 bit with 12GB RAM and sql max memory is set to 8000MB.
April 5, 2017 at 3:26 pm
8000MB is not a lot of RAM for the SQL server to play with. How complex are these queries? Have you had a look to see if you can improve their performance? Also, have you made any considerations on upgrading the RAM available to the server SQL Server is running on?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 5, 2017 at 6:26 pm
Have you considered a direction connection to the DB2 server instead of using a linked server?
Or importing the data to local from the DB2 server to satisfy the query locally rather than across the linked server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 6, 2017 at 7:17 am
smartin 3811 - Wednesday, April 5, 2017 3:15 PMSince migrating to sql 2014 with SP2 we are getting this error (There is insufficient system memory in resource pool 'internal' to run this query) from our asp.net applications when using a linked server connection to DB2. The Test Connection works for the linked server. Sql Server is 64 bit with 12GB RAM and sql max memory is set to 8000MB.
try increasing the max memory to about 9Gb and monitor
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2017 at 10:24 am
Perry Whittle - Thursday, April 6, 2017 7:17 AMsmartin 3811 - Wednesday, April 5, 2017 3:15 PMSince migrating to sql 2014 with SP2 we are getting this error (There is insufficient system memory in resource pool 'internal' to run this query) from our asp.net applications when using a linked server connection to DB2. The Test Connection works for the linked server. Sql Server is 64 bit with 12GB RAM and sql max memory is set to 8000MB.try increasing the max memory to about 9Gb and monitor
I would expect memory contention with the OS and SQL server at that level. You will likely start seeing low PLE. The query needs tuned.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 7, 2017 at 11:17 am
SQLRNNR - Friday, April 7, 2017 10:24 AMPerry Whittle - Thursday, April 6, 2017 7:17 AMsmartin 3811 - Wednesday, April 5, 2017 3:15 PMSince migrating to sql 2014 with SP2 we are getting this error (There is insufficient system memory in resource pool 'internal' to run this query) from our asp.net applications when using a linked server connection to DB2. The Test Connection works for the linked server. Sql Server is 64 bit with 12GB RAM and sql max memory is set to 8000MB.try increasing the max memory to about 9Gb and monitor
I would expect memory contention with the OS and SQL server at that level. You will likely start seeing low PLE. The query needs tuned.
I just gave it a little emphasis in case the OP misses the observation.
April 7, 2017 at 11:36 am
Luis Cazares - Friday, April 7, 2017 11:17 AMI just gave it a little emphasis in case the OP misses the observation.
LOL
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply