You administer a SQL Server Analysis Services (SSAS) instance.
You need to capture a continuous log of detailed event and subevent durations and custom trace events from queries executed in the SSAS instance.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:
Correct Answer:
Explanation/Reference:
Box 1: Write an XMLA script to log the extended events of the trace.
Box 2: Launch SQL Server Management Studio and connect to the instance.
Box 3: Execute the script.
Note:
* Auditing an instance of SQL Server or a SQL Server database involves tracking and logging events that occur on the system. The SQL Server Audit object collects a single instance of serveror database-level actions and groups of actions to monitor. The audit is at the SQL Server instance level. You can have multiple audits per SQL Server instance. The Server Audit Specification object belongs to an audit. You can create one server audit specification per audit, because both are created at the SQL Server instance scope.
* Trace events can be started and captured using SQL Server Profiler, , or can be started from an XMLA command as SQL Server Extended Events and later analyzed.
* Extended Event tracing is enabled using a similar XMLA create object script.
Reference: Analysis Services Trace Events