There is a stored proc sp_monitor, but this gives the total cpu %. I have checked numerous places on the web, but I still haven't found a answer.