Nick Kewney

Software Architect & Product Builder

Month: May 2009

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 …

Find Inefficient T-SQL Stored Procedures Read More »