Find out what is written into transaction log

Hi,
My transaction log grows around 5 Gb an hour. I'm trying to find out what is
being written there and running SQL profiler. I can find very few
transactions with Writes other then 0. How can I find out what is being
written into transaction log in such huge volumes?
Have a look at getting a log viewer tool eg Lumigent's LogExplorer or
Redgate's LogRescue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Find out what is written into transaction log

Hi,
My transaction log grows around 5 Gb an hour. I'm trying to find out what is
being written there and running SQL profiler. I can find very few
transactions with Writes other then 0. How can I find out what is being
written into transaction log in such huge volumes?Have a look at getting a log viewer tool eg Lumigent's LogExplorer or
Redgate's LogRescue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Find out what is written into transaction log

Hi,
My transaction log grows around 5 Gb an hour. I'm trying to find out what is
being written there and running SQL profiler. I can find very few
transactions with Writes other then 0. How can I find out what is being
written into transaction log in such huge volumes?Have a look at getting a log viewer tool eg Lumigent's LogExplorer or
Redgate's LogRescue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

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.
>