SQL Server fills event log
-
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 ?
-
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 ?
ok seems that enabling the Auto close option for some databases made this problem.