Sunday, March 15, 2015

sql server 2005 701 insufficient memory error

We receive 701 insufficient memory error every 2-3 days. Memory clerk report gives no clue. I've found the problem was related to Database Mail. Open your management studio and check for Database mail logs. If there's any problem with the configuration of one of the mail definitions like a changed SMTP ip etc, these errors are causing a memory leak. Fix the configuration and problem is solved.