The Linn County Sheriff’s Office provides patrol services, detectives, corrections services, civil services, 9-1-1 emergency services, and emergency management for the citizens of Linn County, Oregon. The Sheriff’s Office employs a staff of 184 full time employees who serve in six different operational divisions.
The Linn County Sheriff’s Office abides by a professional code of the highest ethics: service to humankind, safeguarding lives and property, and an exemplary private life in keeping with the public trust. The Linn County Sheriff’s Office values integrity, professional excellence, the community, its employees, and respect for individuals.
The Tech Decision
With a stated mission to serve and protect the persons and property throughout the county it serves, the Linn County Sheriff’s Office is steadfast in its determination to minimize the risk of system downtime.
Their 24 x 7 environment leveraged a number of older “green screen” public-service applications based on IBM System i. The aging applications were time consuming and challenging to manage with a limited staff of just three people who support more than 200 internal users and as many as 300 external users.
The cost and niche skills were a real challenge to building out systems. It was taking as much as 30-40 hours of annual maintenance time to support the main applications. As such, downtime was a consistent concern.
Linn County Sheriff’s Office needed to develop a more stable environment that could be maintained more easily so that it could limit downtime and assure more consistent availability of critical systems.
The Nutanix Hyperconverged Solution
To support its datacenter requirements the Linn County Sheriff’s Office has recently migrated to a Nutanix Hyperconverged solution for its primary computing platform using both VMware and Acropolis hypervisors.
A high-performance HP Enterprise network switching system has also been deployed. One of the main systems this configuration supports is the Superion Public Safety Suite—deployed on Windows and SQL Server—that Linn County uses for dispatching, records management, jail management and mobile systems.
The Sheriff’s Office also delivers Windows 10 virtual desktops to its users via Citrix XenDesktop and XenApp.
With this new infrastructure to support its public operations, the Linn County Sheriff’s Office next became focused on minimizing the risk of downtime so that it could maintain reliable accessibility for users without high management overhead.
Why they didn’t choose an all-Microsoft option
Initially, the Sheriff’s Office considered a couple of different solutions. One solution was an all-Microsoft option and the other was NeverFail software.
However, after looking carefully at the SQL editions and what features would be required to achieve the high availability they needed, it was clear that the Microsoft solution would be too costly and complex.
NeverFail would have resulted in an excessive amount of writes since the underlying Nutanix solution already provided replication. That’s when Linn County’s trusted reseller partner, Sirius Computer Solutions, recommended an evaluation of DH2i’s DxEnterprise.
DH2i’s software held the keys to the workload and data portability Linn County Sheriff’s Office needed to assure high availability for their SQL Server instances, application services, and the Superion Public Safety application itself.
DH2i’s Smart Availability software creates a framework for orchestrating datacenter management, high availability/disaster tolerance and policy-based SLA management. In addition, intelligent automation ensures that workloads always run at their best execution venues for total optimization of the environment.
DxEnterprise uses shared or replicated storage technology to coordinate access to a pool of disk resources in the cluster, for consistent disk presentation no matter which host the managed instance is active on.
In addition, DxEnterprise can support any current version or edition of SQL Server and OS across any bare-metal, virtual or hybrid infrastructure—Windows or Linux platform.
“With DxEnterprise we can manage the SQL Server instances and keep a single volume per instance that moves with the instance,” says Cary Jeffers, computer resource specialist.
“This allows us to achieve peak availability for our SQL Server instances—while also maintaining HA for the file shares and services essential to full service delivery of the Public Service applications.”
“We used the Quick Start services from DH2i and had our POC running in a day,” says Jeffers. “Right away, with DxEnterprise, we’ve seen our failover times improve.
When DxEnterprise was first deployed into production, failover took about 5 minutes. With further application optimizations, scripting and other fine tuning, the most recent failover only involved 18 seconds of downtime to core applications.
It still takes additional seconds to upgrade SQL Server, but if we didn’t have DxEnterprise, a single SQL Server upgrade could take as long as an hour of downtime to complete.”
Linn County Sheriff’s Office has also been very impressed with DH2i’s support organization. “We’ve found the DH2i support organization to be exceptionally responsive and willing to help with every facet of the product,” said Jeffers.
“We have worked with many, many support organizations and consider DH2i’s support to be, comparatively, in the top tier.”
More quickly than expected, the Linn County Sheriff’s Office has seen a dramatic improvement in system availability and can now dramatically minimize downtime due to planned and unplanned outages.
In addition, Linn County has already saved $100,000 or more on SQL Server licensing requirements alone—compared to the spend that the all-Microsoft-based HA solution would have necessitated.
“We have found great value in the DxEnterprise software and have even received features we didn’t know we’d require,” says Jeffers. “Now we truly can make our applications available as much as possible for our users, 24×7. We now expect the new system to result in less than an hour of total downtime a year.”