Safe to run SQL Profiler and SQL Monitor Trace concurrently?

joshuawferguson

Hello everyone,

I'm looking into running a SQL Profiler trace over the weekend (collecting the TSQL text), but I'd also like to also correlate some of that data using SQL Monitor Trace. Is it safe to run them both at the same time?

The SQL Monitor Trace docs say that Monitor Trace reads from the same logs that SQL Profiler does. This suggests to me that it should be safe to run them both at the same time. Is this so?

Thanks for any advice.

Brian Donahue

Hello,

As far as I am aware traces are run in individual sessions on SQL Server, so shouldn't interfere with each other. The only thing to worry about would be the performance hit of running two traces.

joshuawferguson

Thanks for the reply. I'm currently running a SQL Profiler trace and a SQL Monitor Trace, and things seem to be running OK. I'll let you know if I find any issues.

Luis Martin

I'm use to run server side profiler and SQL Monitor on other machine. No problem at all.