|
Hello I'm leading the database element of an upgrade/migration project,to upgrade our Oracle consolidated db to Oracle 12c (from 9i), and Mobilink Server 16. Currrently : about 1300 remotes (SQLAnywhere 10), syncing to Oracle 9i (approx 12 tb; billions of rows). I had hopes that 'mlreplay' (came in with SQLA 12 ?) would help me with volume testing, but the docs/examples are a bit sparse. So, may be a stupid question, but, will/can 'mlreplay' actually try and re-apply inserts/updates to the consolidated db ? If so, how does it generate new PK values ? Or does it just simulate the load on the Mobilink serve, without trying to commit to the consolidated ? Which is still helpful, but not clear from the docs. Thank you |
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.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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: 11 Feb '20, 22:16
question was seen: 596 times
last updated: 13 Feb '20, 09:11
five years ago, I played with VTO. To be short, not with Mobilink. I didn't like replay, because it doesn't allow "scripting". You cannot change the parameters much. There was only one solution, that I used -> write a .NET application using Ultralite libraries, and start this app on a powerful VM with a RAM drive.
Very rough estimations are -> you can launch two apps per VM core. Otherwise the price for EXE files execution will be very high. Your VM will be overloaded.
It is not a good answer, and maybe not a good comment.
Hi Vlad, is VTO the SAP Volume Test Optimization toolset ? Thanks
I don't know if this is called toolset, but yes, you are right. This transcription is what you said.
I was interested in the possibility to generate the "right" system load coming from Mobilink applications. It is a dirty exercise.