Analysis Services

AS2KSP4 unwelcome changes

As I’m sure you all now by now, AS2KSP4 has now been released and is available here:
http://www.microsoft.com/sql/downloads/2000/sp4.asp

One very unwelcome change is to the DSN Requested and DSN Used Perfmon counters, which are now practically useless. The values are now in scientific form (eg 1.3112e+012) which means that you can only see what levels your queries are hitting for the first five dimensions in your cube – which makes building aggregations manually (one of my favourite tricks for performance optimisation, detailed here) impossible. Grr! I noticed this a while ago and logged a bug in betaplace, but got no feedback. Double Grr!

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.