Browse by Tags

All Tags » mdx » sql server   (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...