-
Recent Posts
Recent Comments
- steve kirchner on Whats a Good Rule for Max Degree of Parallelism?
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
- tim cronin on A Busy/Accidental DBA’s Guide to Managing VLFs
- Automated fix for a high VLF Count – pagesql on A Busy/Accidental DBA’s Guide to Managing VLFs
Archives
Categories
Meta
Tag Archives: Profiler
Is Anybody Using That Stored Procedure?
From time to time I get asked to check if a stored procedure is still used in preparation for dropping it. This post outlines some different ways to get after that information and how sometimes it can go horribly wrong. Continue reading
Posted in Tracing and Profiler
Tagged Profiler, SSC, sys.dm_exec_procedure_stats, Tracing
5 Comments