SQL Server Performance Tuning Tips

避免遇到以下的 SQL Server Performance 殺手

•     Poor Indexing
•     Inaccurate Statistics
•     Excessive Blocking and Deadlocks
•     Non-Set-Based Operations
•     Poor Query Design
•     Poor Database Design
•     Excessive Fragmentation
•     Nonreusable Execution Plans
•     Poor Execution Plans
•     Frequent Recompilation of Execution Plans
•     Improper Use of Cursors
•     Improper Configuration of the Database Log
•     Excessive Use or Improper Configuration of tempdb