How to Query most recently accessed tables and stored Procedures

Hi!
Anybody Please help me, i want to find out the Query for most recently
used Database tables and stored Procedures i.e from last 6 months. As
bcas of there are lots of Procedures and tables which r unnessary due
to this my site is getting slow.
So if i find the Query so that i can start up cleaning up my database.
Regards
SarithaNo, you would have ran a SQL Server Profiler to gather such info
"subbu" <pakasaritha@.gmail.com> wrote in message
news:1139997806.946690.232430@.g44g2000cwa.googlegroups.com...
> Hi!
> Anybody Please help me, i want to find out the Query for most recently
> used Database tables and stored Procedures i.e from last 6 months. As
> bcas of there are lots of Procedures and tables which r unnessary due
> to this my site is getting slow.
> So if i find the Query so that i can start up cleaning up my database.
> Regards
> Saritha
>|||In addition to URI you can track the executes in the stored procedure
by implementing another logic within the proc which audits and write
the execution calls of itself to a table.
HTH, Jens Suessmeyer.