Training Syllabus
NCSQL007 - SQL Server 2008 Query Performance Tuning

Durasi : 5 hari

  • SQL Query Performance Tuning
  • System Performance Analysis
  • SQL Query Performance Analysis
  • Index Analysis
  • Database Engine Tuning Advisor
  • Bookmark Lookup Analysis
  • Statistics Analysis
  • Fragmentation Analysis
  • Execution Plan Cache Analysis
  • Stored Procedure Recompilation
  • Query Design Analysis
  • Blocking Analysis
  • Deadlock Analysis
  • Cursor Cost Analysis
  • Database Workload Optimization
  • SQL Server Optimization Checklist