Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm running in a similar environment and not having that problem. </p> <p>As with any performance problem, you'll have to analyze it a bit - just saying "it takes 10 minutes" give no information on the reason it takes so long, so no information you can use to solve the problem.</p> <hr> <p>Here are some tools to play around with. I'd have mentioned them originally, but "play around" is all I've learned to do with them. I'd recommend you try learning a little about them, which I have not done. <a href="http://technet.microsoft.com" rel="nofollow noreferrer">http://technet.microsoft.com</a> is a good source on performance issues.</p> <p>Start with Task Manager, believe it or not. It's been enhanced in Vista and Server 2008, and now has a better Performance tab, and a Services tab. Be sure to click "Show processes from all users", or you'll miss nasty things done by services.</p> <p>The bottom of the Performance tab has a "Resource Monitor" button. Click it, watch it, learn what it can do for you.</p> <p>The Resource Monitor is actually part of a larger "Reliability and Performance Monitor" tool in Administrative Tools. Try it. It even includes the new version of perfmon, which will be more useful when you have a better idea what counters to look at.</p> <p>I will also suggest the Process Explorer and Process Monitor tools from Sysinternals. See <a href="http://technet.microsoft.com/en-us/sysinternals/default.aspx" rel="nofollow noreferrer">http://technet.microsoft.com/en-us/sysinternals/default.aspx</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POPerformance problems with SQL Server Management Studio
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJohn Saunders
    1. USJohn Saunders
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI don't know what other information I can provide. It is the only thing running, all other open panes in the studio are closed, open a diagram with only 10 tables on it, perform a few edits, and the screen dims after the next click and does't respond for minutes. No other connetions to the db
      singulars
      1. PO
      1. USProfessional Sounding Name
    2. COI am running the management studio and the database locally.
      singulars
      1. PO
      1. USProfessional Sounding Name
    3. COI would love to know what other information I should be asking myself to obtain to solve this problem, which is the reason I posted this question.
      singulars
      1. PO
      1. USProfessional Sounding Name
 

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