A Short Note on Maximum Availabilty and Maximum Performance for Standby Databases


Had an interesting discussion about the difference between Maximum Availabilty and Maximum Performance for Standby Databases.

When standby databases were first provisioned at our site, the network performance was found to erratic so we went for Maximum Performance to order to avoid COMMIT waits. The users were severely impacted whenever the inter-site network clogged up.

Recently, the network performance has improved to such an extent that we can provision standby databases running in Maximum Availability without anyone noticing the performance difference. The performance graphs bear this out by showing a very thin orange line for COMMIT waits.

My own opinion is that we should stay with Maximum Availability in order to minimise potential data loss.

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