Databases
StackOverflow2013
Postsdbo
POPerformance problems with SQL Server Management Studio
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPerformance problems with SQL Server Management Studio
    primarykey
    data
    text
    <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>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDylan Corriveau
    1. USProfessional Sounding Name
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPerformance problems with SQL Server Management Studio
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPerformance problems with SQL Server Management Studio
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI have SQL 2008 running on a box with about a 5th of that power and it's able to do those workitems just fine. Have you considered performing a repair on the tools?
      singulars
      1. POPerformance problems with SQL Server Management Studio
      1. USWilliam Holroyd
    2. COYes, I've ran it on other machines with better performance and less specs too, that's why I be its a WOW64 problem. Are you running 64 bit? Downloading the huge fresh install from MSDN to perform a repair right now.
      singulars
      1. POPerformance problems with SQL Server Management Studio
      1. USProfessional Sounding Name
    3. COYeah, I'm running 64bit on both my dev box (vista ultimate) and server (server 2k8) without any issues. Is the database on the same box as the studio?
      singulars
      1. POPerformance problems with SQL Server Management Studio
      1. USWilliam Holroyd
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload