Case Study: SQL Diagnostic Manager for SQL Server

Seattle Cancer Care Alliance Monitors the Health of Critical Patient Care Servers with SQL Diagnosti…

THE CHALLANGE

There are two types of mission-critical servers in healthcare –business critical and patient critical. Patient-critical information needs to always be well-maintained, available, and easy to access. We were looking for a solution that could give us the visibility and flexibility we needed to maintain these servers.

OVERVIEW

The Seattle Cancer Care Alliance (SCCA) is a world-class cancer treatment center that unites doctors from Fred Hutchinson Cancer Research Center, UW Medicine, and Seattle Children’s. More than 300 oncologists, surgeons, radiation oncologists, and many other clinicians treated over 5,500 patients for many types of cancers including leukemia, lymphoma, breast, prostate, lung, and colon cancer at the SCCA. The Fred Hutchinson Bone Marrow Transplant Program at SCCA performed over 500 bone marrow transplants.

Since 1998 center has had a simple vision with a critical mission: lead the world in translating scientific discovery into the prevention, diagnosis, treatment, and cure of cancer.

“There are two types of mission-critical servers in healthcare – business critical and patient critical,” said Berhe. “Patient-critical information needs to always be well-maintained, available, and easy to access. We were looking for a solution that could give us the visibility and flexibility we needed to maintain these servers, and IDERA was the best we saw on the market.” Berhe was managing more than 70 production, development, and test SQL Servers with a variety of editions. In addition, his team managed a variety of SharePoint and analytics servers. For his small three-person team, this was a big undertaking. And when one of his team members changed positions, managing the servers more effectively became more important.

“We simply didn’t have the visibility we needed,” Berhe said. “We had the team leveraging OS level monitoring systems they were currently using, and we set alerts for specific maintenance jobs. However, we didn’t have the ability to know, in real-time, the status of our SQL Servers. We were working reactively instead of proactively.”

Topics : Database Diagnostics,Database Monitoring,Database Performance,

Products : SQL Diagnostic Manager for SQL Server,