I will help to tune the performance of your sql server database service

Ireland

I speak English, Spanish, Portuguese

1 order completed

Senior SQL Server DBA

Senior SQL Server DBA with more than 20 years of experience. Deployment of SQL Server environments on premises and Azure. Performance tuning. Health check of best and recommended SQL Server database p...
About this Gig

Analyse the root cause of a database performance degradation


If necessary, implement some tools to facilitate the analysis.


Once identified the root cause, there could be a wide variety of corrective actions.


Tuning the code is one usual that takes time to achieve and test and requires interaction with developers.


Other corrective actions may need interaction with other teams related to networks, windows, storage or database administration


Once corrective actions are implemented, it is necessary to allow some days to collect new performance metrics and confirm the actions, rollback the actions or add new ones.


Performance tuning is a continuous work, but this gig can be limited to some steps if needed and then I can provide advice.


This is why estimated time and cost of the gig is only an estimation and that could be agreed later with the progress of any work.


Expertise:

Administrator

Configuration

Performance monitoring

Database type:

Relational database