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 ?
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 ?