Re: How long has transaction been open?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Sebastian K. Zaklada (szaklada-dont-like-spam_at_skilledsoftware.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 22:35:06 +0100

> Does anyone know how to determine how long an open
> transaction hase been open? None of the columns in
> sysprocesses seem to provide that.

See DBCC OPENTRAN, it displays information about the oldest active
transaction and the oldest distributed and nondistributed replicated
transactions, if any, within the specified database.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_dbcc_5fhq.asp

sincerely, 

--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: Getting transaction ID in trigger?
    ... Perhaps you need hostprocess column in sysprocesses table. ... > is it possible to get the transaction id inside a trigger as a context ...
    (microsoft.public.sqlserver.programming)
  • Re: Problem with COM+ and SQL Server on a 64-bit machine
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > the petshop has a COM+ component that access the databases when the COM+ ... > tries to carry out a transaction. ... > I tried with the DTC, enable network access and the turnoffsecurity switch ...
    (microsoft.public.sqlserver.server)
  • Re: ADO & SQL Server.
    ... Try SPLock to see if that can help isolate the transaction and the pages ... This posting is provided "AS IS" with no warranties, and confers no rights. ... Using a SP to backup your data is not such a good idea ... >>> information on transaction isolation levels. ...
    (microsoft.public.data.ado)
  • Re: Meaning of this deed
    ... plat map for the warranted land, the subsequent patent, and each ... rights) may have been retained with each transaction. ...
    (soc.genealogy.methods)
  • Re: Transaction error...Either enlist this session in a new transaction or the NULL transaction
    ... > transaction which should then be automatically enlisted in the distributed ... >> In this case, if you create an instance of class B and call Execute, I ... >> Please reply in newsgroup. ... > rights. ...
    (microsoft.public.dotnet.framework.component_services)