Browse by Tags

• Analysis Services
• baseline
• benchmarking
• best practices
• mdx
• query
• resources
• sql server
• tsql

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...

Filed under: sql server, performance, mdx, Analysis Services, monitoring, resources

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...

Filed under: sql server, performance, mdx, Analysis Services, best practices, query, tsql, baseline, benchmarking, monitoring