SQL Server Performance

EM is not responding

Discussion in 'General DBA Questions' started by aaronsandy, Jul 29, 2005.

  1. aaronsandy New Member

    Every 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
  2. satya Moderator

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. gkrishn New Member

    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 .

Share This Page