Click to See Complete Forum and Search --> : SQL Server fills event log


hspc
February 5th, 2005, 01:06 AM
Hi
I use SQL Server personal edition SP3
In the Event log..SQL servee adds many events for the all databases like this :
3455 :Analysis of database 'DATABASENAME' (DATABASEID) is 100% complete (approximately 0 more seconds)
an event record is added about 20 times for each database and i realize that the overall performance of the server degrades.

How to prevent SQL Server from making this analysis too frequently ?

Krzemo
February 5th, 2005, 03:03 AM
I think that U enabled "Auto close" option for databases- Thats why there are so many entries....

Best regards,
Krzemo.

hspc
February 5th, 2005, 04:53 AM
Thanks !!
this seems to solve the problem :thumb: