SQL Server Analysis Services Activity Viewer 2012 Beta Released

(Worth noting that there is a more recent version available here!)

Hi all, yesterday morning I created a project based on an old blog post Upgrade Analysis Services Activity Viewer 2008 to SQL Server 2012. Over the course of the day I made a few changes that I wanted to see myself and this afternoon I have released a beta version, SQL Server Analysis Services Activity Viewer 2012, or SSASAV 2012 for short.

Release Notes

  • Straightened up the UI
  • Current queries list refreshed after query is cancelled; sometimes it takes longer for the query to cancel than the refresh to occur, so will sometimes stay on UI. Will fix in update.
  • Right click the COMMAND TEXT cell allows you to copy the COMMAND TEXT to clipboard, so that you can copy and paste command to text documents or xmla /mdx windows to execute as reading long list can be awkward
  • Added SESSION_LAST_COMMAND from $system.DISCOVER_SESSIONS DMV to Dormant Query Panel
  • Added Copy SESSION_LAST_COMMAND to Dormant Query Panel
  • Disabled Cancel/Refresh buttons on Dormant Query Panel and Current Query Panel when user has clicked refresh.
  • Updated icon

Known Issue
When query is especially long, cancelling query will cause text in COMMAND TEXT to corrupt. Hit refresh to clear.

Feedback here or on the Codeplex site is very much appreciated.

There is a stable version, SSASAV 2012 1.0

SSASAV 2012 is Looking for Volunteeers

I’ve got a few more ideas to add to the project, but if you have any ideas, or want to be a developer on the project, let me know and I’ll gladly consider adding you.  I’m not looking for l33t devs here;  anyone who has a few ideas and isn’t afraid to do a bit of Googling/Binging/Yahooing to get it done is more than welcome to contribute. Latest source code can be downloaded from:


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.

2 thoughts on “SQL Server Analysis Services Activity Viewer 2012 Beta Released”

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