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

• samalex

  SSCertifiable

  Points: 5429

  More actions

  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.

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  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

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  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]