How can we help you today? How can we help you today?

Safe to run SQL Profiler and SQL Monitor Trace concurrently?

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.
joshuawferguson
0

Comments

3 comments

Sort by
  • 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.
    Brian Donahue
    0
  • 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.
    joshuawferguson
    0
  • Luis Martin
    I'm use to run server side profiler and SQL Monitor on other machine. No problem at all.
    Luis Martin
    0

Add comment

Please sign in to leave a comment.