A Bad Afternoon

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.




Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s