The Rotherham NHS Foundation Trust
The NHS in Rotherham, South Yorkshire were a 4,000 user organisation encountering problems with it’s data repository SQL Server.
The trust were encountering issues in almost 1 in 10 data transactions to the SQL Server. In practical terms this meant that the healthcare professionals trying to access the information were working with out of date data almost as soon as the connection was made.
To identify and address the issues surrounding the trust’s data access issues & SQL Server.
The resolution to this problem also had to be completed within very strict time constraints, making precise project management a priority.
After through exploration the core issues with the SQL Server were identified and solutions proposed to the NHS trust.
The primary concern of data access was immediately addressed by implementing a temporary modification – allowing the trust to continue to operate without a number of the previous issues.
This ‘temporary fix’ involved establishing a separate SQL Server to mirror the main data repository SQL server. The mirror was able to handle some of the load – this reduced the errors to approximately 1 in every 36,000 transactions.
The proposed long term solution involved use of the SQL subscription (replication) method.
This task was completed as part of a larger on-going project to upgrade the trust’s SharePoint servers to the latest version, allowing much better sharing of data securely and safely across the trust, and between other organisations.
As Halchax’s founding director is a Microsoft certified SharePoint Solution Expert Halchax have been heavily involved in many aspects of this project.
Some of the improvements in the Halchax designed solution included streamlining of the Microsoft SharePoint search functionality, reallocation of Direct Access via Unified Access Gateway, reconfiguration of firewall access, virtual environment improvements to the existing SharePoint system (reallocation of memory and processing power to virtual servers, reconfiguration of hard drive storage), and building of Microsoft WebApp servers.
Extensive testing has been carried out, including complete simulations of data migration and roll-back (should it be necessary) to ensure that there would be no loss of service at the end of the prescribed maintenance period.