SQL Server Performance Forum – Threads Archive
Starting up database
Please forgive me for my ignorance, but I am a beginner with sql.Why would a database start up every 20secs? Sample message on log states:
2004-05-11 11:08:51.65 spid52 Starting up database ‘awxlog32’
2004-05-11 11:08:51.53 spid52 Starting up database ‘awxlog32’
2004-05-11 11:08:51.40 spid52 Starting up database ‘awxlog32’
2004-05-11 11:08:51.28 spid52 Starting up database ‘awxlog32’
2004-05-11 14:49:58.65 spid52 Starting up database ‘awxlog32’ this continues on and on
any suggestions? Thank you,
bugster
Could it be the database Option ‘autoclose’ is set? –Frank
http://www.insidesql.de
Check whether AUTO_CLOSE is enabled on the database awxlog32.
And also look for any other messages on the SQL error log. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
satya, <br /><br />25 seconds !!!!<br /><br />You’re getting older <br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’
‘ />]<br /><br />–Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
yes you were correct with the auto close option, I will deselect the option and see what happens on this server. I have another somewhat mirrored (using two clients sending identical info to both, its a long story on why the customer wanted it this way)
The primary server has it selected also, but I will try on the secondary. thanks
and I am sure there will be more questions to come…. I believe I have picked the right forum
Its not advisable to enable AUTO CLOSE for a production database, as it slowdown the performance and resource on SQL is stressed.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />][<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br /><br />Sometimes…..its good to give a chance to the Kid[<img src=’/community/emoticons/emotion-4.gif’ alt=’
‘ />][8D]<br />Just kidding…<br />It could be due to extra line in my reply.[<img src=’/community/emoticons/emotion-5.gif’ alt=’
‘ />]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />satya, <br /><br />25 seconds !!!!<br /><br />You’re getting older <br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />]<br /><br />–Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /><br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS†with no rights for the sake of knowledge sharing.</font id="size1"></font id="teal"></center>
that would explain some of the reason the primary server is slow.
http://www.microsoft.com/sql/techinfo/tips/administration/autoclose.asp -FYI Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Bugster, You have chosen good forum. I’ve tried some other forums but this one is more helpful for me. No one hesitates to help and moderators are knowledgeable. It’s been helpful to me to learn more and more. Farhad R
[email protected]
]]>