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

alex_whitney
46446
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

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:

×18

question asked: 07 Dec '11, 18:55

question was seen: 1,426 times

last updated: 08 Dec '11, 04:01