SQL Server Performance

'no Items' under DATABASE folder in EM

Discussion in 'General DBA Questions' started by gkrishn, Jun 7, 2005.

  1. gkrishn New Member


    I have a server registered in my EM.when i expand DATANBASE folder, I am not getting the list of databases, it just shows 'no items' .But i can work from other machines. Is there any configuration avaiable in EM for this? let me knw


  2. satya Moderator

  3. gkrishn New Member

    Satya thanks for your reply.

    I checked log and found so many entries like "starting up ProductDB" ...

    I understood one DB has autoclose option set to ON , So i ran following query .
    EXEC sp_MSforeachdb @command1="sp_dboption '?','autoclose',false"
    and set it to OFF for some databases .

    This like was really helpful http://www.mcse.ms/archive93-2004-4-592932.html

    Once again thanks


  4. skchandra New Member

    From the link:

    quote:Autoclose option is not recommended for production systems since it can be
    a significant performance impact.

    Apart from the performance degradation, 'Autoclose'option gives opportunity to other process to access the database files... may results corrupted / suspect database.

    /* SKChandra */
  5. satya Moderator


    I appreciate your feedback in providing the solution, in general if the client tools are mismatched you would get this sort of issues.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. simondm New Member

    It maybe a red herring but I've seen this happen when the tempdb becomes full. If your tempdb is full you will have some severity 17 errors in your logs. If this is the case connect using QA and use ALTER database to either expand an existing file (if you don't use auto grow) or add another data file.

  7. gkrishn New Member


    I believe this issues arise only if we connect from a remote machine using EM .

Share This Page