I will check and fix health of microsoft sql server instance
Revisado por el equipo de Fiverr Pro
El equipo de Fiverr Pro seleccionó a Aasim A por su experiencia.
Revisado para
Bases de datos
Acerca de este Servicio
Vetted Pro
Are your SQL Server configurations and resources enough for your workload? SQL Server is a costly box but needs expert DBA to configure according to hardware and query load. I will help your SQL Server instance to reduce hardware resources and perform better. I will perform:
- Server/Instance Level Configuration Check
- I/O distribution Analysis
- SQL Server Resource Wait Stats Analysis
- TempDB Review
- Database Files (MDF, NDF) and Log File Inspection
- Log Reviews (Event Logs,Error Logs)
- DBCC Best Practices Implementations
- Index Analysis & Optimization
There are all sorts of smart cookies who could potentially help you with this project. So why work with me? Here are several reasons that I trust you will find compelling:
- 13 years of in-hand experience
- Recognized by Microsoft as Most Valuable Professional in 2014-2015
- Handled up to 35TB SQL Server Database on a single server
- Handled up to 200 million batch request in 10 production hours
***100% money-back guarantee, if found unsatisfied***
Tipo de base de datos:
Base de datos relacional
Otros servicios de Bases de datos que ofrezco
FAQ
Please describe your experience with MS SQL Server environments:
I am an SQL Server DBA with 13+ years of in-hand experience. Worked with SQL Server 2000 to 2019. The biggest database (in size) of my life was 4TB and the largest transaction load I had handled was 200 million transactions in 10 working hours.
Please describe you prior experience with Production / On-call support?
A DBA can only work better if he works proactively. Besides this, most of the client calls are regarding performance issues. TempDB, missing indexes, out-dated statistics, improper hardware, table design, and query structure are the main issues. Recent: Performance degradation after moving to 2016+.
Availability for Production / On-call rotations according to EST ?
7:00AM to 12PM EST is the perfect time for me.
How fix will be provided ?
If a fix is related to a stored procedure or script, it is highly recommended that it should not be deployed directly on the production server. Proper QA is a must for these kinds of changes. Configuration issue fixes are made directly on servers.

