title: Performance problems with SQL Server Management Studio
body: <p>I'm running Sql Server Management Studio 2008 on a decent machine.  Even if it is the only thing open with no other connections to the database, anything that has to do with the Database Diagram or simple schema changes in a designer take up to 10 minutes to complete and SQL Management Studio is unresponsive during that time.  The <strong>same SQL code takes less than a second</strong>.  This entirely defeats the purpose of the designers and diagramers.</p>
  
  <pre>------------------
  System Information
  ------------------
     Operating System: Windows Vista™ Ultimate (6.0, Build 6001) Service Pack 1 (6001.vistasp1_gdr.080917-1612)
            Processor: Intel(R) Core(TM)2 Quad CPU    Q6700  @ 2.66GHz (4 CPUs), ~2.7GHz
               Memory: 6142MB RAM
  </pre>
  
  <p>Please tell me this isn't a WOW64 problem; if it is, I love MS, but step up your 64-bit support in development tools.</p>
  
  <p>Is there anything I can do to get the performance anywhere near acceptable?</p>
  
  <p>Edit:
  I've got version 10.0.1600.22 of SQL Server Management Studio installed.  Is this not the latest release?  I'm sure I installed it from an MSDN CD and I pretty much rely on Windows Update these days.  Is there any place I can quickly see what the latest release version number is for tools like this?</p>
  
  <p>Edit:
  Every time I go to open a database diagram I get the message "This database does not have one or more of the support objects required to use database diagramming.  Do you wish to create them?"  I say yes every time.  Is this part of the problem?  Also, if I press the copy icon, I get the message "Current thread must be set to single thread apartment (STA) mode before OLE calls can be made."  Database corruption?</p>