Two handy papers on common database performance considerations

  • Article

Len posted recently the link to the new Analysis Services performance guide. If you also care about SQL Server engine performance, these two papers are worth a quick read:

  • Troubleshooting Performance Problems in SQL Server 2005, which takes you through steps for identifying and resolving typical database performance problems.
  • Physical Database Storage Design, explores considerations that should be weighed when mapping logical database designs to available physical storage. Drive capacity continues to grow by leaps and bounds but I/O channel rates and disk latency have grown much more slowly, so this is a topic that's not likely to go away for DBAs any time soon.

Enjoy!

-David