Post reply

SQL trace owned by accoung sa - system generated?

  • September 16, 2010 at 12:05 pm

    #240499

    Hi,

    I have a SQL Trace that is running under the souce spid of 5s that is owned by "sa". I can't tell if this is something that is owned by SQL Server because of a setting, or is a process has called this and thus it is owned by sa rather than a named user.

    Date,Source,Severity,Message

    09/16/2010 09:14:49,spid79,Unknown,SQL Trace stopped. Trace ID = '2'. Login Name = 'LIL\kevinl'.

    09/16/2010 09:14:44,spid76,Unknown,SQL Trace ID 2 was started by login "LIL\kevinl".

    09/08/2010 10:58:57,spid65,Unknown,SQL Trace stopped. Trace ID = '2'. Login Name = 'LIL\sladmin'.

    09/08/2010 10:58:20,spid64,Unknown,SQL Trace ID 2 was started by login "LIL\sladmin".

    [highlight=#ffff11]09/08/2010 10:55:46,spid5s,Unknown,SQL Trace ID 1 was started by login "sa".[/highlight]

    I can see that the trace started and appears to still be running:

    select * from fn_trace_getinfo(0)

    Recnum TraceId property value

    1112

    212C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_904.trc

    31320

    414NULL

    5151

    Any assistance to a newb would be appreciated!

  • September 16, 2010 at 12:12 pm

    #1222472

    yes that's the default trace, which tracks DDL changes made to all databases; it's low impact trace that can be most easily accessed from teh GUI, where it is filtered by database.

    remember all spids under #50 are system spids anyway; user spids are 50 and up.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 16, 2010 at 1:10 pm

    #1222519

    Thanks Lowell!

  • September 16, 2010 at 1:21 pm

    #1222527

    Lowell (9/16/2010)

    remember all spids under #50 are system spids anyway; user spids are 50 and up.

    On 2005 and higher it's possible to have system spids with session_id above 50. Sys.dm_exec_sessions has a column 'is_user_process' that tells if a process is system or user.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply