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.
..:: fabioCheck if the database option "Autoclose" is turned on and turn it off.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Fabio" <fabio@.anti-spam.inet.alpha.pl> wrote in message
news:bumc1f$2hu$1@.atlantis.news.tpi.pl...

quote:

---

> 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
>

---

|||Uncheck 'AUTO CLOSE' on the database properties options page. (Right click
database name in Enterprise Mangler, select Properties, click on Options
tab.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Fabio" <fabio@.anti-spam.inet.alpha.pl> wrote in message
news:bumc1f$2hu$1@.atlantis.news.tpi.pl...

quote:

---

> 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
>

---

|||Fabio wrote:
Thanks a lot, Dejan and Geoff.
After turning the 'auto close' option the database works much faster and
the messages about database starting don't appear in the error log.
..:: fabio