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