SQL Server Health Check & Service
Download Product Datasheet
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.
Interested? Contact us to discuss your requirements and we will give you a fixed-price quotation.
Every SQL Server installation is unqiue. 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:
AnalyseAn 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 & ImplementRecommendations 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