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
Last activity: Aug 21, 2024, 07:23 PM