Microsoft KB Archive/322109

= INF: How to Turn On Tracking of CPU Data for the Sysprocesses CPU Column =

Article ID: 322109

Article Last Modified on 6/12/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q322109



SUMMARY
By default, SQL Server 7.0 does not track the CPU column of the sysprocesses system table.



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

Keywords: kbinfo KB322109

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.