Browse by Tags

• cache
• memory
• performance
• stored procedure

SQL Server 2005: Stored Procedure call activity statistics & execution time
21 June 07 02:56 PM | SQL Master | 1 Comments   

Is it possible to get statistics like how many times a stored procedure is called such as average execution time and how often that procedure is being called. Bascially it is possible to get provided that particular stored procedure is active and plan Read More...

Filed under: performance, cache, memory, stored procedure, times, compiled