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

    Hi,

    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


    thanks,

    rajiv
  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

    rajiv

    Rajiv
    SQL-DBA
  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

    Rajiv

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    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

    Simondm,

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

Share This Page