Return
-
Title
How to reset or clear Error Log - Error Count alarm? -
Description
How to clear the Error Log - Error Count alarm in Spotlight for SQL Server Enterprise?
-
Resolution
Spotlight's Error Log - Error Count alarm scans the current SQL Server error log file. The SQL Server error log file, if not recycled, may contain log entries that are so many days old. So when Spotlight's scheduled error log scan runs, it will still detect those error log entries.
So the workaround would be to run the following against the instances in question:
EXEC master..sp_cycle_errorlog ;
EXEC msdb..sp_cycle_agent_errorlog ;This will force the error logs to cycle. Now, when Spotlight runs its scheduled log scan (by default at 3am), it will read this newly cycled error log file and will find error free entries, thus clearing the alarm. If you want to get rid of the alarms immediately, modify the Schedule of Error Log to run in the next few minutes. Once the alarm clears, set the schedule back to default.