Monitoring ...

I want to monitor the activity on a specific table, but I can't seem to get
the Profiler to cooperate. I know this table is active because it is a
locking table that we use to lock interdependant modules from conflicts so
it is constantly being hit with inserts, updates and deletes. I tried
filtering on object name, but the gives me nothing.
Hints and clues most welcome.
Bob Castleman
DBA PoseurWhat events are you monitoring? Are you looking specifically for DELETES,
UPDATES and INSERTS?
"Bob Castleman" wrote:

> I want to monitor the activity on a specific table, but I can't seem to ge
t
> the Profiler to cooperate. I know this table is active because it is a
> locking table that we use to lock interdependant modules from conflicts so
> it is constantly being hit with inserts, updates and deletes. I tried
> filtering on object name, but the gives me nothing.
> Hints and clues most welcome.
> Bob Castleman
> DBA Poseur
>
>|||Yup. I want to know just how active this puppy is.
"Cris_Benge" <CrisBenge@.discussions.microsoft.com> wrote in message
news:B9D551D0-D21C-43DF-9212-BFD2AF1CF7AA@.microsoft.com...
> What events are you monitoring? Are you looking specifically for DELETES,
> UPDATES and INSERTS?
> "Bob Castleman" wrote:
>|||If you've got stored procedures which perform the updates these won't get
listed by profiler.
A possible alternative could be to add some triggers to the table, and use
them to populate an audit table.
That's by best shot on this.
"Bob Castleman" <nomail@.here> wrote in message
news:eVhML$FbFHA.2444@.TK2MSFTNGP15.phx.gbl...
> Yup. I want to know just how active this puppy is.
>
> "Cris_Benge" <CrisBenge@.discussions.microsoft.com> wrote in message
> news:B9D551D0-D21C-43DF-9212-BFD2AF1CF7AA@.microsoft.com...
>