Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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 '19, 09:25

Arcady%20Abramov's gravatar image

Arcady Abramov
accept rate: 0%

edited 29 Jan '19, 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

   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 '19, 11:31

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

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

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

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

(29 Jan '19, 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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 29 Jan '19, 09:25

question was seen: 847 times

last updated: 29 Jan '19, 11:56