Safe to run SQL Profiler and SQL Monitor Trace concurrently?

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Safe to run SQL Profiler and SQL Monitor Trace concurrently?

Postby joshuawferguson » Fri Sep 13, 2013 7:14 pm

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
 
Posts: 7
Joined: Wed Sep 11, 2013 10:24 pm
Location: Lafayette, LA

Postby Brian Donahue » Mon Sep 16, 2013 3:42 pm

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
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Postby joshuawferguson » Mon Sep 16, 2013 3:45 pm

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
 
Posts: 7
Joined: Wed Sep 11, 2013 10:24 pm
Location: Lafayette, LA

Postby Luis Martin » Tue Sep 17, 2013 1:29 am

I'm use to run server side profiler and SQL Monitor on other machine. No problem at all.
Luis Martin
 
Posts: 43
Joined: Tue Nov 15, 2005 3:45 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests