Re: Sql server slow

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 08/12/04 

Date: Wed, 11 Aug 2004 20:00:31 -0500

My autoclose suggestion might help Miles' EM database enumeration problem
with but your issue is different. Slow connectivity can have many
underlying causes so you need to narrow things down a bit.

Try to connect with OSQL or Query Analyzer directly on the problem server.
If this is slow, concentrate on server resource issues, such as CPU and
memory. If the local connection is fast, then look at possible network
causes like name resolution, utilization, etc. Performance Monitor can help
you monitor CPU, memory and network utilization. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Chris H" <chorton53@comcast.net> wrote in message
news:eGafOT7fEHA.704@TK2MSFTNGP09.phx.gbl...
> Hi Dan,
>
> At least for me, Autoclose is always off for all my databases. When I try
to
> directly connect to the computer with problems using Isql, it connects but
> it takes a little longer than normal.
>
> Can you give me some advice on microsoft tools to use to try to get to the
> root of the problem.
>
> Regards,
> Chris H
>
> "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
> news:eyrbKL1fEHA.400@TK2MSFTNGP10.phx.gbl...
> > Check to ensure the autoclose database property is turned off for your
> > databases:
> >
> >     EXEC sp_dboption 'MyDatabase', 'autoclose', false
> >
> > -- 
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Niles" <Niles@discussions.microsoft.com> wrote in message
> > news:259226E6-D68B-4BE0-9FAE-AF02458494FA@microsoft.com...
> > > I have two sql servers registered in my EM.  When I click to open the
> > > Databases under one of the servers it is extremly slow.  It takes 2
> > minutes
> > > for all to load.  one of the times it even had (recovering) next to a
> few
> > DBs
> > > but closing and reopening solved the problem.  What type of things
would
> > be
> > > affecting the speed at which the DBs would load up.  BTW the other
> server
> > > opens just fine. Any suggestions are appreciated. Thanks
> >
> >
>
>

Relevant Pages

  • Re: Slow initial record write
    ... 'autoclose' as 'off' so I guess this isn't the issue. ... directly to the SQL server and it was as follows: ... > To find out execute the following within Query Analyzer: ... > be due to the database starting up. ...
    (microsoft.public.sqlserver.setup)
  • Re: Slow initial record write
    ... > 'autoclose' as 'off' so I guess this isn't the issue. ... > directly to the SQL server and it was as follows: ... >> To find out execute the following within Query Analyzer: ... >> be due to the database starting up. ...
    (microsoft.public.sqlserver.setup)
  • Re: Enterprise Manager "New Window from Here" Hack or Whatever
    ... AUTOCLOSE is a property of the database in SQL Server. ... > Is this something I can do, or is it a responsibility of the web host? ...
    (microsoft.public.sqlserver.server)
  • Re: Repeated Starting up database messages
    ... Turn off autoclose for the database. ... process got hold of the file while SQL Server didn't have it opened, ... However when I looked at the SQL Server Error Log I found many ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)