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