We are using Spot light for Monitoring SQL Server 2005 and we are getting the below error frequently.
What this error referencing to? What is the corrective action to get rid of this? Is this a serious issue? We are getting this for all most all databases
Time Connection Action Details Severity Alarm
05/20/2009 4:01:32 PM ABC Alarm raised the database Search_DB has a high Log Flush Wait time (515 ms). Low Databases - Log Flush Wait Time Alarm.
This means SQL server cannot write the log files onto the disk in a timely manner. Do you have DB mirroring set up by any chance to this database?
What is your physical disk layout and also could I ask you what is the frequency of your tlog backups?