question

rajsinha avatar image
rajsinha asked

Sql Server 2012 Integration Services Catalog views - cpu usage history

Hi, I am new to SQL Server 2012. I have deployed and executed a SSIS package on the Integration Services catalog. Now, to analyze the performance of the executed package I wish to query the SSISDB catalog views to retrieve the cpu & memory usage history. Please let me know in which catalog view/table I can find this info. There is a column named "**Process_Id**" in the "**catalog.operations**" table. Can we tie this id to the Sql Server pid/kid and then retrieve the cpu usage history ? ** I am using Sql Server 2012 ** Thanks
sql-server-2012sql server 2012ssis2012
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
H_G_H avatar image
H_G_H answered
Hi : you might have to create custom task where you can join DMV view to gather CPU and IO usage for SSIS . dm_exec_Sessions or dm_exec_requests or sys.processes may help to start with. Good luck
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.