471,050 Members | 1,423 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

Current log - too much entries?

Hello,

does anyone know what could be wrong? There's a lot of similar entries
in the SQL Server current log:

2004-01-21 17:54:00.01 spid57 Starting up database 'DB_NAME'
2004-01-21 17:54:06.45 spid57 Starting up database 'DB_NAME'
2004-01-21 17:54:59.13 spid56 Starting up database 'DB_NAME'

There are hundreds of similar entries that repeat every few seconds. The
database works quite slowly and the users get 'Connection timeout'
message very often.

Thanks for any advice.

...:: fabio

Jul 20 '05 #1
1 4442

"Fabio" <fa***@anti-spam.inet.alpha.pl> wrote in message
news:bu**********@nemesis.news.tpi.pl...
Hello,

does anyone know what could be wrong? There's a lot of similar entries
in the SQL Server current log:

2004-01-21 17:54:00.01 spid57 Starting up database 'DB_NAME'
2004-01-21 17:54:06.45 spid57 Starting up database 'DB_NAME'
2004-01-21 17:54:59.13 spid56 Starting up database 'DB_NAME'

There are hundreds of similar entries that repeat every few seconds. The
database works quite slowly and the users get 'Connection timeout'
message very often.

Thanks for any advice.

..:: fabio


Probably the database is set to autoclose - if there are no active
connections, then it is closed. That means when a connection is made, the
database is opened again, which takes time. You can check like this:

select databasepropertyex('DB_NAME', 'IsAutoClose')

1 means it's on, so you can turn it off like this:

alter database DB_NAME set auto_close off

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Chris Mellon | last post: by
4 posts views Thread by msch-prv | last post: by
2 posts views Thread by Paxton Sanders | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.