Catalog Header

 
A-Z Listing Help Service Catalog Home

SQL Enterprise Services

The SQL Enterprise Hosting Service provides central dedicated shared Microsoft SQL Servers on a Windows platform. Users' databases reside on these servers in a controlled physical environment with fully managed updates, maintenance, storage, backup and disaster recovery services. Note: Users with larger scale or multi user databases need this Enterprise level service instead of the lower level (SQL Express) which is designed for small scale databases.

Benefits for users

  • A standardized, dependable cost effective server environment that meets the businesses needs.
  • Steady predictable costs.

Availability:

Normal, default coverage is 7AM – 5PM, Monday – Friday. 24x7 coverage is available for systems with a specific need for this type of coverage In order to have 24x7 coverage; OIT needs to receive a written business justification. Once justification has been approved, OIT will work with the business on a service level agreement for the specific systems. Additional charges associated with extended coverage will be defined in the SLA.

Service Components Included in the Base Price:

  • 1 database
  • Storage is automatically charged the published storage rate
  • Full Enterprise SQL Server 2008 R2 hosting.
  • Online backup of the database and the default storage and archive of the backups (Weekday full database backups by default)
  • Log backups by business request
  • Facilities management (secure datacenter, UPS, generators, HVAC)
  • High Performance 64 bit platform. 4-8 CPU's and 32 gig of Memory per Server and EMC fiber channel connected storage
  • Unlimited user connections free of Microsoft licensing restrictions and CALS. (i.e. All Enterprise SQL is licensed by CPU by OIT)
  • Patch management for the OS and SQL Server • Primary and secondary server administration support
  • All OIT overhead costs (facilities, personnel, etc.)
  • Operating system backup w/ off-site rotation
  • Network connection/connections
  • OS support
  • Operating disk setup w/mirror
  • Virus protection
  • Vendor installation assistance
  • Security - server hardening
  • Hardware monitoring (HP insight manager)
  • WebNM monitoring (Hardware, Server Services, database and log monitoring)
  • Backup and recovery of the OS and databases. Custom plans available upon request
  • 24 x 7 data center monitoring/coverage

Options Available for Additional Charge:

  • High Availability (please consult our rates schedule )
  • Database mirroring
  • SQL Clustering
  • SQL Reporting Services
  • SQL Analysis Services
  • SQL SSIS Services

Rates charged:

for this service are in the OIT rate table

* Rates are also shown for additional storage beyond the amount in the standard agreement

Service Level Targets & Agreements:

The standard production published service level agreement can be viewed at the following link:  Standard_SLA_CTS_Production Services. A formal SLA has not been developed specific to this service.

To get help and or order SQL Enterprise Services:

  • To learn more about this service or to order this service:
    • Call Customer Support at 624-7700
    • Enter a Foot prints service request assigned to the OIT Application Server team
    • Request assistance at one of the regular scheduled meeting with Core Technology and TBCleadership.
  • How to Escalate Service Issues:
    • If the published SLA is not met, the issues can be escalated to the next priority level by any of the following methods: Dawnna Pease, Manager
    • Production Services Windows Server, Citrix, File & Print and SQL Server Services
    • dawnna.pease@maine.gov ~ 207.624.7548

Customers (users) responsibilities :  

  • Application support
  • Disclosures of any/all business requirements for specific databases
  • Disclosures of any/all security requirements
  • Application subject matter expert and tester in the event of an upgrade, outage during normal business hours or after hours
  • Core Technology needs to maintain a "maintenance window". This allows for routine maintenance on the backup infrastructure components

In the event that OIT has a need for equipment to be located in buildings outside of its main data centers, access to these buildings will need to be granted to support staff during normal business hours. If there is a 24x7 requirement for this equipment or any system supported by this equipment. Access to the building will need to be 24x7 as well as 24 hour network support is required for the building. Physical access to the hardware is required by OIT for the maintenance time period.