November 17, 2009 at 9:00 am
Hello,
Are there any queries or DMV's to see what's running currently on SSAS?
Like we do sp_who2 or any of the DMV's on SQL SERVER.
Typicall questions i get is ..
We are running something from the front end(App) which creates dimension or sometimes analysis databases and when it comes to one of those steps it get stuck there...and they ask to see if everything is normal...or
I dont see anything on the sqlserver except some processes in sleeping or suspended state...
Thanks In Advance!
November 17, 2009 at 9:23 am
Starting from SQL 2005, SQL Server Profiler has the ability to trace what's currently running on the SSAS.
I recommend using the profiler to begin with.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 18, 2009 at 3:10 am
Have a look at "OLAP Heartbeat" - gives you a really cool graphical interface that shows the OLAP processes that are running.
November 18, 2009 at 5:41 am
happycat59 (11/18/2009)
Have a look at "OLAP Heartbeat" - gives you a really cool graphical interface that shows the OLAP processes that are running.
Is it a thrid party tool? Any idea how much does it cost?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 19, 2009 at 3:51 am
OLAP Heartbeat is currently a free third party tool. There are plenty of hits of Google.
You can download from http://www.sqlsolutions.com/products/olapheartbeat/index.html
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply