sql server dts: How long can I run the profiler to get trace from the production server. It
should not degrade the server performance. what is the minimum time to run
the sql profiler to caputure all queries in the trace

[quoted text, click to view]


The length of time depends on your business logic, etc. If you
understand the business processes involved at the database level, you
should be able to ballpark it. It is different for different business
logic. I disagree w/the degradation of performance during the trace
process. This process actually does degrade the normal level of
database performance and virtual memory on the machine that is running
Profiler during the trace process. In terms of capturing current
queries in the trace, once you select stop it queues up the remaining
queries until it displays the remaining ones. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant