Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
beyonder422
Posting Yak Master
124 Posts |
 Posted - 2005-03-08 : 10:59:01
|
| 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.??? |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-08 : 11:36:54
|
| 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 OptimizerTG |
 |
|
|
beyonder422
Posting Yak Master
124 Posts |
Posted - 2005-03-30 : 14:54:38
|
Does NOBODY have any input on this? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-30 : 21:09:40
|
| Did you not read TG's reply? |
|
|
|
|
|
|
track database object activity