This afternoon I have been reported about lots of problems with a database. Looking at the Grid Control I see the chart below. Here we can see that at some 2/3 of the workload is waiting for commit, just “log file sync”. After a little research I see that the performance of the SAN fallen dramatically producing lots of waits for I/O. The problem is solved after talking to team storage.
HTH – Antonio NAVARRO