question

merlin avatar image
merlin asked

SQL Job fails randomely at SSIS package execution (process_virtual_memory_low is flagged)

Running SQL Server 2012 (Max Server Memory=26000MB) Running on Windows Server 2012 R2 32G of Memory I have a job that Step1: executes a DB procedure which truncates then populates a table with 160 rows (6 columns). Step2: Executes an SSIS FTP Package which queries the table and puts it into a file and sends it to a secure ftp site. The job runs every 2 minutes. It works well, but every couple of days it permanently quits with this error: *Failed to create AppDomain "SSISDB.dbo[runtime].19". Could not load file or assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008) (Microsoft SQL Server, Error: 6517)* I can continue execute the package outside of sql (in the Virtual Studio program) but I have to restart the SQL service to get it to work again within the job. I began logging memory and didn't find anything unusual except that **process_virtual_memory_low** from table **sys.dm_os_process_memory** changes from 0 to 1 when the job begins failing. (physical_memory_in_use=3166 MB, total_virtual_address_space=4095 MB) I increased the the virtual memory on the operating system but makes no difference. What does **process_virtual_memory_low** suggest? Should I add something to my SSIS package or job to clean or clear up memory? Should I look at or log something besides memory?
ssismemory
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.