asked
nagios alert:CRITICAL: Log Flush Wait Time is 109.0ms
other errors from Naggios: CRITICAL: Page Writes / Sec is 3203.91231658/sec CRITICAL: Page Reads / Sec is 2696.86653994/sec What to do in this case.
page reads per sec (warning): 498.527 / sec readaheads per sec (warning) 39.48
Without knowing more about your system, I'd guestimate that you have a SQL Server which is very busy. Lots of page reads and lots of page writes indicates this. This is either because you have tons of transactions going on, or because there are weaknesses in the database code, causing the server to be busy Reading and writing from/to disk. There are loads of suggestions to ease up your server's disk activity, but they all depend on what is going on and why it is going on. Looking only at disk activity is not enough.
So I ran a query: SELECT AVG(current_tasks_count) AS [Avg Task Count] , AVG(runnable_tasks_count) AS [Avg Runnable Task Count] FROM sys.dm_os_schedulers WHERE scheduler_id < 255 AND [status] = 'VISIBLE ONLINE' ; -------------------- Avg Task Count Avg Runnable Task Count 17 0
which tells me that system is stressed (as avg task count is more than 10. However, how to make it less stressed?
Only you know what activity is going on in your database. Run a trace against the machine to find out. It could be many users, it could be jobs affecting the server, it could be poorly written code. It could be poor database design. It could be a combination of the above. Noone but you knows exactly what is going on in your system.
16 People are following this question.
