Database hang

I reported an issue in a database. Looking at the grid control see the chart below.

Waits_for_Log_file_sync

Examining waits everything is staying in the “log file sync” event, this waiting says the log writer is writing the contents of the log buffer to redologs. Usually this is a problem of slow writing to disk. In this case it was a problem of SAN, once storage Team solves the issue, database returns to work fine.

HTH – Antonio NAVARRO

Advertisements

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