Trace : Loggin of sql statements for dts package | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Trace : Loggin of sql statements for dts package

<br />Hi,<br /><br />As I don’t have sysadmin rights, I am not able to run profiler.<br /><br />But, I have to ask the production support to run the profiler to <br />see how much time each stored procedure and SQL statements inside the<br />stored procedure runs.<br /><br />As it is production server, we cannot do trial and error and we don’t have<br />any other servers to test.<br /><br />All stored procedures are run under DTS package.<br /><br />If I ask the support to include SQL<img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />tmt stared,stmt completed with duration, will<br />it capture the events?<br /><br />One of my friend told me that we cannot capture individual events triggered thro DTS.<br /><br />Thanks for any help<br /><br /><br />
Do not risk the server’s performance by running GUI tool and you can accomplish the task (by your production support) by referring tohttp://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm link on running server side trace. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks sathya, Is it true that we cannot caputure individual sql events if
triggered thro DTS?
Why to use DTS for capturing?
I haven’t heard such process to capture events using DTS. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
I think, I am not clear in my question. All the stored procedures are invoked thro’ DTS packages.
Now I want to capture the timings of these stored procs and sql’s inside the SPs.
I heard that, If we set up the trace through SQL PROFILER, we can get only the start and end time
of the dts package as whole and not individual sps invoked by DTS. I am not sure about this statement. Is it true?

You can get all the information from trace provided you’re capturing required events, do not use the templates under PROFILER, take time to read books online and referred link for more information. THe trace will mark the procedure and process invoked that SP. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>