[5-day-delivery] SQL Server Health Check

Metadata

• 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.

Checklist Item(s)

• 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 a 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