Reduce your taxes # 2 – The SQL Server Backup Tax

In the first of this series I discuss that some organizations are over provisioning their server resources in order to balance competing performance and data protection SLAs. Let’s look in detail at one example of this, “the backup tax” for doing native SQL Server backups.

Challenge: The Backup Tax – The following graph shows the results of testing of backup processing on a transactional (TPC-C style) workload running in SQL Server. It illustrates one example of a tax rate of 40%.

The graph of the results shows that approx. 40% of the CPU cycles provisioned for SQL server must be reserved in order to make sure that service levels for performance are met during backup with the SQL Server native backup utility.

Conclusion: Simultaneously meeting service level agreements for performance and data protection while using the native SQL server backup requires at least 40% over-provisioning of your database server resources. And this assumes that you’re willing to run your database server at 100% utilization during the backup window. This is an exorbitant 40% tax rate that you shouldn’t have to pay.

For more information on the testing that was done please refer to:  http://dell.to/w35fsv

Let’s hear from you, what do you pay for backup taxes? What is your tax reduction strategy?

Advertisements

About Bob Ganley

Enterprise Information Technology Executive, Family Man, Athlete @ganleybob on twitter
This entry was posted in SQL Server and tagged . Bookmark the permalink.

One Response to Reduce your taxes # 2 – The SQL Server Backup Tax

  1. Pingback: Oracle RMAN is the SLA “Tax man” | ganleybob

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