DRAG DROP
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project
deployment model.
You need to monitor control flow tasks to determine whether any of them are running longer
than usual.
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.)
Answer: See the explanation
Explanation:
Box 1: Connect to the SSISDB database.
Box 2:
Box 3: Execute the query
Note:
* execution_component_phases
Displays the time spent by a data flow component in each execution phase.
* The following example uses the catalog.execution_component_phases view to find the
total amount of time that a specific package has spent executing in all phases (active_time),
and the total elapsed time for the package (total_time).
Use SSISDB
Select package_name, task_name, subcomponent_name, execution_path,
SUM(DATEDIFF(ms,start_time,end_time)) as active_time,
DATEDIFF(ms,min(start_time), max(end_time)) as total_time
From catalog.execution_component_phases
Where execution_id = 1841
Group by package_name, task_name, subcomponent_name, execution_path
Order by package_name, task_name, subcomponent_name, execution_path
* catalog.executables
This view displays a row for each executable in the specified execution.
An executable is a task or container that you add to the control flow of a package.
*(incorrect) catalog.executions (SSISDB Database)Displays the instances of package execution in the Integration Services catalog. Packages
that are executed with the Execute Package task run in the same instance of execution as
the parent package.
This view displays a row for each instance of execution in the catalog.
* (incorrect) catalog.operation_messages
Displays messages that are logged during operations in the Integration Services catalog.
This view displays a row for each message that is logged during an operation in the catalog.
The message can be generated by the server, by the package execution process, or by the
execution engine.catalog.execution_component_phases
catalog.executables
I think that on box 3 is:
Box 3: …execution_component_phases…catalog.executions view
0
0