Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

We upgraded a server last weekend from ASA 9 to ASA12 64 bit. One query (execution plan attached) when executed pegs the CPU for one core (it is a 4 core machine) for several minutes. The same query on all of our other ASA 12 systems (and on ASA 9 systems) runs in seconds or less. The data on the other systems is different in content but not structure.

Before the upgrade this same query ran quickly. Other queries run well (or at least no others ones have been reported yet).

What makes this server different?

asked 07 Dec '11, 18:55

alex_whitney's gravatar image

accept rate: 0%

well, I guess since I do not have enough 'reputation points' I cannot upload the execution plan file. Suggestions on how to get this file here would be appreciated.

(07 Dec '11, 18:58) alex_whitney
Replies hidden

Hi, try to upload it to some free file hosting service ;)

(08 Dec '11, 04:01) marchello
Be the first one to answer this question!
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: 07 Dec '11, 18:55

question was seen: 1,512 times

last updated: 08 Dec '11, 04:01