[5-day-delivery] Troubleshoot SQL Server Performance
Delivery in
7 days
- Views 673
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
* 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
* 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
What the Freelancer needs to start the work
+ Database server access
+ Screen sharing, if applicable
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies