Find Inefficient T-SQL Stored Procedures
The following is a stored procedure you can use when you want to quickly identify procedures in your SQL Server database which are taking up excessive CPU time. The script returns 3 recordsets: The number of active connections by database name, with login name and hostname All stored procedures with execution count and total/average CPU times All stored procedures with …