How many times we all DBA's might have wonder which stored procedure is executing most in the database? I have wondered it often and I have written following small script which gives me answer to my above questions. I am also retrieving few additional data along with the highest used SP names. You can change… Continue Reading...
Source: SQL SERVER – 2005 – Find Highest / Most Used Stored Procedure | Journey to SQL Authority with Pinal Dave
No comments:
Post a Comment