July 2, 2013 at 11:13 am
Is there any way to identify if someone is running "Monitoring Your Database with SQL Profiler" sql trace against production database. ?
We are having issue with our current application performance, after diagnosing the problem, we realized one of our database admin decided to use this tools during peak hours that effect application performance. Is there any way we can setup some notification in case, if any other admin decided to follow hand on training for sql trace ?
July 2, 2013 at 2:50 pm
You could download and run sp_whoisactive. Whenever SQL Server Profiler is running, the program_name column in the output of sp_whoisactive will have something along the lines of 'SQL Server Profiler - 8d20b44e-81ef'. You could schedule a run of sp_whoisactive, output the results to a table or temp table, and flag an alert on program_name LIKE 'SQL Server Profiler%'.
http:\\www.tinyurl.com/whoisactive
Twitter: @SQL_JGood
Blog: sqljgood.wordpress.com/[/url]
July 2, 2013 at 3:15 pm
also I'm pretty sure a profiler created trace does not have a path: so you can do check sys.traces as a quick sanity check, and that would tell you if one is currently being run or not.
select *
from sys.traces
where path is null --Profiler.exe created this trace!
and status = 1 --is it running right now?
Lowell
July 2, 2013 at 3:18 pm
* also the Database Engine Tuning Advisor creates a trace with a NULL path, as well.
Lowell
July 3, 2013 at 10:17 am
Perfecto, Thank you so much. Apperciate your help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply