Activity Monitor 8115 error if an entry in the memory_usage column in sys.dm_exec_sessions exceeds 262143 - by KevinNicholas

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 770744 Comments
Status Closed Workarounds
Type Bug Repros 2
Opened 11/11/2012 6:06:26 PM
Access Restriction Public


If an entry in the memory_usage column of sys.dm_exec_sessions exceeds 262143, Activity Monitor produces a 8115 error when you expand Processes.

The problem is caused by the following code of the Processes section in Activity Monitor (captured by profiler): 

[Memory Use (KB)] = s.memory_usage * 8192 / 1024
Sign in to post a comment.
Posted by CJMorgan-ZAG on 1/30/2014 at 2:02 PM
So since SQL 2008 R2 Service Pack 3 doesn't and will not exist what do we do? I'm running SQL 2008 R2 on Server 2012 and get this error more times than not (mostly when the CPU gets any sort of load on it). I'd like to know what my options are other than upgrade to SQL 2012 which I can't due because of vendor restrictions.
Posted by Microsoft on 12/28/2012 at 10:29 AM

I just wanted to update you that the issue was fixed and the fix will be available in next major release and we will port the fix to SQL 2008 R2 SP3 as well.

Thank you
Alex Grach [MSFT]
Posted by Microsoft on 11/14/2012 at 1:11 PM
Thank you for reporting this issue - we are investigating and will update you when we have more information.