Recently I had to use MDX Studio for some MDX query tuning. 2 quick tips:
Also very quickly, if you are finding that the Perfmon section in MDX Studio shows 0 for most values such as ‘Cells calculated’ then try running the MDXStudio.exe with the ‘Run as Administrator’ option.
Also take a look at Ashwani Roy’s SQL Bits session ‘Supercharge MDX performance using MDX Studio’ which is available from https://www.sqlbits.com/Sessions/Event6/supercharge_mdx_performance_using_mdx_studio
I’ve recently started learning about SQL Server Parallel Data Warehouse (PDW) appliance. In the course of learning, I came across some links and resources in connection with this appliance, which I will share in this blog post. I will keep it updated as much as possible.
Community blog posts:
I will continue to gather links and post them here as I come across them. In the meantime, I hope the above help you!
My colleague and friend, boB Taylor (the spelling is not a typo – please visit http://www.opsvault.com/meet-our-contributors and see why) has recently released a GUI tool which allows you to configure the XML files required for SQLDiag to capture specific types of events, counters etc.)
Download it from http://sdct.codeplex.com
Please review, test, blog about it and provide feedback as you see fit.
bOB blogs at OpsVault. His posts can be easily retrieved from http://www.opsvault.com/author/bobtay/
A long time ago, I had blogged about the perils of ‘wildcard’ query patterns. As a response to one of the comments in that post, I learnt about a new optimization introduced in SQL 2008 wherein the OPTION (RECOMPILE) hint would help in these kind of cases. Ever since then, I had used this in some customers; but recently, I found that on SQL 2008 R2 and even in SQL 2008 SP1, the behavior was not working correctly.
Recently, I found the reason for this issue from some other sites, and I also found the official name for this enhancement: Parameter Embedding Optimization. It turns out that, based on some bug reports, this optimization was disabled starting in SQL 2008 CU4 (and also disabled in SQL 2008 R2 RTM). The fixes for the issue are in SQL 2008 SP1 CU5 and SQL 2008 R2 CU5 respectively.
Here are the links which cover the details, and I hope they help you!
Later on I chanced upon an Internet Explorer setting which actually controls the final display. There is a security setting ‘Allow websites to open windows without address or status bar’:
This setting needs to be set to ‘Enable’ for the respective zone (such as Trusted sites etc.) for the address bar display to be suppressed.
Hope this hint helps!
My team, Premier Field Engineering (India) recently created a group on LinkedIn (http://www.linkedin.com/groups?gid=3761475&trk=hb_side_g) which we will use to share our experiences, upcoming offerings, career opportunities and more. Membership is open to all, so I welcome you to take this opportunity to connect with us!