请升级到MicrosoftEdge以使用最新的功能、安全更新和技术支持。
Monday,September29,20084:52PM|1vote
Iamtryingtounderstandwhattotal_worker_timemeans.FromreadingthecolumndefinitionitlookslikeitisacummulativenumberofhowmuchCPUthisprocesshasusedsinceitwascreated.Ihaveseveralprocessesthathaveahightotalworkertime,buthaveaverysmallorlowlastworktime.Doesthiscounterhaveanyrealvalueorshoulditbeignored
Monday,September29,20085:06PMAnswered|1vote
total_worker_timeistheamountoftimethathasbeenspentrunningthisquerysincetheplanwascompiled,i.e.iftheplanhasbeenrun100timessinceitwascompiled,andeachtimeitranitto10ms,thetotal_worker_timewouldbe1000ms.Thelast_worker_timeisthetimeittooktorunthequerythelasttimeitran,withthesameexampleasbefore,thiswouldbe10ms.Ifyou'replanhasbeencompiledandinthecacheovertheperiodofmultiplerunsofthequery,thenwhatyou'reseeingisnormal.