[5-day-delivery] Troubleshoot SQL Server Performance

Metadata

• 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 ASYNCNETWORKIO 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 ASYNCNETWORKIO wait type
• Troubleshoot Memory-optimized tempdb metadata (HkTempDB) out of memory errors
• Find the root cause
• Provide solution

Out of Scope

• The scope of this task is limited to troubleshooting only.
• Some solutions might require planning for a 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