Browse by Tags

All Tags » mdx   (RSS)
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...
"Provider cannot be found" error when trying to run a MDX query?
05 November 07 01:39 AM | SQL Master | 2 Comments   
One of the Business user asked for the resolution for the error they are getting when running a MDX query against the Analysis Services database within their data mart. The error is "Provider Cannot be found", before going further on this error ensure 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...
Analysis Services 2000 & 2005 on same server?
10 May 07 01:39 AM | SQL Master | 0 Comments   
Can we handle SQL Server Analysis Services 2000 and 2005 versions on the same server? Yes it is possible, but in the real sense you have to more careful to attain the performance by having a high-end specificiation hardware to cope up the pressure. Theoritically 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: , ,