SSMS very slow

• mchambers

  Grasshopper

  Points: 13

  More actions

  October 30, 2007 at 6:43 pm

  #178907

  Hi,

  I've recently installed SSE and SSMS. I've used SS2K for years with Enterprise Manager.

  I'm finding that SSMS is insainly slow! I've read numerous threads about stopping SSMS trying to validate a certificate and you need to deisable this etc. This shouldn't apply to me because I'm online anyway but I've disabled the cert and still no improvement.

  What are the system requirements for SSMS? I'm on a P4 WinXP SP2 with 512Mb RAM.

  Is there anything else I can do to speed it up? It's slow on everything, connecting (all local), opening a table, creating a table, saving anything, changing 1 tiny little cell etc.

  Hope you can help.

  Cheers

  Matthew

• Big Data Man

  SSCrazy Eights

  Points: 8536

  More actions

  November 2, 2007 at 1:31 am

  #747651

  Hi,

  This should help:

  http://blogs.msdn.com/euanga/archive/2006/07/11/662053.aspx

  Thanks,

  Phillip Cox