Freigeben über

Two handy papers on common database performance considerations

  • Artikel

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

Comments

  • Anonymous
    May 10, 2015
    Good