When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve performance. So similar to Relational database engine...
Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings. There are pre-defined list of SQL Server 2005 recommendations...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
01-25-2008
Filed under: sql server, microsoft, download, best practices, 2008, ctp, analyzer, 2005, Analysis Services, extent, rtm