Database Management - MS SQL

At Hosted Solutions, we’ve got seasoned SQL server DBAs who have worked in dozens of environments. They can serve as an extension of your internal team and deliver high end SQL server DBA services to you at a fraction of the cost. Our Hi Touch DBA service provides database administration, performance tuning, backup and clustering service. We'll work with you to create the level of support you require, and to help you fully leverage our in-depth technical knowledge, broad experience and applied best practices.

Configuration

Our SQL server DBAs will work with you to perform a review and assessment of the your database configuration to make necessary recommendations.

Our SQL server DBAs will perform ongoing configuration changes as requested by you.

Monitoring

Hosted Solutions provides monitoring of the database and associated server to determine system availability. In the event that the database server(s) fail to respond, Hosted Solutions will notify you and initiate corrective action.

Monitoring activities include:

Node Checking (ICMP-based) to verify connectivity to the database server(s) by pinging the server IP.

Port monitoring to verify connectivity to the database(s) by pinging the SQL listener port.

Service monitoring to verify that SQL Server services are running.

Routine Database Administration

Hosted Solutions SQL server DBAs will provide routine database administration including:

Scheduled database maintenance tasks:

Full database backups

Transaction log backups

Database integrity checking

Update statistics

Defrag or rebuild indexes

Cycle the SQL Server error log

Database availability and monitoring

System resource utilization monitoring

Scheduled job failure notification

Event notification and escalation

Support for database recovery in event of system crash or other unforeseen circumstance

Installation of upgrades and patches to database engine