Sample Header Ad - 728x90

Is Analysis Services DMV query executing "on server" or "on database"

3 votes
1 answer
217 views
I am doing some DMV queries on SQL Server Analysis Service, like SELECT * FROM $system.DISCOVER_SESSIONS. This query will return data for all databases on the server, so it's not really database-specific. When I connect to the server through AdomdConnection , I don't specify the database/catalog in the connection string, and the query still works. However I noticed that a database is always associated with this connection, and it's usually the first database on the list of available ones on the server. My question is - do these kind of queries actually burden the database in question, i.e., if for whatever reason we would have many DMV queries that check the server sessions, do they all query the automatically-chosen first database on the list, and therefore impact (performance-wise) any users who might actually do "real" queries on this database? - Or is this kind of DMV query just impacting the server itself, not in any way the database and therefore the performance impact is the same no matter which database is chosen? **Possibly a shorter way of phrasing it would be:** are performance impacts of a DMV query server-related or database-related?
Asked by PajLe (133 rep)
Apr 25, 2024, 05:30 PM
Last activity: Apr 26, 2024, 07:09 AM