sql server connect: Slow connection to local instance -- sql server connect

Re: Slow connection to local instance

Sue Hoegemeier
4/25/2006 9:09:49 PM

Make sure the database aren't set to autoclose. That would
be my first guess on why it's slow. You can look in the SQL
Server error log and see if the databases are opening and
closing. You can change the database option using Alter
Database -
ALTER DATABASE YourDB
SET AUTO_CLOSE OFF

-Sue

On Tue, 25 Apr 2006 20:20:30 GMT, "Ben Rum"
[quoted text, click to view]

Re: Slow connection to local instance

Ben Rum
4/26/2006 12:00:00 AM

I did have all non system db's set to AUTO_CLOSE, however after changing
them all to AUTO_CLOSE OFF, there was no improvement..?

[quoted text, click to view]

Re: Slow connection to local instance

Sue Hoegemeier
4/26/2006 3:47:01 PM

Also make sure autoshrink is off. Both auto close and
autoshrink are turned on by default with the Personal
Edition and MSDE. That's generally what causes the issues
you have described.
You may also want to make sure ODBC tracing isn't on to make
sure that's not playing a part. You can check the ODBC
Administrator applet and check the Tracing tab to see if
it's on.
And then last but not least....make sure you are running the
latest service pack. There have been performance fixes with
Enterprise Manager in different service packs. Service packs
are cumulative so applying the latest will provide all the
fixes.

-Sue

On Wed, 26 Apr 2006 11:15:07 GMT, "Ben Rum"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.