10 Performance Secrets for SQL Server Developers

Michael K. Campbell highlights 10 common performance problems to avoid in the latest edition of SQL Server Magazine:
  1. Failure to Properly Configure AWE (Address Windowing Extensions) Memory Usage by not enabling SQL Server to use more than 2GB of RAM.
  2. Failure to Normalize
  3. Failure to Use Clustered Indexes
  4. Failure to Optimize by ignoring the impact of statistics, indexes etc
  5. Failure to Create SARGable Queries (SARG - Search ARGument)
  6. Wasted Network Bandwidth due to SQL Server's chatty behavior
  7. Improper Use of Cursors
  8. Failure to Use Full-Text Indexing where SARGable queries aren’t possible
  9. Failure to Use Multiple Data Files. Microsoft recommends a ratio of roughly 0.25 to 1 data file per file group per processor.
  10. Failure to Properly Size Data Types

Comments