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.
|show 1 more comment|