Webcast: Avoid Slow SSAS Queries: MDX Query Troubleshooting
Do you have SSAS queries that you feel should be faster? Multidimensional Expressions, or MDX, is the language used to work with Analysis Services. Similar to SQL for the relational engine, MDX is a language for queries and DDL statements on multidimensional cubes in Analysis Services. Troubleshooting slow MDX queries is often challenging because the level of support provided by the tools and the Analysis Services engine is not as mature as that found in the relational engine. This session covers the methods for examining slow queries using the SQL Profiler and Performance Monitor to determine the need for aggregations, caching problems, memory constraints, and so forth. Best practices for optimizing MDX will be examined, and various server properties will be discussed as necessary to help correct query issues. Attendees will leave armed with a practical approach to locating bottlenecks and strategies for speeding up queries.
> Register Now
> Live date: 4/28/2010 at 12:00 Pacific
What Is Your Favorite Script?
Re-running this notice due to a formatting issue yesterday – sorry about that!
I’ve been spending a lot of time lately going back through old scripts and tossing stuff that doesn’t apply as much any more with new releases of SQL Server (or just aren’t as applicable) and looking for more killer scripts to get out to everyone. I thought I’d put out a call for scripts, but wanted to make it interesting too.
So, here’s the deal.
For every script you post to the library, I’ll activate or extend your account by a month (yes, for each one submitted, so submit early and often). Just add your script to the script library, then send me a quick note and let me know when it’s done. Please make sure you put in the description so everyone knows what it does.
Then, from those submitted, we’ll pick a best-of script. That best-of script will receive both a 1 year membership on SSWUG and a 1 year (2-conferences!) pass to our Virtual Conferences. Not a bad deal!
Get those scripts submitted, and if you’re not yet a member, just drop us a note – we’ll activate your account for a few days so you can post and then of course from there you’ll have an active account from the scripts you post!
Here’s a link to the script libary…
We’ll run this contest for the next 10 days (ending Friday April 30 at midnight).
Can’t wait to see your favorites! We’ll post the contest winner’s names here to let everyone know you’re famous!
Featured Script
GetSPTrigValues
This stored procedure can be used to return the names of each view, rule, default, trigger, CHECK constraint, DEFAULT constr… (read more)