Post reply

SSMS 2012 is using 3+ Gigs of Ram... suggestions?

  • May 23, 2014 at 2:34 pm

    #285860

    Hi all,

    We have a user who's using SSMS 2012 (11.0.2100.60), and it's using 2-3Gigs of RAM or more. Me and our other DBA are running this same version of SSMS, but we've not encountered this. I tried downloading SQL 2012 SP1, but it wouldn't install saying there were no upgradable components.

    Does anyone know why SSMS 2012 could be consuming so many resources? And is there a service pack that can be installed just for SSMS? The only articles I've found on MSDN about this refer to CTP and RC versions, but we're not using this version.

    Thanks for any suggestions.

  • May 23, 2014 at 3:28 pm

    #1716271

    How long before it ramps up to 3gb?

    I have seen SSMS consume GBs of memory before due to returning query results. Is this person running some extremely complicated queries with lots of data?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 23, 2014 at 4:36 pm

    #1716275

    Another thing that will do it is the undo buffer, particularly if they are using formatting tools on very large scripts, but aside from regularly closing and restarting, there is not a lot you can do that I know of.

    There is a command to force garbage collect, but I have never seen it actually reclaim any memory.

    It is Ctrl-Shift-Alt-F12 twice. (Find it in the list of commands under Tools.ForceGC)

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • May 24, 2014 at 7:14 pm

    #1716350

    1) Any add-ins?

    2) How many different databases have you connected to and do any have large numbers of objects? I wonder about Intellisense taking lots of memory.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • May 28, 2014 at 3:03 am

    #1716935

    In my experience I normally find that excessive printing to the messages pane is the cause of excessive memory usage by SSMS.

    Run this and watch SSMS grab all the memory it can and then fall over.

    WHILE 1=1

    PRINT REPLICATE('x', 4000);

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

    • Viewing 5 posts - 1 through 4 (of 4 total)

    You must be logged in to reply to this topic. Login to reply