如何检查sql server中哪个存储过程占用的时间最长

I want to know what are various methods by which I can monitor which of my stored procedure's and SQL queries are taking more time on various components(CPU cycle, scan time etc.) than already set threshold value.I want to know what are various methods by whic