DRAG DROP
You have a business intelligence (BI) infrastructure that contains three servers. The servers
are configured as shown in the following table.
You need to recommend a health monitoring solution for the BI infrastructure.
The solution must meet the following requirements:
Monitor the status of the Usage Data Collection feature.
Monitor the number of end-users accessing the solution.
Monitor the amount of cache used when the users query data.
Which health monitoring solution should you recommend using on each server? To answer,
drag the appropriate monitoring solutions to the correct servers. Each monitoring solution
may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content.
Answer: See the explanation
Explanation:
Box 1: PowerPivot server health rules
Box 2:Dynamic management views
Box 3: PowerPivot server health rules
1. Web Service Performance Object
2. PowerPivot server health rules
3. Dynamic Management views
please provide reasons why you says so
1. PowerPivot server health rules
2. PowerPivot server health rules
3. Dynamic Management views
You can’t use DMV’s on 3 because its not a database server. Dynamic Management Views are SQL views, they need SQL Server engine to be queried
To Monitor the number of users accessing the solution. I would use a DMV. eg.
SQL 2014:
SELECT DB_NAME(eS.database_id) AS the_database,eS.is_user_process
, COUNT(eS.session_id) AStotal_database_connections
FROM sys.dm_exec_sessions eS
GROUP BY DB_NAME(eS.database_id)
, eS.is_user_process
ORDER BY 1, 2;
PRE SQL 2014:
SELECT DB_NAME(ST.dbid) AS the_database
, COUNT(eC.connection_id) AS total_database_connections
FROM sys.dm_exec_connections eC
CROSS APPLY sys.dm_exec_sql_text (eC.most_recent_sql_handle) ST
LEFT JOIN sys.dm_exec_sessions eS
ON eC.most_recent_session_id = eS.session_id
GROUP BY DB_NAME(ST.dbid)
ORDER BY 1;
To Monitor the status of the Usage Data Collection feature:
Usage Data Collection is a farm level SharePoint feature. Just make sure its turned on and make sure the farm administrator enable usage logging. That’s why one of your answer is PowerPivot Health Rules