Case Study: SQL Safe Backup

Banner – University Medical Center Tucson Maximizes File Compression and Saves on Storage with Idera SQL Safe Backup

INDUSTRY

Banner – University Medical Center Tucson (BUMCT) is a private, non-profit teaching hospital located at the Arizona Health Sciences Center and adjacent to The University of Arizona in Tucson, Arizona. Its 4,000 employees support more than 20,000 admissions and almost 400,000 outpatient visits annually. BUMCT’s high nurse-to-patient ratio contributes to its outstanding patient care, ranking it among the nation’s premier hospitals in U.S.News & World Report’s annual guide to “America’s Best Hospitals.” It has also been named one of the 100 Top Hospitals by Thomson Reuters.

BUSINESS CHALLENGE

Database Administrator Tom Ryan is tasked with the administration of the hospital’s SQL Servers: determining whether backups are being run, dealing with issues of blocking, and making sure the SQL Servers are running smoothly. With 122 SQL Server instances, Ryan needed a high-performance backup and recovery solution that would meet BUMCT’s rapid growth. He also sought to reduce backup and recovery times and reduce the amount of space required for backups.

IDERA SOLUTION

IDERA’s SQL Safe Backup allows University Medical Center to look at all instances in one centralized console and quickly view backup status. The “per instance” pricing model offered by Idera also helps BUMCT keep costs down as they are not required to have a separate license for back-up restores. Within one week of switching to SQL Safe Backup, BUMCT discovered that they were able to compress and reduce their backup files by hundreds of gigabytes, saving money on SAN, disk and off-site tape storage.

When Database Administrator Tom Ryan arrived more than four years ago, BUMCT had been using another third-party SQL Server database backup vendor. After discovering that they were not compliant with the terms of their licensing agreement, Ryan decided to look around for a more cost-effective backup and recovery solution. With 122 SQL Server instances, most of which are stand-alone, Ryan required a database solution that would scale to support essential order data entry for physicians, including clinical data for inpatient and outpatient care, and ICU Critical Care data.

While searching for a backup solution, Ryan discovered that Idera’s SQL Safe Backup was highly rated by industry publications and offered licensing based on SQL Server instance rather than per-CPU. “We could acquire SQL Safe Backup licenses that backed up 10 instances for about what we would have paid to get the 8-CPU instance compliant with its old backup license. My manager was very happy that we could get such a good deal,” Ryan said.

In describing his environment today, Ryan said, “On our clinical side, we have three main SQL Servers. Two are for order entry for physicians, commonly known as EHR (Electronic Health Records), and the other is for ICU Critical Care where all the information for our ICU patients, such as blood pressure and respirations, get pumped into that database every minute. Those are our three biggest and busiest databases and now all three have SQL Safe Backup on them.”

Compression Savings on All Three Levels of Storage

It didn’t take long for Ryan to determine that he had made the right choice with SQL Safe Backup. “Within a week of installing the SQL Safe Backup licenses, one of our server administrators came to me and said, ‘I don’t think we got SQL backups because my whole Friday night backup was hundreds of gigabytes less than normal,’ ” Ryan said.

In fact what had occurred was that after installing SQL Safe Backup the size of the backup location for BUMCT’s largest SQL database for its Critical Care data was reduced to about 275 gigabytes. Before, the backup folder would typically take up a terabyte. As a result BUMCT was able to delay having to purchase additional off-site storage.

“What we do is have the CommVault, which writes the data to an EMC SAN, which is written to disks and is then stored off-site with Iron Mountain. This was great news. Because of the space saved on the SQL backups, we didn’t have to purchase additional off-site storage, delaying the need for more storage for a period of time,”Ryan explained. He added that he had not envisioned the multiple storage savings effect of SQL Safe Backup when he initially purchased the product. “Since that time, when a database gets to be a certain critical size, we put it on SQL Safe Backup when it needs compression,” he said.

Typically, SQL Safe Backup saves money by reducing database backup time by up to 50 percent over native backups and reduces backup disk space requirements by up to 95 percent.

Prior to adding SQL Safe Backup, Ryan said the DBAs would have to adjust the timing of their backups on critical systems since users on the system would cause blocking. Now with SQL Safe Backup, backups are substantially quicker – even when delivering a high level of compression. Even though the largest database has tripled in size  in four years, the amount of time to back it up is still about the same at an hour and a half. “We can back up a half a terabyte database in half an hour with 68 percent compression,” Ryan said.

Download This Case Study Start a FREE Trial of SQL Safe Backup
Share This
Contact IDERA:
+1 (713) 523-4433