Dedicated SQL Server

Dedicated SQL Server

About Dedicated SQL Server

This service provides a database management system to handle routine database operations and maintenance on behalf of state agencies. A database server has the primary function of storing and retrieving data as requested by other software applications within the same computer and across a network. Dedicated SQL Server provides performance enhancement and additional flexibility with dedicated hosting options.

What problems it solves

This solution helps agencies and boards professionally manage database servers, allowing the internal agency to redirect resources to be used for higher-value business objectives rather than routine operational and maintenance tasks.

What the Service provides
  • A team of experienced professionals to handle routine database operations and maintenance on behalf of state agencies
  • Database administration service to assist with managing the database server
  • Dedicated database server conducted on a customer-owned database server, excluding maintenance windows
  • Database administration support is provided monthly including:
    • Database table maintenance
    • Backups
    • Monitoring of the database system
    • Database Management System (DBMS) tuning
  • Professional guidance on:
    • Architecture design
    • Administration
    • Monitoring and troubleshooting for dedicated infrastructure/cloud server platforms
Benefits of this Service
  • Optimization of database performance according to application requirements
  • An experienced team of professionals to ensure maximum utilization
  • Guidance from experts in the field
  • Eliminates the need for hiring database administration personnel
  • Enhancement of security due to the exclusive use of dedicated resources

 

Billing Unit: Database [1-10 = 1 unit; 11-20 = 1.25 units; 20+ = 1.5 units]
Billing Code: 8270

 

Eligible Customers
  • All State Agencies, Boards and Commissions
Service Prerequisites
  • Server with required configuration for hosting the database
  • A valid license for MS SQL Server
Scope of Service
  • ASET Responsibilities:
    • DBMS monitoring and performance tuning
    • DBMS environment troubleshooting and problem resolution assistance
    • Perform DBMS (system) and Application Database Backup for use during Disaster Recovery
    • Management and completion of database-related customer service requests and issues
    • Support and facilitate cross-training of database administration staff
    • Maintain DBMS environment documentation which includes customer specific attributes with respect to the DBMS environment
    • All other requests for database administration assistance shall be provided following a receipt of a customer request and invoiced on a Time & Materials (T&M) basis according to the Database Specialist support rates published on the ADOA-ASET Service Catalog Rates page
  • Customer Responsibilities:
    • A host server and infrastructure supporting the database instance are the customer’s responsibility
    • SQL Server infrastructure and licensing costs are the customer’s responsibility for all dedicated customer-owned instances
    • Coordinate DRM requests with Applications support team(s)
    • Attain authorization through the ADOA-ASET Security Group as required
    • Provide ADOA-ASET with customer contact information for the following:
      • Authorized Requestors
      • Authorized Approvers
      • Technical Contacts
    • Request assistance or support via the ServiceNow Customer portal. Click on ADOA-ASET Service Desk. Select Database Support then Database Hosting.
    • If you would like to add or decommission a service, please submit a service ticket via the ServiceNow Customer portal. Click on ADOA-ASET Service Desk and then select the appropriate service.
    • Authorize activities in support of DBMS environment
    • Pay monthly fees associated with the use of the service
    • Customer agrees to provide ADOA-ASET authority to act on their behalf in case of an incident that requires immediate action outside of normal business hours
  • Shared Responsibilities:
    • Coordinate application test schedules for system or application software upgrades
    • In case of disaster and by customer request, coordinate customer's database recoverability with DBMS configuration, Point in Time Recovery and Point in Time Backup with Applications and Support teams
Service Commitment
  • Response Time: 24 - 48 hours (depending on severity)
  • Resolution Time: Dependent on issue
  • Support Time: 8AM - 5PM Monday - Friday
Related Services
How to order this Service

To order this service or for any questions related to it, please reach out to your Engagement Manager or submit a request using our Contact form (select Subject "Engagement Management").