Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using sql server express 2008 r2 SP2 from about 2 years. Now a days when i try to check properties of database using sql server management studio it takes too much time(25 to 30 seconds) to open properties window for any database. But other working such as connection to the server, backup of database are almost same as before.I have not changed any settings or added new large databases recently. So what may be the reason behind this slow behavior? If anyone wants extra information on this problem please let me know.

share|improve this question
have you tried running a trace to see what exactly is taking long? (Filter the trace on you personal login.) – Sebastian Meine Oct 10 '13 at 14:30
Agreed with @SebastianMeine. SSMS is just like any other application, sometimes you need to look at what's happening and taking so long. – Thomas Stringer Oct 10 '13 at 15:12
Do you get the same behavior when using SSMS locally on the server or only from your desktop? – Paul Oct 10 '13 at 15:14
@Paul Yes. from local PC and network PC behavior is same. – IT researcher Oct 11 '13 at 14:04
@SebastianMeine How to run a trace? – IT researcher Oct 11 '13 at 14:05

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.