nested "starting up database" in the logs

Hi,
I noticed from the logs that, my sql server 2000 Standard Ed (runs on a
windows 2k Advanced server) is starting up the databases over and over again
every second. This goes on and on without stopping, like a nested loop. each
time it does it with a different SPID. When I check the SPID, actually it is
doing something else (such as running a query on a database). It is
currently running SP3, and I am going to install SP4. I wonder if this
resolves it. But before applying the SP4, I wonder if has anyone else run
the similar or same problem. If, so is there a solution for that, or would
SP4 takes care of this problem ?
Thanks for any feedback.
Regards.
Murtix.
Turn off the autoclose database option for your databases...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Murtix Van Basten" <nospam@.nospam.org> wrote in message news:428e0b2c$1_1@.alt.athenanews.com...
> Hi,
> I noticed from the logs that, my sql server 2000 Standard Ed (runs on a
> windows 2k Advanced server) is starting up the databases over and over again
> every second. This goes on and on without stopping, like a nested loop. each
> time it does it with a different SPID. When I check the SPID, actually it is
> doing something else (such as running a query on a database). It is
> currently running SP3, and I am going to install SP4. I wonder if this
> resolves it. But before applying the SP4, I wonder if has anyone else run
> the similar or same problem. If, so is there a solution for that, or would
> SP4 takes care of this problem ?
> Thanks for any feedback.
> Regards.
> Murtix.
>
|||How do I turn off the autoclose for databases ? (I dont remember I turned it
on).
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IwjkyVXFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Turn off the autoclose database option for your databases...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Murtix Van Basten" <nospam@.nospam.org> wrote in message
> news:428e0b2c$1_1@.alt.athenanews.com...
>
>
|||I found how to turn it off. I will post the result here. It may fix another
issue I am having, too.
"Murtix Van Basten" <nospam@.nospam.org> wrote in message
news:428e3b35$1_1@.alt.athenanews.com...
> How do I turn off the autoclose for databases ? (I dont remember I turned
> it on).
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:%23IwjkyVXFHA.3320@.TK2MSFTNGP12.phx.gbl...
>