INDUSTRY University Medical Center (UMC) 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. UMC’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 UMC’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 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 UMC 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, UMC 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.

Read more!

Read how Hanger Orthopedic Group uses Idera's SQL compliance manager to help comply with Sarbanes-Oxley.

Ancoris extends SQL Server monitoring with Microsoft Operations Manager 2005 using Idera SQL diagnostic manager.

Read more!

INDUSTRY Chaucer Holdings PLC (www.chaucerplc.com) is a specialist insurance and reinsurance group listed on the London Stock Exchange. It provides the capital and expertise required to write business at Lloyd’s, the world’s leading insurance and reinsurance market.  The core of its business is underwriting marine, non-marine and motor insurance and nuclear industry insurance.


BUSINESS CHALLENGE The challenge for Chaucer’s IT department involved finding effective tools that would enable the Senior Database Administrator to monitor a large number of SQL servers and provide overview reports as well as exception reporting. The DBA needed automated solutions—including an auditing system for servers for compliance/regulatory purposes—that would save time and enhance productivity.


IDERA SOLUTION A combination of Idera tools provides performance monitoring and diagnostics, auditing and alerts for server changes, and backup and recovery solutions to help proactively manage and troubleshoot the SQL Server environment from a central console. 

Read more!