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.

Following on from another thread, where poor performance of a legacy DB (ASA10) was wrongly attributed (by me!) to Virtualisation, I'd be interested to know what the official view is on this in regard to more current versions?

I believe I was seeing about 25%-30% slower performance on queries and 1000% slow down on dbbackup, but my tests were not that scientifically conducted. This was on both Intel and AMD Ryzen CPUs.

asked 26 Jan '18, 12:32

alexlake's gravatar image

alexlake
1317917
accept rate: 11%

edited 26 Jan '18, 12:32


The SQL Anywhere team is continuing to test the performance effects of the Meltdown/Spectre patches. Preliminary results indicate that it depends (that should not be a surprise!) We've seen anywhere between negligible effect to ~20% slowdown. Tests are ongoing.

permanent link

answered 26 Jan '18, 13:07

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297
accept rate: 41%

1

Thanks for that. Any thoughts on the speed of dbbackup?

(26 Jan '18, 17:23) alexlake
Replies hidden

I was expecting this question :)

(28 Jan '18, 08:06) Vlad
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:

×260
×119
×12

question asked: 26 Jan '18, 12:32

question was seen: 1,402 times

last updated: 28 Jan '18, 08:06