SQL Server Performance Forum – Threads Archive
EM is not respondingEvery time I open EM and try to connect,its geting hang.EM is not responding.All other application including QA is opening fine.I checkd the memory and found EM consuming maximum memory and then also not opening.How should I trouble shoot this issue
I believe you’ve asked this question before, anyway try to connect the server from other clien’t machine and if its ok then replace SQL client tools on this box by uninstalling. Also check whether any of the databases has been enabled with AUTO_CLOSE option. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
If its issue due to AUTO_CLOSE property of any database, that will mark in error log sayin "startingup of database Pubs…" (PUBS just for eg: ) . So check your error log for thsi entry .