July 9, 2013 at 12:16 pm
Hi all,
I am getting error when trying to backup with compression:
'There is insufficient system memory in resource pool 'internal' to run this query. (Microsoft SQL Server, Error: 701)'.
No problem if i backup without compression.
SQL server 2008 R2 SP1,STD Edition,
total_physical_memory_kb 4193368
available_physical_memory_kb 1042748
total_page_file_kb 8619144
available_page_file_kb 4950160
system_memory_state_desc Available physical memory is high
Any ideas ?
Thank you
July 9, 2013 at 1:12 pm
You are using Standard Edition. I don't believe that Compression is available in Standard Edition.
-- Itzik Ben-Gan 2001
July 9, 2013 at 1:20 pm
It is available.Trust me
July 9, 2013 at 1:34 pm
I think it's what it says. You're memory starved for this operation. Is it a busy instance?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 9, 2013 at 1:35 pm
Barcelona10 (7/9/2013)
It is available.Trust me
Compression is available, my bad. I did not see that you were on 2008 R2.
-- Itzik Ben-Gan 2001
July 9, 2013 at 2:52 pm
No,it is not busy instance.It started few days .We are backing up prd database (full) twice a day and trn log backup every 2 min.I change server database settings to 'Compress backup' on.Even small trn log backups gives this error .So switched back to 'Compress backup' to unchecked(or off).
July 9, 2013 at 3:02 pm
Also these messages were logged in the error log:
"AppDomain 171508 (mssqlsystemresource.sys[runtime].181191) is marked for unload due to memory pressure."
July 9, 2013 at 3:06 pm
I suspect you have memory issues.
Check free memory in Task manager, make sure that it isn't too low. In line with that, here's a related thread: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/b43c3631-b28f-4564-a802-7b737966b457/there-is-insufficient-system-memory-in-resource-pool-internal-to-run-this-query
DBCC MEMORYSTATUS will help you debug, and I'd look for anything consuming lots of memory. Note that your SQL memory setting is the buffer pool. There are other memory grants that SQL needs. Debugging this can be complicated, and you would do well to engage someone as a consultant. It might be as simple as adding memory, or reconfiguring. It might mean more complex changes like changing code.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 9, 2013 at 3:17 pm
Thank you Steve.I'll go through your suggestions and i'll post the results. Meanwhile i talked to management and asked them to move prd database to 64 bit box ,so we can add more ram.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply