SIOS Case Studies

SIOS DataKeeper Protects Critical CAD-EX CAD2CAD Software on SQL Server in Azure

Until recently, dispatchers used computer-aided dispatch (CAD) systems that presumed the likely whereabouts and availability of units in neighboring jurisdictions, but to request dispatch, they had to call those neighboring agencies on a dedicated phone line to validate  actual unit location and availability. This process slowed response times and did not give first responders access to critical incident details that may be available from the dispatching agency.

To improve efficiency, NCR agency leadership and Emerging Digital Concepts (EDC) collaborated to create the Data Exchange Hub (DEH) – a data exchange and functional interoperability platform
designed to provide member NCR emergency services agencies with secure access to data and applications. They used the National Information Exchange Model (NIEM) to ensure
the interoperability of systems, communications, and procedures.

The DEH has become a national model of efficient regional cooperation in emergency response. Ensuring Efficient Emergency Dispatch Services for National Capital Region SIOS DataKeeper Protects Critical CAD-EX CAD2CAD Software on SQL Server in Azure.

The primary DEH information exchange is the CAD-to-CAD (C2C) Exchange, which enables dispatchers
in all NCR DEH agencies to immediately understand front-line resource locations, resource availability, and to share up-to-date information on related incidents in all C2C Exchange connected CAD systems in member jurisdictions.

The NCR DEH C2C Exchange uses a Microsoft SQL Server database operating on Windows Servers and
is deployed in the Azure Commercial Cloud. Given the critical nature of these systems, the DEH demanded high-availability data protection for the C2C Exchange platform Failover Clustering without Added Complexity In a traditional Windows high-availability (HA) environment involving a database, two or more database instance nodes are configured in a Windows Server failover cluster with shared storage (typically a SAN).

The database is operational on the primary node with HA failover software monitoring its operation. If an issue is detected, the HA software orchestrates failover of the database operation to the standby, secondary node(s) in the cluster. In the cloud and other environments where shared storage is not available nor cost-effective,
replication is used to create a SANless cluster by synchronizing local storage on each of the cluster nodes so that, in the event of a failover, the secondary node can continue to operate with current data.

In the earlier stages of the project, the NCR IT team had deployed the C2C Exchange platform in a number of environments. This included an on-premises Fairfax County data center and subsequently in multiple third-party, national and local hosting provider environments. In these environments, the C2C Exchange database deployment architecture used Microsoft SQL Server Enterprise Edition
and Always On Availability Groups.

As the project expanded, the NCR IT team was driven to take advantage of advancing cloud technologies and to deploy the C2C platform to the Azure Commercial Cloud.
The Cloud offered the flexibility and service levels needed to manage the C2C platform in a more virtual environment.

The Azure Cloud also allowed the NCR to deploy a more cost-effective, high-availability, database clustering solution to deliver C2C Exchange application data confidently while simultaneously reducing the higher licensing costs associated with SQL Server Enterprise Edition.

The Solution

The NCR DEH C2C Exchange began employing the SIOS DataKeeper Cluster Edition software to create SANless clusters to protect their C2C Exchange data availability in Azure Commercial Cloud. The software runs on a two-node active-passive Windows Server Failover cluster configuration utilizing SQL Server Standard Edition with Always On Failover Clustering.

The SIOS DataKeeper software uses bandwidth-efficient, host-based, block-level replication to synchronize local storage on all database cluster nodes. If an application availability issue is detected, operation is automatically moved to the secondary node with no manual intervention required. The service levels guaranteed by cloud vendors ensure hardware operability but they do not include software and networking-related causes of application downtime.

The Results

The NCR DEH C2C Exchange has been using the SIOS DataKeeper Cluster Edition software in the Azure Commercial Cloud for more than two years. Participation in the interoperability program has grown. In addition to the initial members, the program now includes the Metro Washington Airports Authority (MWAA), Virginia Counties of Loudoun and Prince William, and Maryland Counties of Montgomery and Prince George’s. The C2C Exchange manages a few thousand shared units and shares data on hundreds of thousands of incidents per year between these participants.

Establishing the high-availability database cluster in the Cloud was fast and straightforward using SIOS DataKeeper Cluster Edition. “We simply installed SIOS DataKeeper to our Windows Server Failover Cluster nodes, configured the local node storage as SIOS managed storage for replication, and it operated seamlessly,” said Greg Crider, EDC Chief Technical Officer and Co-Founder. “An added benefit of the SIOS DataKeeper clustering software is that it enables us to perform regular, rolling software maintenance on the database by transitioning cluster nodes, on-demand, without the need for planned downtime or interruption of service.”

Since implementing SIOS DataKeeper in the NCR C2C Exchange, there have been no downtime issues involving the database or data loss between nodes. Chris Wiseman, EDC President, CEO, and Co-Founder adds, “There have been a few unexpected, uncontrollable networking issues, however, the database failed over quickly and C2C Exchange operation has continued without end users being impacted by prolonged reduction in service. The SIOS DataKeeper software enables us to deliver higher levels of data protection and delivery without needing the more costly SQL Server Enterprise Edition licensing. That adds up to significant, continuing annual savings for our stakeholders.”

The NCR C2C Exchange with SIOS DataKeeper protection is featured by the DHS/SAFECOM in a video link). It was recently put to the tested when three large fires occurred simultaneously at a bank, an apartment complex and a nursing home. The interoperability between CAD systems played a critical role in ensuring fast, efficient response to these incidents.

EDC is broadening C2C Exchange adoption around the United States in other markets with its commercially available NG-CAD-X C2C Exchange product. This functionally advanced C2C offering is being implemented by the City of Denver North Central All-Hazards Region and by greater Southeast Florida. NG-CAD-X is message compatible with the NCR C2C Exchange, deployed in the Azure Government Cloud for CJIS-compliance and law enforcement adoption in addition to fire and EMS ESF, and also implements SIOS DataKeeper Cluster Edition into its database architecture for all of the operational and cost-effective reasons highlighted above. “Strategic partnerships play an important role in providing our customers with the best technology solutions in the marketplace. SIOS DataKeeper in an integral part of our system and is a valuable EDC partner.” said Kevin Konczal, Vice President, EDC.

Download the pdf

SIOS LifeKeeper helps Mitsubishi Motors maintain High Availability for its critical systems in the cloud.

Chris O’Brien Lifehouse (www.mylifehouse.org.au) is an integrated and focused center of excellence specializing in state-of-the-art treatment and research for patients who are suffering from rare and complex cancer cases. Lifehouse offers everything a cancer patient might need in one place, including advanced oncology-surgery, chemotherapy, radiation therapy, clinical trials, research, education, complementary therapies and psychosocial support. Situated alongside Royal Prince Alfred Hospital and the University of Sydney in Camperdown, the not-for-profit hospital sees more than 40,000 patients annually for screening, diagnosis and treatment. As one of Australia’s largest clinical trial centers, Lifehouse also provides its patients access to the world’s latest cancer treatment breakthroughs.

SIOS DataKeeper determined to be the only way to ensure a simple, manageable and yet cost-effective and robust solution that supported multiple integrations of devices and data securely, while also guaranteeing a high availability outcome for state of the art stadium.

RSM Global, the world’s sixth largest audit, tax and consulting network had a collection of independent content management systems running across their 30 national offices. Craig Hannagan, RSM’s Project Manager was tasked with creating a single, centralized CMS that was highly available for over 1,200 users and to determine the best way to maximize its availability.

PayGo, a utility payment solution provider that manages the largest energy company prepay programs in the United States, was forced to use SQL Server’s transaction logging and log shipping to protect the data – due to the lack of shared storage on AWS. SIOS software provides cost-efficient high availability for PayGo’s SQL Server environment on AWS cloud.

Toyo Gosei Co., Ltd decided to migrate to the cloud due to the end of maintenance of SAP servers. And behind the migration to the cloud, there were needs to be free from on-premises system maintenance, demands for flexibility of scale-up and preparing for disaster based on the experience during the Great East Japan Earthquake.

Hospitals are subject to some fairly strict government regulations, so for ALYN Hospital it was paramount to implement strong business continuity provisions for many of their applications. Read the case study to learn how ALYN Hospital chose SIOS DataKeeper as its High Availability and Disaster Recovery solution.

SIOS software delivers high availability data protection for leading manufacturer in a user-friendly cloud environment. “SIOS DataKeeper gave us an easy way to move our business-critical SAP ERP system to the Microsoft Azure cloud while meeting our stringent SLAs for availability, disaster recovery, and performance,” said Daniele Bovina, Systems Architect,  Bonfiglioli. Learn more.

SIOS DataKeeper Cluster Edition eliminated bandwidth issues, improved data protection, and significantly reduced downtime in a critical on-premises SQL Server healthcare network environment. Learn more.