You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.
Through utilizing SQL Profiler, you decide to troubleshoot search function.
You should make sure that it will cost a lot of time to query.
Which is the correct answer?
A.
You should utilize store procedure.
B.
You should utilize Query Subcube
C.
You should utilize a Dynamic Management View (DMV)
D.
You should utilize Transactions Log.
Explanation:
The server raises the Query Begin event when it receives an MDX query and the Query End event when it has finished executing the query. The Query Subcube event shows which attributes the server used to satisfy the query. When configuring the trace, you can check the Query Subcube Verbose event to see these attributes in a human-readable format.