Microsoft SQL Server

DTS provides shared SQL Server environments (production, development, and acceptance testing) on a Windows platform in the Salt Lake City Data Center. State agencies access SQL Server data using the well-known Structured Query Language (SQL) via applications and other standard interfaces.

• 7 x 24 support of the SQL Server environment;
• Software upgrades, as well as preventative software maintenance of the SQL Server environment;
• State of the art diagnostic tools and monitoring;
• Maintenance of the SQL Server environment so that DTS has full vendor support of the environment;
• Administration security for the SQL Server subsystem;
• Enterprise-class storage provided by highly available disk and tape environments.
• Data placement, backup and recovery, and performance tuning of the SQL Server environment, including routinely scheduled data reorganization and operating system tuning;
• Proactive identification of problematic routines and processes, which may be result in performance degradation within the environment with suggestions for improvement;
• Tuning of SQL, etc., to make applications run more efficiently can also be performed, upon request for an additional fee.
• Customers are responsible for the building of tables, indexes, etc., once they have received their own database environment.   However, business day support of user requests for DBA assistance in data loads, table and index creation, data migration and other non-disruptive tasks can be requested for an additional charge. 

Daily database backups are created and retained at the SLC Data Center for two weeks for the purpose of restoring data in case of a hardware or software failure.  However, providing archiving of a collection of backups or sending backups to an off-site location for disaster recovery can be performed for the customer at an additional cost.

Services Not Included with this Product

Application Programming Services
DTS does not provide application programming services as part of the SQL Server Database Hostingproduct. Such services are available from DTS Engineering Services.