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