find out how often is a table get updated/inserted

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.
You can use profiler, capture the data to a file or table...
The event should be SQL Statement Ending. Then capture whatever counters
you wish...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kenny" <pearl_77@.hotmail.com> wrote in message
news:%23KZroFBcEHA.2812@.TK2MSFTNGP11.phx.gbl...
> 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.
>

find out how often is a table get updated/inserted

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.You can use profiler, capture the data to a file or table...
The event should be SQL Statement Ending. Then capture whatever counters
you wish...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kenny" <pearl_77@.hotmail.com> wrote in message
news:%23KZroFBcEHA.2812@.TK2MSFTNGP11.phx.gbl...
> 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.
>

find out how often is a table get updated/inserted

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.You can use profiler, capture the data to a file or table...
The event should be SQL Statement Ending. Then capture whatever counters
you wish...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kenny" <pearl_77@.hotmail.com> wrote in message
news:%23KZroFBcEHA.2812@.TK2MSFTNGP11.phx.gbl...
> 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.
>