June 21, 2017 at 11:23 am
I want to create a template for user connection count to CUBE. I tried the below query and I am getting the list of users and distinct user list, but not the count. any help will be appreciated.
SELECT * from $SYSTEM.DISCOVER_CONNECTIONS
SELECT DISTINCT connection_user_name from $SYSTEM.DISCOVER_CONNECTIONS
Thanks,
Tapas
June 21, 2017 at 3:52 pm
dm_tapas - Wednesday, June 21, 2017 11:23 AMI want to create a template for user connection count to CUBE. I tried the below query and I am getting the list of users and distinct user list, but not the count. any help will be appreciated.SELECT * from $SYSTEM.DISCOVER_CONNECTIONS
SELECT DISTINCT connection_user_name from $SYSTEM.DISCOVER_CONNECTIONS
Thanks,
Tapas
Those will just show connections and I don't think there is a way in MDX to get the count for those DMVs.
Not sure if this helps but to get connection counts, you'd generally want to Performance monitor - there are counters for such. You can also get Perf Mon counter values through Powershell as another option.
Sue
June 22, 2017 at 9:51 am
actually, I want built a Template to monitor the user connection count to the CUBE. so I can not use perfmon..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply