INF: How to Turn On Tracking of CPU Data for the Sysprocesses CPU Column (322109)

MORE INFORMATION

SQL Server 7.0 contains trace flag 3626, which is used to turn on tracking of the CPU data for the sysprocesses column.

Trace flag 3626 is applied globally, process wide, for all server process IDs (SPIDs). You can turn on trace flag 3626 with an auto-start procedure. Here is an auto-start procedure example:

create procedure spTrackCPU
as
begin
          dbcc traceon(3626)
end
go

sp_procoption spTrackCPU, 'startup', 'true'
go
				

You may also use dbcc traceon(3626) or dbcc traceoff(3626) to dynamically toggle the option.

NOTE: You turn on individual SPID behavior by using:

set statistics time on