Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

AS2KSP4 unwelcome changes

leave a comment »

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!

Written by Chris Webb

May 9, 2005 at 1:09 pm

Posted in Analysis Services

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,081 other followers

%d bloggers like this: