[5-day-delivery] Troubleshoot SQL Server Performance

* Title: [5-day-delivery] Troubleshoot SQL Server Performance
* Category: 5-day-delivery
* Tag(s): SQL Server, Troubleshoot, Performance
* Description: You want to troubleshoot and fix SQL Server performance problems.


### Common Issue(s) ###
+ Query time-out errors
+ Blocking issues
+ A query that shows a significant performance difference between two servers
+ Slow SQL Server performance caused by I/O issues
+ High-CPU-usage issues in SQL Server
+ Slow queries that result from ASYNC_NETWORK_IO wait type
+ Memory-optimized tempdb metadata (HkTempDB) out of memory errors


### Management ###
+ Fixed-time: 5 working day(s)
+ Fixed-scope: 1 server
+ Fixed-price: $500


### Work Breakdown ###
+ Troubleshoot query time-out errors
+ Troubleshoot blocking issues
+ Troubleshoot a query that shows a significant performance difference between two servers
+ Troubleshoot slow SQL Server performance caused by I/O issues
+ Troubleshoot high-CPU-usage issues in SQL Server
+ Troubleshoot slow queries that result from ASYNC_NETWORK_IO wait type
+ Troubleshoot Memory-optimized tempdb metadata (HkTempDB) out of memory errors
+ Find root cause
+ Provide solution


### Out of Scope ###
+ The scope of this task is limited to troubleshooting only.
+ Some solutions might require planning for maintenance window and thus are out-of-scope for this task.


### Deliverable(s) ###
+ Recommendations
+ Query Level
+ Database Level
+ Server Level
+ Clarification call (up to 1 hour)


### Prerequisite(s) ###
+ Database server access
+ Screen sharing, if applicable