Browse by Tags

SQL Server 2008 Analysis Services performance guide - process to go over
27 November 08 10:34 AM | SQL Master | 2 Comments   
SQL Server 2008 is on full-fledge now and I haven't had a chance to look at Analysis Services part of it, recently had an opportunity to go through to convene a proof of concept project at work place. As the documentation refers this version of Analysis Read More...
SQL Server Analysis Services MDX Query performance monitoring - highlights
29 January 08 02:27 AM | SQL Master | 5 Comments   
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 Read More...
Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks
05 September 07 02:34 AM | SQL Master | 2 Comments   
Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries, Read More...
MDX query performance issues in SQL 2005 Analysis Services
06 May 07 03:20 AM | SQL Master | 0 Comments   
See the relevant KBA resources here: When you run an MDX query in SQL Server 2005 Analysis Services, the query takes longer to run than expected http://support.microsoft.com/?kbid=935995 An MDX query takes longer than you expect to finish in SQL Server Read More...
Filed under: , ,

Search

Go

This Blog

«January 2009»
SMTWTFS
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567

Syndication