Re: Object Access?

From: Uri Dimant (urid_at_iscar.co.il)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 16:59:15 +0200

mk
No, SQL Server does not track this info.
Do the users still work against the database?
If they do, run Profiler to see what is going on. What objects have
invoked.
Also visit on www.dbazine.com , you will find there (under SQL Server) the
script written by Gregory Larsen(if i remember well) which may help you to
identify what objects have changed.

"mk" <mk@discussions.microsoft.com> wrote in message
news:3C0438F4-7CA1-4431-9FCA-2C653B4CE436@microsoft.com...
> Hi,
> We've recently had to take over another team's system. They've been
> disbanded, and of course we've no documentation. This system has
literally
> thousands of stored procedures and many hundreds of tables, and has been
> increasing in size (objects and data) since first developed in 2000.
> Anyway, I want to strip this down to the minimum necessary items and I'm
> wondering if it is possible to run any kind of queyr which will show me
when
> an object was last accessed. For example, is it possible to tell when a
> stored procedure was last invoked, or when a table was last accessed for
> select, insert, update, delete, etc.
> I appreciate that I can log or profile the current activity, but I was
> hoping it would be possible to see what elements in the table are
redundant.
> Some of the objects really look like 'development-mode' instances, but
then
> they are also referenced in quite a few stored procedures and do actually
> live in the production environment. Of course I suspect quite a few are
> still redundant or obsolete.
> Any help or advice would be much appreciated.
>
> Thanks,
>
> mk

Relevant Pages

  • Re: Object Access?
    ... > Do the users still work against the database? ... run Profiler to see what is going on. ... >> they are also referenced in quite a few stored procedures and do actually ... >> still redundant or obsolete. ...
    (microsoft.public.sqlserver.programming)
  • Re: How work Profiler.
    ... In SQL Server 2000, only members of the SysAdmin role are permitted to execute the Profiler utility. ... Other than modifying the system stored procedures that are used by the Profiler utility, there is, to the best of my knowledge, no alternative. ...
    (microsoft.public.sqlserver.security)
  • Re: Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... Have you profiled both SQL Server and your application to find out where all ... if the stored procedures are really taking 30 minutes (and what parameters ... Profiler, Community Edition. ...
    (microsoft.public.sqlserver.server)
  • Re: performance degradation
    ... You have to identify what exactly is resulting in high CPU utilization. ... I would use Profiler to track down the long running and most CPU intensive ... stored procedures and queries, and tune them. ... Microsoft SQL Server 2000 Performance Tuning Technical Reference ...
    (microsoft.public.sqlserver.server)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
Loading