The Performance-Tuning ProcessThe Core ProcessIterating the ProcessPerformance vs. PricePerformance Targets"Good Enough" TuningPerformance BaselineWhere to Focus EffortsSQL Server Performance KillersPoor IndexingInaccurate StatisticsExcessive Blocking and DeadlocksNon-Set-Based OperationsPoor Query DesignPoor Database DesignExcessive FragmentationNonreusable Execution PlansPoor Execution PlansFrequent Recompilation of Execution PlansImproper Use of CursorsImproper Configuration of the Database LogExcessive Use or Improper Configuration of tempdbSummary