Browse categories
Explore
Fiverr Pro
English
$
USD
I will check and fix health of microsoft sql server instance
Vetted by Fiverr Pro
Aasim A was selected by the Fiverr Pro team for their expertise.
Vetted for
Databases
About this Gig
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***
Database type:
Relational database
Other Databases Services I Offer
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.
