MS SQL Server Tools - Stored Procedure Usage

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Stored Procedure Usage

Susanna

2005-12-15, 9:23 am

Is there something that can check the usage of a stored procedure?

Tibor Karaszi

2005-12-15, 11:23 am

You mean who executes it, when and how often? Either have a profiler trace running with appropriate
events, columns and filters. Or modify the procedure so it logs the needed information to a table.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Susanna" <Susanna@discussions.microsoft.com> wrote in message
news:2CFAFEA4-A70C-445F-ADA8- E2394922F914@microso
ft.com...
> Is there something that can check the usage of a stored procedure?

Sponsored Links