Very Computer

Hey All,

    Not sure why this is happening, some days it's not a problem, but lately
more often than not it takes well over one minute once I click on a SQL
Server's "Databases" node in EM for the listing to appear in the EM window.
I'm not having any other problems with connection speed through my
applications nor through Query Analyzer.  Can anyone give me a hint or two
as to how to troubleshoot this?

    Thanks!

    Cheers,

    -m

Hi,

A long shot...

Perhaps the "autoclose" dboption is set to True or checked ON for the
databases.  You can
turn it off either by  EXEC sp_dboption '<databasename>','autoclose',False
or taking the option off in enterprise manager|database| properties|options
tab.

Also...check if the odbc tracing is accidentally turned on .Start
ODBCAD32.EXE, check the tracing tab.

Dinesh
--
--
SQL Server FAQ at
www.tkdinesh.com

Quote:> Hey All,

>     Not sure why this is happening, some days it's not a problem, but
lately
> more often than not it takes well over one minute once I click on a SQL
> Server's "Databases" node in EM for the listing to appear in the EM
window.
> I'm not having any other problems with connection speed through my
> applications nor through Query Analyzer.  Can anyone give me a hint or two
> as to how to troubleshoot this?

>     Thanks!

>     Cheers,

>     -m

Laos verify that the client is on SP1 or greater - see
http://support.microsoft.com/support/kb/articles/q282/4/16.asp.

Thanks,

Bill Hollinshead
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no
rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

errr

ALSO verify ... <g>

Thanks,

Bill Hollinshead
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no
rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.