Subject Re: Usage of SPs?
Author Adam
--- In, Sándor Tamás (HostWare Kft.)
<sandortamas@h...> wrote:
> Hi,
> Is there any possibilities to find out which procedures are used from a
> database in a time interval? Let's say like a counter or something?
> SanTa


It would be rather trivial though to create a table to store that
information and modify the stored procedure to add a record to it.
Always insert ('SP_Name', 1) into the table, do not run "update .. set
cnt = cnt + 1 where name = 'SP_Name'", because this will prevent the
SP calls from occuring simultaneously.

Basically, this method is an efficient way of counting