Re: identify an update transaction

From: joel garry <>
Date: Wed, 22 Apr 2009 12:22:48 -0700 (PDT)
Message-ID: <>

On Apr 21, 11:36 pm, eliot06 <> wrote:
> Hi,
> what are the tables or views to usage to identify a session that is
> doing massive updates to the database and what is the query to use ?
> Thank's

Mark's answer is the better one - you have to actually learn what you need to know, as well as how to figure it out - but another way is if you have tools like Enterprise Manager, often you can drill into the help or sometimes session sql displays to see what it is doing when you ask it to show you this kind of thing. Sometimes it's even good enough to just use the tool - though understanding what the tool is doing is always better, all tools and docs have at least some misleading advice.

Also see (note the statspack suggestion).

Welcome to the group, here are some clues:


-- is bogus.
History of MS anti-competitive behavior:
Received on Wed Apr 22 2009 - 14:22:48 CDT

Original text of this message