Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1467

Re: How to find not-committed transaction in SQL Server 2008 exactly?

Show all headers | View raw

On Monday, May 6, 2013 3:16:36 PM UTC+8, Erland Sommarskog wrote:
> Peng Liu (liupengwyy@gmail.com) writes:
> 
> > According to your reply, do you mean that there might exist open
> 
> > transactions even the result of DBCC OPENTRAN indicates no active open
> 
> > transaction? 
> 
> 
> 
> Yes, what DBCC OPENTRAN tells is that there is no uncommitted transaction 
> 
> in the transaction log.
> 
> 
> 
> Or, in another words, DBCC OPENTRAN tells you that there no uncommitted 
> 
> updates. But there might still be open transactions that hitherto only has 
> 
> performed read operations (but which might hold locks, depending on the
> 
> isolation level.)
> 
>  
> 
> > From the step I list, can you find that there is still open transaction?
> 
> > from which step? 
> 
> 
> 
> 1 and 2.
> 
> 
> 
> > From the result of "select spid, lastwaittype, last_batch, status,
> 
> > open_tran, cmd, sql_handle from sys.sysprocesses where spid = 53;", the
> 
> > status value is sleeping, what does the "sleeping" mean? 
> 
> 
> 
> The process is not running. It could be because it is awating a command 
> 
> from the client, but it could also be waiting on I/O completion or a
> 
> locked resource to become available.
> 
> 
> 
> -- 
> 
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
> 
> 
> 
> Books Online for SQL Server 2005 at
> 
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> 
> Books Online for SQL Server 2000 at
> 
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Erland Sommarskog,

Now I did a minor change to my C++ code. Now, on the SQL Server Management Studio, right click the database node, select Reports->Standard Reports->All transactions, the report said that there is no active transaction. 

However, through the step 1 and 2, there is still 1 transaction. 

What do you think about this scenario?

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How to find not-committed transaction in SQL Server 2008 exactly? Peng Liu <liupengwyy@gmail.com> - 2013-04-27 00:11 -0700
  Re: How to find not-committed transaction in SQL Server 2008 exactly? Erland Sommarskog <esquel@sommarskog.se> - 2013-04-27 11:42 +0200
  Re: How to find not-committed transaction in SQL Server 2008 exactly? Peng Liu <liupengwyy@gmail.com> - 2013-04-27 19:57 -0700
    Re: How to find not-committed transaction in SQL Server 2008 exactly? Erland Sommarskog <esquel@sommarskog.se> - 2013-04-28 11:26 +0200
      Re: How to find not-committed transaction in SQL Server 2008 exactly? rja.carnegie@gmail.com - 2013-04-28 03:49 -0700
      Re: How to find not-committed transaction in SQL Server 2008 exactly? Peng Liu <liupengwyy@gmail.com> - 2013-05-05 20:35 -0700
        Re: How to find not-committed transaction in SQL Server 2008 exactly? Erland Sommarskog <esquel@sommarskog.se> - 2013-05-06 07:16 +0000
          Re: How to find not-committed transaction in SQL Server 2008 exactly? Peng Liu <liupengwyy@gmail.com> - 2013-05-06 18:40 -0700
            Re: How to find not-committed transaction in SQL Server 2008 exactly? Erland Sommarskog <esquel@sommarskog.se> - 2013-05-07 21:12 +0200
  Re: How to find not-committed transaction in SQL Server 2008 exactly? Peng Liu <liupengwyy@gmail.com> - 2013-04-28 00:52 -0700
  Re: How to find not-committed transaction in SQL Server 2008 exactly? Peng Liu <liupengwyy@gmail.com> - 2013-05-05 20:31 -0700
  Re: How to find not-committed transaction in SQL Server 2008 exactly? work4anvesh@gmail.com - 2015-08-26 10:47 -0700
  Re: How to find not-committed transaction in SQL Server 2008 exactly? work4anvesh@gmail.com - 2015-08-26 10:48 -0700
  Re: How to find not-committed transaction in SQL Server 2008 exactly? johnsonwelch2@gmail.com - 2016-04-14 01:46 -0700

csiph-web