How to trace all DB requests
Hi, I want to trace All DB (MS Sql server) requests that will be triggered when i execute an SSIS package. Any Idea how to do that? I want to do it in client side where i execute the package not at the DB server side. Suppose I execute 10 packages, I should able to figure out which call made by which package. What i mean by DB request is any table/function/SP requests. Please remember to mark the replies as answers if they help and unmark them if they provide no help. http://dotnetblogs-renjith.blogspot.com/
October 19th, 2012 1:54pm

Open your SQL Profiler, add proper filters (*) then launch your packages. SQL Profiler won't show package name, but at least you'll have the information you need. (*) I'd add the following filters Database Name = the ones affected by your SSIS packages Login name = your own login (if your package runs under Windows Authentication) or the corresponding SQL user (if it runs with SQL credentials) Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2012 2:39pm

Open your SQL Profiler, add proper filters (*) then launch your packages. SQL Profiler won't show package name, but at least you'll have the information you need. (*) I'd add the following filters Database Name = the ones affected by your SSIS packages Login name = your own login (if your package runs under Windows Authentication) or the corresponding SQL user (if it runs with SQL credentials) Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu Renjith wants to do it from SSIS end, Not DB end. Any suggestions?Rajkumar
October 19th, 2012 2:55pm

Profiler runs from client tooSebastian Sajaroff Senior DBA Pharmacies Jean Coutu
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2012 2:55pm

I will go with Sebastian Create new login for SSIS packageConfig to run all SSIS package by new user create for SSISnow run profiler to monitor all activities of SSIS package performing by new login Regards, Rohit Garg (My Blog) This posting is provided with no warranties and confers no rights. Please remember to click Mark as Answerand Vote as Helpfulon posts that help you. This can be beneficial to other community members reading the thread.
October 19th, 2012 3:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics