Archives of the TeradataForum

Message Posted: Tue, 29 Oct 2002 @ 20:56:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Richard,

Tech Alerts NTA 572 may explain the reason..

Condition/Symptom:

Multiple queries running in parallel and accessing at least one common table may continue to run, accumulating very large counts in both "CPU Usage" and "Accesses" (as shown in qrysessn). When this is occurring, the SAR utility will show a large percentage of CPU activity in %sys, relative to % usr. For example: ...

	<Prev	Next>		<<First	<Prev	Next>	Last>>