SQL Server Health Check & Service
Your business needs consistent and adequate performance from your mission critical SQL Server databases. Are you sure the data you rely on is safe and secure? Are your database backup and recovery systems fully operational? How well documented is your SQL Server and databases? Do you think your hardware should give you better performance? Are your users taking too long to carry out tasks because of poor database application responses?
Ecatenate can perform a SQL Server Health Check & Service to ensure your SQL Server databases are performing optimally. Our Health Check & Service can be carried out on-site or via VPN (Remote Desktop).
Why do I need a SQL Server Health Check & Service?
Peace of mind
Reassurance that your SQL Server databases are performing optimally. Comfort that you can recover your mission critical data after a disaster.
Return On Investment
Confidence that you are getting the best return for your investment in server hardware and software. For instance, rather than spending more money on server resources, could your databases be optimised to make better use of existing server resources?
Reduce problems that require time-consuming and costly technical support. Reduce user idle time due to poor database application responses with performance tuning.
Download our product datasheet
Every SQL Server installation is unique. We will adapt our investigation to your environment.
Our three-stage approach is to analyse, recommend and implement. After our analysis we will provide you with a comprehensive report with our recommendations and discuss them with you. Some of our recommendations may have implications for your applications. We will only implement the recommendations you are happy with.
As a guide, a typical health check would always include:
- An on-site visit or VPN (Remote Desktop) access
- Check server resources – memory, CPU, disk space
- Check server load for bottlenecks – memory, CPU, disk space, network
- Check SQL Server configuration options – memory, CPU, disk, torn page detection, auto close, recovery mode, data and log file growth settings
- Check latest service packs (operating system and SQL Server)
- Check appropriate back-up strategy exists
- Check SQL Agent for job failures
- Check scheduled back-up and maintenance jobs
- Run Microsoft’s Best Practice Analyser
- Run DBCC checks
- Check the SQL Server logs and Windows Event Log for errors
- Check SQL Server security strategy
- Check database and transaction logs sizes and shrink where relevant
- Check structure of application databases – normalisation, keys, referential integrity, data types
Recommend & Implement
- Recommendations Report
- Server configuration recommendations – memory, CPU, disk space, network
- SQL Server configuration improvements – memory, SQL Mail, CPU, disk, required services, configuration options
- Service packs (operating system and SQL Server)
- Database configuration improvements
- Database structure improvements – normalisation, keys, referential integrity, data types
- Database performance tuning