SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 track database object activity
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

beyonder422
Posting Yak Master

USA
124 Posts

Posted - 03/08/2005 :  10:59:01  Show Profile
Does anyone have any code that can track how active database objects are?

ie. how many time a particular table, stored proc, or user func has been hit/used over a span of time?

I'd like to be able to identify dbo's that are old/obsolete/not being frequently used or haven't been used for some time.

And I know I can track table hits via trigger, but what about procs and funcs?

Something that can be used on ALL dbo's.


???

Edited by - beyonder422 on 03/08/2005 11:04:53

TG
Flowing Fount of Yak Knowledge

USA
6062 Posts

Posted - 03/08/2005 :  11:36:54  Show Profile
The most fool proof way is to build both data auditing and usage logging into the application/database design. However once you've got something online that does not incorporate these things I don't know. I think you are really limited to either tracing activity via profiler (which you don't really want to do long term) or something wacky like reading sysCacheObjects data into a table on a regular basis (which wouldn't be too reliable).

Be One with the Optimizer
TG
Go to Top of Page

beyonder422
Posting Yak Master

USA
124 Posts

Posted - 03/30/2005 :  14:54:38  Show Profile
Does NOBODY have any input on this?

Go to Top of Page

robvolk
Most Valuable Yak

USA
15676 Posts

Posted - 03/30/2005 :  21:09:40  Show Profile  Visit robvolk's Homepage
Did you not read TG's reply?
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000