86/2016 The Cabinet recommended Option 2, as set out in paragraph 4.2 of the report, to Full Council as an addition to the Capital Programme. R easons: There was a clear short window of opportunity to rationalise the existing Medway Oracle and SQL database environment. Option 2 met a number of key strategic digital aims, namely: · Rationalisation of software and hardware · Improved resilience and system availability · Reduced operational costs · Improved management of ongoing software licence provision · Facilitates a future off premise (cloud) database delivery model. In summary, option 2 was the most cost effective and achievable route to revenue savings over the next 5 years.
Word for word from the decision Medway published for this meeting.Source: democracy.medway.gov.uk
Medway service units are constantly examining their business processes to ensure best value and minimise overheads. The ICT service is no different and where opportunities arise the ICT management team are keen to take advantage of reduced costs and improved service delivery.
The Windows 2003 project has created an opportunity to: Reduce the annual operating costs for Oracle, MS-SQL and VMware licensing. Maintain service in the event of a Datacentre failure Provide a faster recovery mechanism in the event of a database failure Remove the loss of data due to the current lag in the delayed data replication to the recovery site. Additional benefits will include: Lower operating costs Reduced risk of fines for breach of license Faster recovery of applications in the event of a failure or loss of service Upgrades can be performed without taking databases offline.
This report presents a business proposal to change the ICT infrastructure which in turn will create long term savings in database licensing expenditure. The report seeks approval to secure a budget of £226,000 by using prudential borrowing over a 5 year term. This will require approval by Full Council as an addition to the capital programme.
The proposed approach is essential in the short term to gain efficiencies and mitigate risk. It is consistent with the council’s IT strategy to rationalise estate. The council is currently considering its approach to digital transformation, the recommendations here are in no way limit our options going forward. 1. Budget and Policy Framework
1.1Additions to the Capital Programme are a matter for Full Council.
1.3There is a short window of opportunity to rationalise the existing Medway Oracle and SQL database environment. SQL and Oracle licences are due for renewal in 2016 and delay would mean the opportunity for financial benefits would be missed until the next annual renewal.
Background
2.1In November 2015 ICT started a project to remove all non-compliant servers (e.g. Windows 2003) and replace them with compliant servers (Windows 208R2 or Windows 2012R2).
2.2The primary objective of the project was to ensure Medway Council ICT met a PSN compliance audit in July 2016. To achieve this ICT needed to either remove all non-compliant servers, or to demonstrate that there is a clear and committed plan to remove non-compliant as soon after July 2016 as possible.
2.3During the course of the W2003 project it became apparent that a more resilient and cost effective solution for the installation and licensing of the Medway Oracle databases, MS-SQL Databases and VMWare Virtual Servers was possible.
Options
3.1Option 1 – maintain current arrangements – no change to existing infrastructure.
3.2Option 2 – revised Oracle and SQL database infrastructure and licensing strategy.
3.3Option 3 – off premise installation (Cloud based Infrastructure).
4. Advice and analysis
4.1Option 1 – Current – no change
4.1.1 The current licensing model for Oracle provides a Named User Plus license (NUP) for every individual that is required to access any systems that use an Oracle Database.
4.1.2 The annual maintenance cost of the current Oracle Licence model is £73.8k. Medway predominantly licence each SQL database individually. The annual maintenance cost of the SQL licence is £48k.
4.1.3 Current per user model has a high administrative burden on both purchase and licence management with inherent risks associated with under/over licensing.
Read every report as text, not just the decision
Pro opens the officer report behind each decision, searchable and quotable, across every council we cover.
Medium Term Financial Outlook 2026-2031The Cabinet noted the projected budget requirement, the Council’s resource assumptions, and the resultant projected b...
We use a cookie to keep you signed in and run your free-paper allowance, and an optional one to count visits. You can accept all, or choose. Privacy & cookies
Necessary
Keeps you signed in and runs your free-paper allowance. Always on.
Always on
Analytics
Counts visits and which pages are used. First-party only, no advertising, never shared.