Modernizing Healthcare: How Alcidion achieved greater stability and performance with AlloyDB
Alcidion, a global provider of smart health solutions, migrated its Miya Precision care platform from a legacy Microsoft SQL Server environment to Google Cloud's AlloyDB for PostgreSQL. The move targeted performance bottlenecks, operational overhead, and stability concerns. Using Google's Database Migration Service and custom synchronization tools, the team completed the cutover in about 15 minutes. The result was faster data processing and a step-change in reliability.
Key Takeaways
- Alcidion migrated Miya Precision from Microsoft SQL Server to Google Cloud's AlloyDB for PostgreSQL.
- The previous setup caused operational overhead, performance latency, and stability concerns.
- The full learning and migration process took under one month, with the core database move done in about one and a half weeks.
- The final cutover window was reduced to just 15 minutes using custom synchronization tools.
- Jobs that once took 30 minutes now complete in 5 to 60 seconds after moving to AlloyDB with BigQuery and Dataflow.
Stats & Key Facts
- #Complex JSON data processing was taking up to 30 minutes for certain jobs
- #Total learning and migration process took under one month
- #Core database move completed in one and a half weeks
- #Final transition window reduced to just 15 minutes
- #Jobs that once took 30 minutes now complete in 5 to 60 seconds
The Challenge: Performance Bottlenecks
Alcidion faced several hurdles with its SQL Server setup in an industry where data integrity and uptime are non-negotiable.
- ›Operational overhead: the team manually balanced database loads between elastic pools and managed the gap between allocated and used space.
- ›Performance latency: complex JSON data processing took up to 30 minutes for certain jobs.
- ›Stability concerns: the team wanted a more stable Kubernetes environment and a persistent backend that could scale without constant administration.
Miya Precision serves as an intelligent care platform for modern hospitals, helping manage patient flow and reduce clinician cognitive load, so reliability is critical.
The Migration to AlloyDB
Alcidion used Google's Database Migration Service to move from SQL Server to AlloyDB.
- ›The total learning and migration process took under one month.
- ›The core database move was completed in only one and a half weeks.
- ›Custom synchronization tools reduced the final transition window to just 15 minutes.
Alcidion spun up a new Google Cloud instance synchronized to the active one, with both accessible via unique fully qualified domain names. The new environment stayed in read-only mode for customer validation. During final cutover, the old instance was set to read-only, synchronization was halted, and external integration links were toggled to the new environment, with the primary delay being DNS record updates.
Choosing a Fully Managed Service
Alcidion selected a fully managed AlloyDB service.
- ›The choice eliminated control plane tasks and administrative overhead.
- ›Engineers could focus on clinical innovation and product development instead of managing the database infrastructure.
- ›Cutting over in about 15 minutes got users back to work almost immediately.
For a system clinicians rely on around the clock, the smooth transition gave Alcidion confidence in the move.
Results by the Numbers
The shift to AlloyDB and Google's Agentic Data Cloud delivered measurable improvements.
- ›Data processing that once relied on SQL Server stored procedures was transformed using AlloyDB, BigQuery, and Dataflow.
- ›Jobs that once took 30 minutes now complete in just 5 to 60 seconds.
- ›The migration delivered a step-change in reliability.
Improved Stability
Reliability improved significantly after the migration.
- ›In the previous environment, the team faced monthly disruptions, from failed scheduled maintenance to connectivity issues needing manual intervention.
- ›AlloyDB and Google Cloud's compute services proved exceptionally stable.
- ›The team moved away from constant firefighting.
Frequently Asked Questions
What did Alcidion migrate, and to what?
Alcidion migrated its Miya Precision care platform from a legacy Microsoft SQL Server environment to Google Cloud's AlloyDB for PostgreSQL.
How long did the migration take?
The full learning and migration process took under one month, the core database move took about one and a half weeks, and the final cutover window was just 15 minutes.
How much faster is data processing now?
Jobs that once took 30 minutes now complete in 5 to 60 seconds after moving to AlloyDB with BigQuery and Dataflow.
How was the short cutover achieved?
Alcidion used custom synchronization tools and a new synchronized instance, set the old instance to read-only, halted synchronization, and toggled integration links, with DNS updates as the main delay.
Why choose a fully managed service?
A fully managed AlloyDB service eliminated control plane tasks and administrative overhead, letting the engineering team focus on clinical innovation rather than managing infrastructure.
Alcidion's migration to AlloyDB cut processing times and improved stability for a healthcare platform clinicians depend on around the clock.
Continue Learning
Comments
Sign in to join the conversation