[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Automatically track object (stored procedure) usage?

DC

3/16/2007 10:40:00 AM

Hi,

SQL Server 2000: I would like to automatically track the last time an
object (especially stored procedures) have been used so I can find out
which are candidates for deletion. Is it possible to somehow hook into
SQL Server and get this done?

Regards
DC
2 Answers

Jack Vamvas

3/16/2007 11:47:00 AM

0

Use Profiler , although depending on your set up this could cause
performance problems. Run the Profiler from another machine.
Also, depending on how many stored procedures you have , you could set up a
AUDIT log. Just something simple , whereby everytime
a stored procedure is run , you log this in a table, -- this would require
some INSERT statements

--

Jack Vamvas
___________________________________
Advertise your IT vacancies for free at - http://www.ITj...



"DC" <dc@upsize.de> wrote in message
news:1174041597.292029.244670@l77g2000hsb.googlegroups.com...
> Hi,
>
> SQL Server 2000: I would like to automatically track the last time an
> object (especially stored procedures) have been used so I can find out
> which are candidates for deletion. Is it possible to somehow hook into
> SQL Server and get this done?
>
> Regards
> DC
>


DC

3/16/2007 2:41:00 PM

0

Thanks, Jack. I thought about profiler, but I think it will not show
the usage if one storedproc calls another? A logging in every
procedure is what I was trying to avoid...maybe if there is not other
way I will think about a way to programmatically insert some logging
in every proc.

Regards
DC

On 16 Mrz., 12:47, "Jack Vamvas" <DEL_TO_RE...@del.com> wrote:
> Use Profiler , although depending on your set up this could cause
> performance problems. Run the Profiler from another machine.
> Also, depending on how many stored procedures you have , you could set up a
> AUDIT log. Just something simple , whereby everytime
> a stored procedure is run , you log this in a table, -- this would require
> some INSERT statements
>
> --
>
> Jack Vamvas
> ___________________________________
> Advertise your IT vacancies for free at -http://www.ITj...
>
> "DC" <d...@upsize.de> wrote in message
>
> news:1174041597.292029.244670@l77g2000hsb.googlegroups.com...
>
>
>
> > Hi,
>
> > SQL Server 2000: I would like to automatically track the last time an
> > object (especially stored procedures) have been used so I can find out
> > which are candidates for deletion. Is it possible to somehow hook into
> > SQL Server and get this done?
>
> > Regards
> > DC- Zitierten Text ausblenden -
>
> - Zitierten Text anzeigen -