Hi Ross,
I had the same error in Manage Nodes before, but it was more of an SQL connection error than lack of memory as the error log tells you. In my case, it was more of a congestion in SQL transactions to the SQL server, and the performance really depends on the number of devices you are monitoring, number of solarwinds users using the web interface and the polling frequency. Maybe you can try decreasing polling frequency? But I think the best way is to open a support ticket for this.