October 31, 2016 at 2:01 pm
Hello, what is the best way to see any users and/or current/active connections to a SSAS Cube? Or, if not there, to the SSAS server, to be able to see if any users are currently accessing the server or Cubes?
I'm hoping to find a way to determine, and disconnect if need be, before I deploy SSIS and SSAS packages on a given Cube and kick off a new run. I'll be running at the end of the user time-frame window, just don't want to cut someone off in mid-step.
Thanks, JPQ
October 31, 2016 at 2:17 pm
quinn.jay (10/31/2016)
Hello, what is the best way to see any users and/or current/active connections to a SSAS Cube? Or, if not there, to the SSAS server, to be able to see if any users are currently accessing the server or Cubes?I'm hoping to find a way to determine, and disconnect if need be, before I deploy SSIS and SSAS packages on a given Cube and kick off a new run. I'll be running at the end of the user time-frame window, just don't want to cut someone off in mid-step.
Thanks, JPQ
One way is to use the DMV queries for SSAS, particularly the discover_object_activity and discover_sessions queries. You can find more information, examples in the following:
Use Dynamic Management Views (DMVs) to Monitor Analysis Services
https://msdn.microsoft.com/en-us/library/hh230820.aspx
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply