SQL Server Performance Forum – Threads Archive
some performance issueI was testing my test server for finding some performance issue.I opend the EM ..clicked the treeview of the db and closed the EM.I have done this 100 times.Now I observed that the treeview is opening very slowly.What is the possible cause of this error and how should I fix this
Check available diskspace on drive that holds the logs.
How did you measure that EM tree view for database has turned slow.. Another :
Check for opened connection/ running process
Were you opening EM from server itself or from client side? [there could be network issue/ latency] Just to verify I did the same steps.. and EM did not turn slow in my case.
Deepak Kumar –An eye for an eye and everyone shall be blind