Database Audit and Health Check

Your business relies on consistent and accurate performance from your SQL Server database. Your SQL Server may seem to be doing its job, but are you sure it's running optimally? Is your data secure with fully operational backup and recovery systems? Do you have critical SQL Server issues but no resources to address them? How well documented is your system? These are questions that can be answered with a full audit or the smaller health check.

• Analysis. Detailed review of your SQL Server systems and logs to determine the needs for optimal performance
• Documentation. Deliver environmental information for historical and recovery purposes
• Backups. Verify backups are performing properly and test restorations
• Best Practices. Configurations, design, development, management, code reviews, etc
• Administration. SQL Server operations and management that support overall business goals
• Analysis Services. Modeling, DTS and Cube development for critical business questions
• Development. From data modeling to object validation for security and optimization
• Upgrades. Recommend and apply needed Service Packs, Hot Fixes and system updates
• Maintenance. Recommend and execute index builds and database consistency checks
• Security. Recommendations to improve security based on the latest vulnerabilities
• Monitoring. Review all SQL Server, application and Windows logs
• Performance Tuning. Provide recommendations for performance improvements
• Change Management. Ensure the process and documentation are current
• Disaster Recovery. Verify a recovery plan is in place
• Capacity Planning. Recommendations for storage, CPU and memory storage