I require a detailed report as to why SQL Server Windows NT 64 Bit will take up 100% CPU and how to fix it. What quires cause the issues, etc.
Things to know before you bid:
This is a SQL Express DB that is going to be moved to Azure.
The software is a POS system.
TeamViewer will be the software used to access the server.
I can replicate a spike in the CPU by performing a task that takes up to 30% CPU.
Ensure that the CPU consumption issue no longer exists once quires are fixed.
Update the DB on Azure with the new one.
Work will need to start at 9PM MST on Monday March 12th.
The fix will need to be implemented either the same day or March 13th between 8AM-9AM MST.
If you have an example report of the analysis you will provide this would be preferred.
Only bid if you are able to perform all the task above and perform the work during the specified times above.
15 freelancers are bidding on average $25/hour for this job
Vast experience in root causing the production database (both MS SQL Server and Oracle) issues related to application (SQL), configuration, environment, etc., and given the resolution.