Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Number of currently running transactions

3 posts in General Discussion Last posting was on 2010-05-24 19:53:59.0Z
ncantor Posted on 2010-05-24 19:03:11.0Z
Sender: 57c4.4bfacc30.1804289383@sybase.com
From: ncantor
Newsgroups: sybase.public.ase.general
Subject: Number of currently running transactions
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4bfacd6d.5806.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 May 2010 12:03:11 -0700
X-Trace: forums-1-dub 1274727791 10.22.241.41 (24 May 2010 12:03:11 -0700)
X-Original-Trace: 24 May 2010 12:03:11 -0700, 10.22.241.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29244
Article PK: 78480

Hello, I was hoping someone here may be able to help me. I
am looking for a way to monitor the total number of
currently running transactions in an ASE database (could be
12.5.4 or 15.5). Preferably, I would like to get this
number through a simple query into a system table, but I
cannot find where this statistic might be stored. It could
be the total for all users, or it could be a column of the
total of each user, which could then be added up to provide
the total for all users. If anyone knows how to get this
data or if you need more information, please respond. I
appreciate it.

~Noah


Rob V [ Sybase ] Posted on 2010-05-24 19:53:59.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Number of currently running transactions
References: <4bfacd6d.5806.1681692777@sybase.com>
In-Reply-To: <4bfacd6d.5806.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bfad957@forums-1-dub>
Date: 24 May 2010 12:53:59 -0700
X-Trace: forums-1-dub 1274730839 10.22.241.152 (24 May 2010 12:53:59 -0700)
X-Original-Trace: 24 May 2010 12:53:59 -0700, vip152.sybase.com
Lines: 39
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29246
Article PK: 78478


On 24-May-2010 21:03, ncantor wrote:
> Hello, I was hoping someone here may be able to help me. I
> am looking for a way to monitor the total number of
> currently running transactions in an ASE database (could be
> 12.5.4 or 15.5). Preferably, I would like to get this
> number through a simple query into a system table, but I
> cannot find where this statistic might be stored. It could
> be the total for all users, or it could be a column of the
> total of each user, which could then be added up to provide
> the total for all users. If anyone knows how to get this
> data or if you need more information, please respond. I
> appreciate it.
>
> ~Noah
>

Already answered in sybase.public.ase.administration.
Please don't cross-post.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------


Bret Halford Posted on 2010-05-24 19:37:03.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Number of currently running transactions
References: <4bfacd6d.5806.1681692777@sybase.com>
In-Reply-To: <4bfacd6d.5806.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bfad55f$1@forums-1-dub>
Date: 24 May 2010 12:37:03 -0700
X-Trace: forums-1-dub 1274729823 10.22.241.152 (24 May 2010 12:37:03 -0700)
X-Original-Trace: 24 May 2010 12:37:03 -0700, vip152.sybase.com
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29245
Article PK: 78479


On 5/24/2010 1:03 PM, ncantor wrote:
> Hello, I was hoping someone here may be able to help me. I
> am looking for a way to monitor the total number of
> currently running transactions in an ASE database (could be
> 12.5.4 or 15.5). Preferably, I would like to get this
> number through a simple query into a system table, but I
> cannot find where this statistic might be stored. It could
> be the total for all users, or it could be a column of the
> total of each user, which could then be added up to provide
> the total for all users. If anyone knows how to get this
> data or if you need more information, please respond. I
> appreciate it.
>
> ~Noah

Perhaps...

select sum(Transactions) - sum(Commits + Rollbacks)
from monProcessActivity