We have a package that performs data extraction from multiple external systems. It has been running with no issues for a long time. A few days ago, it failed with the following error:
The system reports 9 percent memory load. There are 1099463696384 bytes of physical memory with 991419998208 bytes free. There are 2147352576 bytes of virtual memory with 174698496 bytes free. The paging file has 1153150787584 bytes with 1033803776000 bytes free.
I have read a lot of suggestions on the internet regarding setting max server memory but as it has been running for all this time with the configuration, I am not sure why that would be a factor now. I did change it to a lower number but set it too low and SQL Server would start up. Had to go thru single user mode to reset it back. The server has 1TB RAM.
I also saw something about setting the buffers but I am unable to find where to set that.
The package runs fine within Visual Studio but fails when run thru SQL Server Agent. Also, although it is a 64bit server, everything has been configured to run as 32bit.
Disclaimer: I am programmer and not a DBA so I am just a novice trying to figure this out cold so all suggestions are welcome but please keep that in mind when submitting your responses. thanks!