Executive Summary
SQLCare Provide completely customized remote database administration and monitoring:
- Proactive 24-hour server and SQL monitoring
- Reduce database administrative costs by 60%
- Microsoft Certified DBAs available 24x7x365
- Customizable monitoring adapting to customers needs.
- Significantly increase database stability, reliability, and performance
We don't replace existing resources, but we expand current DBA resources by providing services for:
- Complete database architecture and design and maintenance
- Database tuning and optimization
- Space management and database maintenance
- Backups and disaster recovery
- Replication, log shipping
- Clustering
- Security management
| Initial Assessment | |||
 |
SQL Configuration / Security | |
Backup Process |
|
Database Configuration | |
Database Maintenance |
| Strategizing | |||
|
Backup Strategy | |
Setup (customizable) Monitoring Process |
|
Database Maintenance Plan | |
Jobs and DTS Packages |
| Consulting / Support | |||
|
Remote DBA Consulting | |
Onsite DBA Consulting |
|
24/7 SQL Support | ||
| Monitoring Process 24/7 | |||
|
Database Status / Errors | |
Tables without indexes alert |
|
Database Fragmentation | |
Index corruption |
|
Data Corruption | |
Disk Space Alert if below 2GB |
|
Database Space utilization | |
Queries running over 3 minutes |
|
Backup Alerts | |
Queries running over 90 minutes |
|
Backup process verification | |
Blocking over ( 1/2 second) |
|
Transaction Log Status | |
Blocking over 3 minutes |
|
Server connectivity | |
Memory |
|
Error Log file | |
Disk IO |
|
Job Failed | |
Disk Queuing |
|
Security Violation | |
CPU Utilization |
|
Jobs running over 2 hours (new) | |
Script all Databases to file weekly |
|
Dead locks (new) | |
Script all Logins with encrypted password weekly |
| Weekly Statistical information (new) | |||
|
Performance Statistics (IO * Disk Queue * CPU * Memory) (new) | ||
|
Performance Statistics (SQL Cache * # of Users * Dead Locks) (new) | ||
|
Job(s) failed and the number of time failed (new) | ||
|
Top 10 longest running jobs (new) | ||
|
Top 10 worst performing queries or Stored Procedures (new) | ||
|
Top 10 longest running queries (new) | ||
|
Top 10 queries that are causing blocking (new) | ||
|
Database and Log file size history (new) | ||
| Weekly reports | Other Services (Setup charges apply) | ||
|
Server Report | |
Log Shipping |
|
Database Status Report | |
Replication / Mirroring / Snapshot |
|
Job Status Report | |
DTS Packages |