Sample Header Ad - 728x90

DMV CONNECTION_HOST_APPLICATION field is NULL

0 votes
1 answer
116 views
I am trying to monitor cubes and expressions of Analysis Services using DMV queries that are stored on Server's RAM. I found many useful information about connections on connection's table of SSMS's DMVS rowser using the following mdx statement. SELECT * FROM $SYSTEM.DISCOVER_CONNECTIONS The problem is that the [CONNECTION_HOST_APPLICATION] field of connection's table is not recorded and contains null values for my client application. > CONNECTION_HOST_APPLICATION specifies "The name of the machine that initiated the connection". As a result i can not filter the rows that are generated from my client tool to analyse only them. So how can i modify my client tool in order to register this field?
Asked by Stavros Koureas (170 rep)
Nov 24, 2016, 02:08 PM
Last activity: Aug 21, 2024, 07:23 PM