Q
Problem solve Get help with specific problems with your technologies, process and projects.

Loading of schema information slow

The response time when loading schema information on SQL server has suddenly become very slow. For example, expanding the database folder or changing from one database to another takes much longer than usual. But once the schema information is loaded, the response time is normal.
Once Enterprise Manager reads schema information it is cached locally on your machine therefore you get rapid response. As for it taking long to retrieve, that is a function of your network bandwidth and the activity level on the SQL Server.

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close