Red Gate forums :: View topic - Safe to run SQL Profiler and SQL Monitor Trace concurrently?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Safe to run SQL Profiler and SQL Monitor Trace concurrently?

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
joshuawferguson



Joined: 11 Sep 2013
Posts: 7
Location: Lafayette, LA

PostPosted: Fri Sep 13, 2013 7:14 pm    Post subject: Safe to run SQL Profiler and SQL Monitor Trace concurrently? Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Mon Sep 16, 2013 3:42 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
joshuawferguson



Joined: 11 Sep 2013
Posts: 7
Location: Lafayette, LA

PostPosted: Mon Sep 16, 2013 3:45 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Luis Martin



Joined: 15 Nov 2005
Posts: 61

PostPosted: Tue Sep 17, 2013 1:29 am    Post subject: Reply with quote

I'm use to run server side profiler and SQL Monitor on other machine. No problem at all.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group