• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 624
  • Last Modified:

Strage Event Log Entries - Event ID 17055

Hi Everyone.

I'm hoping someone can help! Each morning starting at approx 7am and finishing at approx 8.30am one of my SQL Servers logs Event 17055 with the event description below:

3455 :
Analysis of database 'LFMCustDB' (7) is 100% complete (approximately 0 more seconds)

Does anyone know what this event could be? There are no maintenance plans on the server and no jobs to check DB integrity etc.

Cheers,
Danny
 
0
LFMSupport
Asked:
LFMSupport
  • 3
  • 3
1 Solution
 
mcmonapCommented:
Hi LFMSupport,

I think you get these when the databases open or start, if you have the auto_close option enabled, or possibly with the auto-shrink option enabled.  I would switch both of these off if they are on.  These options tend to be set in MSDE or databases that came from an MSDE install originally

You can check with this:
sp_dboption 'LFMCustDB'
0
 
LFMSupportAuthor Commented:
mcmonap,

Thanks for the response.

Is it always best to have these options turned off? The Db in question has Auto Close turned on but a number of other databases do also and they don't generate this event?

Danny
0
 
mcmonapCommented:
Hi LFMSupport,

I would _always_ have these turned off on production servers, see below for details, while closeing the database may save server resources if there are constant connection then more resources are required to open and close the database than to just have it running.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_6ohf.asp
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
LFMSupportAuthor Commented:
Thanks for the link.

Do you mind if I leave the question open until I have chance to check the server change?

Danny
0
 
mcmonapCommented:
No problem at all! - they're your points to award as you see fit!
0
 
LFMSupportAuthor Commented:
Hi mcmonap,

I've just gotten in to work and checked the event logs on the SQL Server. The log entries are gone, so it looks as though turning off auto-close did the trick.

Thanks very much for the help!

Danny
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now