Friday, August 10, 2012

System.OutOfMemoryException in SSMS

It's quite annoying to have a query running for a while just to get this error message: System.OutOfMemoryException. I am still researching this error as while the error message seems to be quite clear, it is misleading. My local machine and the server seems to have plenty of memory so that is the deal? So far I found a few possible workarounds:

  1. Since only a 32-bit SSMS exists run the query on a 32-bit machine. 
  2. Change the query results to text and not grid. When the results are displayed in grid, it uses the .net CLR which is a memory hog. Or so I read.
  3. Of course, the third obvious solution would be closing some other large query windows if open.

No comments:

Post a Comment