[5-day-delivery] Troubleshoot ETL on SQL Server

* Title: [5-day-delivery] Troubleshoot ETL on SQL Server
* Category: 5-day-delivery
* Tag(s): SQL Server, Troubleshoot, Performance, SSIS, ETL
* Description: You want to troubleshoot and fix slow query performance in SSIS or ETL jobs.


### Common Issue(s) ###
+ ETL job was faster before and slower now
+ Can't complete complex query


### Management ###
+ Fixed-time: 5 working day(s)
+ Fixed-scope: 1 ETL job (1-10 SQL queries)
+ Fixed-price: $500


### Work Breakdown ###
+ Troubleshoot complex query
+ Troubleshoot insert statement performance
+ Troubleshoot delete statement performance
+ 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.
+ If the bottleneck isn't on the SQL server, it's out-of-scope.


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


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