Various methods, queries, tools to monitor database procedures taking more cpu time for a predefined threshold value
How to analyse which Stored Procedure is taking more time than threshold value for sql server