[5-day-delivery] SQL Server Health Check

Title: [5-day-delivery] SQL Server Health Check
Category: 5-day-delivery
Tag(s): SQL Server, Troubleshoot, Health Check, Performance
Description: You want a thorough SQL Server Health Check.
+ SQL Server Logs
+ Application Events
+ System Events
+ General
+ CPU
+ I/O
+ Memory


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


### Work Breakdown ###
+ Day 1: Data collection (online, supervised)
+ Day 2 and 3: Analysis and report compilation (offline)
+ Day 4 or 5: Clarification call


### 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) ###
+ Performance monitor snapshots (I/O, memory, CPU etc)
+ Summary reports
+ SQL Server bottleneck analysis
+ Resource wait statistics
+ Blocking chain
+ Top expensive queries
+ Missing indexes
+ Raw observations
+ Recommendations
+ Query Level
+ Database Level
+ Server Level
+ Clarification call (up to 1 hour)


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