locked
Activity Monitor error RRS feed

  • Question

  • Hi,

    I just started activity monitor on sql server 2008 standard edition X64. When I clicked processes, after some delay there is error message:

    The activity monitor is unable to execute queries against server abc. ........ Arithmetic overflow error converting expression to data type int. (Micorsoft SQL Server, Error: 8115).

    "Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64)   Sep 21 2011 22:45:45   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )"

    How to resolve this issue, please help.

    Thanks

    Monday, April 15, 2013 7:36 PM

Answers

  • Please check this link,

    http://connect.microsoft.com/SQLServer/feedback/details/770744/activity-monitor-8115-error-if-an-entry-in-the-memory-usage-column-in-sys-dm-exec-sessions-exceeds-262143


    Thanks & Regards RAJUKIRAN L

    • Proposed as answer by Fanny Liu Tuesday, April 23, 2013 8:43 AM
    • Marked as answer by Olaf HelperMVP Monday, May 20, 2013 1:23 PM
    Monday, April 15, 2013 10:50 PM

All replies

  • This is a symptom of trying to connect to a newer version of SQL Server with an older version of SSMS.  Please update your SSMS and apply the current Service Packs.

    Monday, April 15, 2013 7:57 PM
  • Adding little bit more for Tom Said , you can upgrade your SQL Management studio to SSMS 2008 R2 SP2 which is the latest one so far

    Kindly let me know if any further help is neededa


    Shehap (DB Consultant/DB Architect) Think More deeply of DB Stress Stabilities

    Monday, April 15, 2013 8:09 PM
  • Thanks both of your for replying.

    SQL Server instance shows: 10.0.5500

    SSMS shows: 10.50.2500.0

    I think SSMS is lates then SQL Server instance.

    Monday, April 15, 2013 8:22 PM
  • This problem was fixed in SQL Server 2008 R2 Service Pack 2.  Please install this patch locally and see if it fixes the problem.

    Monday, April 15, 2013 8:45 PM
  • I have upgraded SSMS to SP2. But still the same error.

    Monday, April 15, 2013 10:07 PM
  • Please check this link,

    http://connect.microsoft.com/SQLServer/feedback/details/770744/activity-monitor-8115-error-if-an-entry-in-the-memory-usage-column-in-sys-dm-exec-sessions-exceeds-262143


    Thanks & Regards RAJUKIRAN L

    • Proposed as answer by Fanny Liu Tuesday, April 23, 2013 8:43 AM
    • Marked as answer by Olaf HelperMVP Monday, May 20, 2013 1:23 PM
    Monday, April 15, 2013 10:50 PM
  • HI,

    try to connect from remote system to your local DB engine, if you doesn't get an error message then issues is in your local binaries and need to reinstall the management studio.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers. Thanks!

    Tuesday, April 16, 2013 12:35 AM
  • I am connecting through remote connection. SSMS is installed on my laptop and I am connected to remote server.
    Tuesday, April 16, 2013 4:07 PM