September 22, 2014 at 9:25 am
Please bare with me since I am still learning and let me know if you guys don't understand what I am trying to ask.
I was just monitoring one of our prod environment and I see in the log that "SQL Trace ID 2 was started by login dba which is me, but I don't remember starting anything. I don't even have a scheduled job which runs around this time. I run this command Select * from fn_trace_getinfo(0) and I see the traceID 2 is running. Is there a way to find out who started the trace or maybe someone is using my account to run the trace?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 22, 2014 at 9:51 am
Please check sql server logs - it should actually have events 'SQL trace ID 2 started by login ""' - if that is sql generated automatic trace, then the login would be the account that is used to run sql service.
September 22, 2014 at 10:00 am
September 22, 2014 at 10:08 am
Please see the attachment. Like I said, I didn't start any trace nor did I schedule any trace job.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 22, 2014 at 10:15 am
That's the default trace which gets invoked by sql itself when it reaches the 20MB file size limit
Open SQL configuration manager and find the sql service account that is used to run sql services. It should probably match with the account that is being displayed.
Do you use Remedy? - ARsystem - lol :).
September 22, 2014 at 10:20 am
ErrLog (9/22/2014)Do you use Remedy? - ARsystem - lol :).
Yes
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply