Some useful posts\white papers that you can't miss if you're looking on how to increase or troubleshoot performances of Analysis and Reporting server: Analysis Services Processing Best Practices http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx#Profile
Read More...
SQL Server 2005 introduced dynamic management views (DMV) and functions (DMF) , a mechanism to allow you to look at the internal workings of SQL Server using TSQL. They allow you an easy method for monitoring what SQL Server is doing and how it is performing.
Read More...
Just a quick update on the next webcasts available for SQL Server 2005 (and Sharepoint Services v3)! SQL Server 2005 SP2 Tools and Improvements (Level 200) Event Overview: In this webcast, we discuss the broad range of tools available for Microsoft SQL
Read More...