The Northdoor SQL Server Advisory Service is designed to enable clients with sprawling Microsoft SQL Server estates to understand them, evaluate them and be ready to take action to improve them. Particularly for NHS organisations – where central government has estimated potential benefits of up to £66 billion – enabling data-driven operations and analytics can provide enormous efficiency gains and cost savings. The Northdoor service, with a contract duration of one year, is designed to help unlock these benefits by helping clients to transform their data estates.
There are two essential components
The service is available in three variants: Small, Medium and Large.
Target: CFO. The objective is to provide the CFO with the means to understand what the systems are being used for, and – given the relative importance of these systems – the relative risks faced by the organisation. Important: This is not an audit, and in particular it is not a licence audit. Licence-related information will be uncovered as a consequence of the service, but will not be passed to any third party.
The assessment comprises five phases, as follows:
During the engagement phase, we introduce ourselves to the client and discuss the advisory process, its objectives and the deliverables. Particularly important is the need to reach agreement regarding any procedural requirements for database and network access, both of which are key to the delivery of a successful outcome.
Having agreed the method of access to the source data, we run the MAPS tool on the SQL Estate using WMI. The output from the tool is a comprehensive list of SQL Server instances together with basic server specifications, database instances, versions, editions, components and service packs. To aid the next phase, we produce a one-page summary of this information.
Phase 3 takes the form of a meeting with two purposes:
We will suggest likely candidates for the next phase based upon our findings and our opinion, but the client may choose which servers to analyse based upon any criteria. The meeting will also be used to enable us to understand the functional role of each server and to agree database-access methods for detailed data-gathering purposes.
Using our own SQL Assessment tool, we interrogate and analyse the SQL instances chosen in Phase 3. The output from this phase is a highly detailed document for each one containing:
We use the information in this report to
Finally, we meet with the client to present the documentation, go through our detailed findings and recommendations, and agree next actions.
We bundle a set number of hours of SQL Server consultancy to be used for advice and remote support purposes. As this it is not intended to be the primary support vehicle for any client, the first-response SLA will be set at next working day. This service may be upgraded to a full Serviceline or Manageline contract.
For more information on how the Northdoor SQL Server Advisory Service can help organisations modernise their data estates and unlock the benefits of big data, please contact us.