The problem with any such tool is that the vendor probably wants logical
transactions. All you can measure with any of the tools discussed so far is
number of database transactions, which is probably some multiple of the
number of logical transactions. For example, in an order processing
application, you would need numbers such as the number of orders taken per
day, and number shipped per day. Each of those activities would require
several database transactions to complete.
Probably your best measure would be to use a report writer to extract
whatever kind of record corresponds with a logical transaction, and select
the ones for a specific date. Once you know the transaction count for a
day, you can estimate hourly rates, etc. So, the answer to your question is
that there is probably not a canned solution that will give you the figures
you need, unless the application itself already reports the numbers. You
should probably ask you users whether they have transaction counts
available.
-----Original Message-----
From: Cynthia Fowler [mailto:[log in to unmask]]
Sent: Friday, May 30, 2003 8:24 AM
To: [log in to unmask]
Subject: counting transactions
I have a question to which I need an answer by Monday. Our company is
looking at a canned package to replace our home-grown production software.
One of the questions the vendor needs answered is how many transactions we
process in an hour, day, etc. I'm not really sure how to go about doing
that. Is there a product that can provide that information? We have some 3rd
party software products, but I'm not sure if any of them will produce this
number. We have VESOFT products, SOS/3000, DBGeneral, and a few others, but
I'm not sure any of them are capable of this type of count.
Any ideas?
Cindee
Cynthia Bridges-Fowler
HP3000 Senior System Administrator
North American Salt Company
a division of Compass Minerals Group
[log in to unmask]
http://www.compassminerals.com/
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
