-
StatPress TopPosts
- How to Shrink TempDB in SQL 2005 (2290)
- A Busy/Accidental DBA's Guide to Managing VLFs (2233)
- Stored Procedure to Sequentially Run SQL Agent Jobs (2184)
- Why Do I Need All These Servers? (2173)
- Stored Procedure to Get SQL Job Execution Status (2131)
Archives
- May 2011 (4)
- April 2011 (1)
- January 2011 (1)
- November 2010 (8)
- October 2010 (3)
- September 2010 (6)
- August 2010 (1)
- July 2010 (2)
- June 2010 (1)
- May 2010 (5)
- April 2010 (11)
- March 2010 (2)
- February 2010 (3)
- January 2010 (3)
- December 2009 (4)
Categories
- Azure (1)
- Backup (1)
- CLR (1)
- Dynamic SQL (1)
- File Management (5)
- General (7)
- PowerShell (6)
- Reporting (1)
- Security (4)
- Security Cache (2)
- SQL University (4)
- Tracing and Profiler (1)
- Troubleshooting (7)
- User Management (6)
- Utilities (22)
Meta
Disclaimer
All thoughts and opinions expressed here do not reflect those of my employer in any way.
Category Archives: Tracing and 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
