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.

Insert/update count for hot tables

2 posts in Performance and Tuning Last posting was on 2012-02-08 00:47:42.0Z
rick_608 Posted on 2012-02-07 18:52:58.0Z
Sender: 62a5.4f3171f0.1804289383@sybase.com
From: rick_608
Newsgroups: sybase.public.ase.performance+tuning
Subject: Insert/update count for hot tables
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f317309.62f4.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 7 Feb 2012 10:52:58 -0800
X-Trace: forums-1-dub 1328640778 172.20.134.41 (7 Feb 2012 10:52:58 -0800)
X-Original-Trace: 7 Feb 2012 10:52:58 -0800, 172.20.134.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:13048
Article PK: 91595

ASE 15.5 ESD3 I am looking for a way to find the number of
inserts/updates/deletes for a table. I recently found a
table that was getting inserts every 3 seconds due to an
application error. Since the table only receives inserts it
was easy to determine the count per second by using the
rowcount of the table (it is trimmed to 14 days worth of
data). However, I want to find tables that have high I/U/D
per second for tuning/maint. Is there a way to do this? The
DB has too many tables to use triggers and too many
application logins to use audit on login. MDA tables are
installed.

thx,
rick_806


"Mark A. Parsons" <iron_horse Posted on 2012-02-08 00:47:42.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.ase.performance+tuning
Subject: Re: Insert/update count for hot tables
References: <4f317309.62f4.1681692777@sybase.com>
In-Reply-To: <4f317309.62f4.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: <4f31c62e$1@forums-1-dub>
Date: 7 Feb 2012 16:47:42 -0800
X-Trace: forums-1-dub 1328662062 10.22.241.152 (7 Feb 2012 16:47:42 -0800)
X-Original-Trace: 7 Feb 2012 16:47:42 -0800, vip152.sybase.com
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:13049
Article PK: 91602

monOpenObjectActivity comes to mind; it has 3 columns that keep track of IUD activity (RowsInserted, RowsDeleted,
RowsUpdated)

I'm thinking you could take periodic snapshots of mOOA and use the deltas to determine number of IUD ops during the
period between 2 mOOA snapshots.

On 02/07/2012 11:52, rick_608 wrote:
> ASE 15.5 ESD3 I am looking for a way to find the number of
> inserts/updates/deletes for a table. I recently found a
> table that was getting inserts every 3 seconds due to an
> application error. Since the table only receives inserts it
> was easy to determine the count per second by using the
> rowcount of the table (it is trimmed to 14 days worth of
> data). However, I want to find tables that have high I/U/D
> per second for tuning/maint. Is there a way to do this? The
> DB has too many tables to use triggers and too many
> application logins to use audit on login. MDA tables are
> installed.
>
> thx,
> rick_806