Hello, Team We need to provide estimated (average) number of transactions per minute on a specific DB for an integration company.

Is there a way to get this data out of SQL Anywhere server 16?

Thank you

asked 29 Jan, 09:25

Arcady%20Abramov's gravatar image

Arcady Abramov
861112
accept rate: 0%

edited 29 Jan, 09:25


Here's a wild guess: Use the database server properties for number of commits and rollbacks since the server has been started, such as

select
   cast(property('Commit') as bigint) as CommitCount,
   cast(property('Rlbk') as bigint) as RollbackCount,
   cast(datediff(minute, cast(property('StartTime') as datetime),
                         current timestamp) as double) as ServerRuntimeInMinutes ,
   (CommitCount + RollbackCount) / ServerRuntimeInMinutes as AverageTxnRatePerMinute

If you need that for a particular interval, just store the results at the start and end of the according interval and compare those.

Commits and rollbacks can also be counted per connection or per database with the same property names using the connection_property() resp. db_property() functions.

permanent link

answered 29 Jan, 11:31

Volker%20Barth's gravatar image

Volker Barth
33.8k330486716
accept rate: 33%

Thank you, This would be enough for me to create a procedure, which calculates the data across the range of seconds.

(29 Jan, 11:34) Arcady Abramov
Replies hidden

Well, if it really answers your question, feel free to accept this answer:)

(29 Jan, 11:56) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×2

question asked: 29 Jan, 09:25

question was seen: 149 times

last updated: 29 Jan, 11:56