Re: find out how often is a table get updated/inserted
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 07/22/04
- Next message: Wayne Snyder: "Re: remove guest user in msdb"
- Previous message: Karl Pierburg: "Re: Index Fragementing Rapidly"
- In reply to: Kenny: "find out how often is a table get updated/inserted"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 22 Jul 2004 13:37:08 -0400
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. > >
- Next message: Wayne Snyder: "Re: remove guest user in msdb"
- Previous message: Karl Pierburg: "Re: Index Fragementing Rapidly"
- In reply to: Kenny: "find out how often is a table get updated/inserted"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
