Database keeps getting analysed.

Question

Database keeps getting analysed.

Quinn-793124

SSCrazy

Points: 2785
More actions
October 16, 2009 at 7:50 am

#212126

I noticed in the error log that one of the DB's keeps getting analyzed over and over. It doesn't find any errors but keeps happening again and again. It keeps running checkdb.
What would cause this to happen?
Thanks
Quinn

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Silverfox SSC-Insane Points: 23150 More actions · Answer 1

over what time period and how many times. just out of curiosity do you have auto close enabled on this database

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Quinn-793124 SSCrazy Points: 2785 More actions · Answer 2

Auto close is set to true. It varies from a couple minutes to over a half hour.

Thanks

Quinn

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

The auto-close is the cause. Why is it enabled?

When autoclose is true, SQL will shut the database down as soon as the last user disconnects. Next time someone wants the DB, SQL reopens it and does restart-recovery. That's what you're seeing in the logs, the analysis phase of the restart-recovery.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Quinn-793124 SSCrazy Points: 2785 More actions · Answer 4

I am not sure why auto close is set to true. The DB was a restore trial from a sql server express database. Must have gotten set to that on the restore. I will set it to false and see what happens.

Thanks much.

Quinn

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Auto close is true by default on SQL express.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Quinn-793124 SSCrazy Points: 2785 More actions · Answer 6

Gail

No more error messages.

That is interesting about auto close being set to true in express. I will have to keep that in the back of my cranium.

Thanks

Quinn