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
