The SQL Server database tuning service will perform a review and adjustment of the platform configuration. These works and studies are carried out with the help of the client’s personnel, to review the current problems.
SQL Server tuning service
Likewise, configuration/parameterization solutions aimed at a better use of the resources allocated to the database environment may be proposed. Database server maintenance policies and the application of the manufacturer’s best practices will be considered. A detailed study of the problems of the specific instance is also carried out, offering customized solutions on the performance of the environment, studying performance problems.
After the analysis work has been carried out, and as a final objective, a report will be presented containing an overview of the status, as well as a set of recommendations and possible plans for tuning your SQL Server platform. The recommendations distinguish between immediate actions (parameter change) and others that can be carried out in the medium/long term (code changes, etc.). The points can be performed by the customer or with our assistance, always aimed at a better use of the environment and to obtain an optimal performance of the infrastructure.
Review points to be considered in SQL server tuning:
- Analysis of the architecture and current situation of the server.
- General performance recommendations, parameterization and, if applicable, environment version update, patching…
- Creation of maintenance plans.
- Review of the most expensive queries and possible new indexes in the application.
- Activation of an audit job to capture application crashes and improvement plans.
- Review of the use of the linked servers already created and possible replication solutions to avoid sending data between servers.
- Use of operating system resources (memory, disk, etc.) by the manager and their optimization.
- Report with the conclusions obtained and plan of action for the resolution of the problems.
You can see some of our projects in the references and technical solvency page. If you have doubts about the type of formula you need, ask us, we will be happy to advise you, we also offer SQL server database support and maintenance services that may be of interest to you.