processes

  • Whats the best way to differenciate a system process and a user process running on a server at the same time with different spid's. The sysprocesses table doesnt clearly say if a uid is sytem related or user related. Is there any other way? any help will be greatly appreciated

  • SPID from 1 to 6 are system process. Handler, Lock monitor, Log writer, Lazy writer and Check point

    Shas3

  • This may depend on what version of SQL Server you are using. On SQL2000, spids 1-50 are reserved for system processes.

    Having said that, I've just looked on a server here and spid 51 is being used by SQL Agent. Not sure whether you would consider that a system process.

    Perhaps you can use the dbid from the sysprocesses table (dbname in sp_who2) to identify processes running against user databases

Viewing 3 posts - 1 through 2 (of 2 total)

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