Upgrade Analysis Services Activity Viewer 2008 to SQL Server 2012

Update: I have uploaded the changes to my own Codeplex project. Now you can run the Activity Viewer on a box that only has SSAS 2012 installed.

https://asactivityviewer2012.codeplex.com/

Hey folks, it’s been a massively busy week post-release, but I thought I’d share a tip on upgrading the Activity Viewer to 2012. First, a bit of background:

Activity Viewer, or Analysis Services Activity Viewer 2008 to give it its full name,  is a solution available to download on the Codeplex website.

http://asactivityviewer2008.codeplex.com/

It’s a super-useful tool that “serves as an improvement to the limited functionality of the Activity Monitor in SQL Server 2005 Analysis Services. It was created as an intern project for the Summer 2008, and we hope that others add the features we did not have time to implement.” These features still haven’t found there way into SSMS, and so we still used this tool when we were on SQL Server 2008. However, once we moved over to SQL Server 2012, we were unable to connect to the SSAS instance.

Could not load file or assembly ‘Microsoft.AnalysisServices.AdomdClient, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.

The issue here is that the project references 2008  Microsoft.AnalysisServices and Microsoft.AnalysisServices.AdomdClient dlls, so unless you have SSAS 2008 installed on the server you are trying to connect to (and in the GAC I assume) when you try to connect to a 2012 SSAS instance it will fail.

cannotConnect

So the simplest thing to do here is update the references in Visual Studio to 2012 ( note the path of the dll I am referencing, it is in the “100 directory, which implies SQL Server 2008) “).

oldActivityViewer

Then you are able to connect to a SSAS box that does not have 2008 installed. Note that on the picture below that in the path of the dll I am referencing I am going to “110” and not “100”

UpdateReferences

Whilst you have the solution open if you open the “NewInstanceForm.cs” you can also improve the UI by moving the boxes around.

tidyUI

If you’ve not used this tool I highly recommend it as it really helps you to monitor the activity on a SSAS box.

Author: Richie Lee

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

6 thoughts on “Upgrade Analysis Services Activity Viewer 2008 to SQL Server 2012”

    1. Hi John,

      thanks for the link. Having viewed and downloaded that project I see that not a lot has changed from my suggestions above. Sure some colours have been altered and a couple of buttons that, upon inspecting the source code, don’t appear to do anything have been added. And also the Microsoft SQL Server logo has been replaced with the SOLID BI logo.

      To be fair though, what is helpful is that this codeplex project removes the need from other people having to download the Activity Viewer 2008 and a copy of Visual Studio and upgrade the solution themselves. So in the interest of fairness I have created my own project with my fixes in place as detailed above and kept all the other original logos and colours. It willl be made public in the next day or so. This is so that (as of the date of writing this comment) there is no illusion that SolidBI have created anything other than what was blogged above, other than changing some colours and a logo, and add some buttons whose features are going to be in a later release ( I assume, otherwise why add the buttons?).

      I will continue to monitor the version you provided a link to above and will monitor any updates made with great interest as the features offered by those buttons do seem to be genuinely helpful.

  1. Hi Richie.
    My compliments for this very useful program.
    I have a question …
    In tab CURRENT QUERIES there is a column named ‘SESSION SSPID’ …
    How can i know exactly user behind this pid ???
    Regards in advance.

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