You've Got Questions? I Have Answers

Education In America

Subscribe to Education In America: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Education In America: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Education In America Authors: Darrah Deal, Student Lance, David Miller, David Miller, Chris Pentago

Case Study

Idera Helps St. Charles Do More with Less

SQL Diagnostic Challenges

OVERVIEW

St. Charles Health System began in 2001 as Cascade Health Services when St. Charles Medical Center in Bend merged with Central Oregon District Hospital in Redmond. With four hospitals and more than 120 employed medical providers, St. Charles Health System is the largest provider of medical care in Central Oregon. The health system takes its role in its communities seriously and has pledged to work with its partners to achieve its vision: Creating America's healthiest community, together.

The St. Charles Health System employs approximately 3,400 employees in Bend, Redmond, Madras and Prineville, OR. The systems database infrastructure includes 1100 SQL Server Databases being managed by three full time database administrators (DBAs). The role of the DBA organization is to provide best practices for SQL Server administration, hosting, build, maintain and Administer SQLaaS and provide troubleshooting of database related problems.

THE CHALLENGE

Today's health care is very much data driven and monitoring and maintaining that data are critical to every healthcare system. With 70% growth each year in healthcare data, healthcare organizations are spending more and more for either downtime or poor performance of their databases servers.

Poor visibility, in real-time, into the health of database servers and working reactively instead of proactively are main contributors to that cost.

Like many modern healthcare systems, St. Charles Healthcare relies on its SQL servers to support business critical applications for its EHR (Electronic health record) and EMR (Electronic medical record) systems.

With an ever changing database environment and a growing healthcare system, St. Charles Health System faced challenges with a lack of monitoring of SQL Server instances; database downtimes causing issues, expansion of SQL Server install base and no enterprise alerting system. This all took place while the organization had no trained DBAs on staff.

SOLUTION

To better manage its SQL Server infrastructure, St. Charles started looking for vendor solutions that offered alerting of error conditions, DB troubleshooting, capacity planning, and the ability to do with more with less. The health system was already using SQL Diagnostic Manager and selected additional Idera products including SQL Compliance Manager, SQL Secure and SQL Doctor. According to George Rasco, senior database administrator at St. Charles Health System, "We selected Idera because the company provided the most comprehensive solution although a bit more costly, but was worth it."

BENEFITS & OUTCOMES

Utilizing the Idera tools, St. Charles is able to do more with less. One DBA can now manage many more SQL instances. Additionally, the organization is able to deliver and maintain three nine uptime (99.9%) comfortably across the entire organization. The product's server dashboard provides great insight into their SQL Server environment and offers the types of reports that allow them to better manage and deliver the services required. Rasco continued, "We are very happy with the Idera products and the benefits they delivered to our organization. We are currently budgeting to grow our Idera portfolio with the addition of SQL Elements and SQL Diagnostic Manager as part of onboarding any new SQL Server instance."

More Stories By Reza Koohrang

Reza Koohrangpour is a product marketing manager at Idera responsible for the company's portfolio of SQL Server management tools and network and application performance management solutions.

Prior to joining Idera, Reza worked as a field sales consultant at Condusiv Technologies, and held roles as a senior technical product marketing manager and Cloud Services product manager (SaaS) at Dell, where he was responsible for the company's $70+M campus networking business and managing its PowerConnect, as well as M-Series Blades and Chassis C-Series family. He has also held engineering and research roles at Cisco, IBM and KTH Royal Institute of Technology.

Reza was awarded a patent for System and Method for Integrating Asset Tagging with a Manufacturing Process and holds several certifications including Cisco CCNA, Advanced IP networking, PRP (SDLC) 1.0 and 2.0, and advanced switching and routing.

He has a Bachelor of Science in Electrical and Electronics Engineering from Isfahan University of Technology, a Masters of Science from Chalmers tekniska högskola, and an MBA from the Texas A&M University Mays Business School.