?
Solved

Strage Event Log Entries - Event ID 17055

Posted on 2005-05-17
6
Medium Priority
?
622 Views
Last Modified: 2012-06-21
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
Comment
Question by:LFMSupport
  • 3
  • 3
6 Comments
 
LVL 15

Accepted Solution

by:
mcmonap earned 800 total points
ID: 14018245
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
 
LVL 1

Author Comment

by:LFMSupport
ID: 14018408
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
 
LVL 15

Expert Comment

by:mcmonap
ID: 14018483
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:LFMSupport
ID: 14018527
Thanks for the link.

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

Danny
0
 
LVL 15

Expert Comment

by:mcmonap
ID: 14019017
No problem at all! - they're your points to award as you see fit!
0
 
LVL 1

Author Comment

by:LFMSupport
ID: 14024895
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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question