Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Usage Report for Stored Procedures 1
- Thread starter checkai
- Start date
-
1
- #2
in 2008 there is a new dmv called dm_exec_procedure_stats this holds that info
the other way is running a trace with profiler (will slow down your box) or inside the proc log that into an audit table itself
Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions
the other way is running a trace with profiler (will slow down your box) or inside the proc log that into an audit table itself
Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions
- Status
Similar threads
- Locked
- Question
- Locked
- Question