We have set a memory cap limit of 43GB in SQL server instance, so thereafter it keeps 42 GB near about and keeps near about 1 GB for its processing operations. But then we received near about 500,000 record to process via one of our external application, and then due to lack of memory space our system start to log the
Out of Memory exception (An exception of type 'System.OutOfMemoryException' occurred and was caught).
In this case we restart SQL server instance and it works correctly for some days, but thereafter it reaches to its max memory cap limit the same issue continues and we restart server again and it continues.
Is there any way we can get rid of this.