Yesterday I had problem withthat a sp that contained join that the developer had forgotten the where part. Thesp join very large tables and sp took more 95% dual itanium processor. How dofastest track this down when it accure. Find the sp or sql that running andconsume this much processor resources. I tried with a lot. Sp_who, sp_who2,activity monitor.