find out how often is a table get updated/inserted
From: Kenny (pearl_77_at_hotmail.com)
Date: 07/22/04
- Next message: Wayne Snyder: "Re: Index Fragementing Rapidly"
- Previous message: Sydney Lotterby: "Re: How do I shrink my logfile?"
- Next in thread: Wayne Snyder: "Re: find out how often is a table get updated/inserted"
- Reply: Wayne Snyder: "Re: find out how often is a table get updated/inserted"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 13:29:12 -0400
How can I find out how often is a table get updated/inserted?
I'm planning to use sql profiler or maybe performance monitor, but I'm not
sure how to do that. I don't know what criteria should be set to catch them.
I know I can do a trigger and log to a log table. but I wondered if there
is alternative way, use either sql profiler or performance monitor.
- Next message: Wayne Snyder: "Re: Index Fragementing Rapidly"
- Previous message: Sydney Lotterby: "Re: How do I shrink my logfile?"
- Next in thread: Wayne Snyder: "Re: find out how often is a table get updated/inserted"
- Reply: Wayne Snyder: "Re: find out how often is a table get updated/inserted"
- Messages sorted by: [ date ] [ thread ]