SQL Server Performance Forum – Threads Archive
‘no Items’ under DATABASE folder in EM
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 knwthanks, rajiv
Replace the client tools again and try. 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.
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
From the link:
quote:Autoclose option is not recommended for production systems since it can be
a significant performance impact.
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 */
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.
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.
Simondm, I believe this issues arise only if we connect from a remote machine using EM .
]]>