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

It seems to be doing a bit of I/O but mostly waiting for resources while a SELECT * FROM sa_table_fragmentation ( owner_name = 'DBA' ) has rendered the database mostly unresponsive (on and off) for over an hour.

alt text

Update: After The Connection From Hell went away the server returned to normal responsiveness... but the UpdateStats connection is continuing to run, still doing (a bit of) I/O... but what?

alt text

asked 12 Sep '14, 15:28

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

edited 12 Sep '14, 16:09

Are we certain there just isn't a customer defined event by that name? It doesn't sound like a pre-12 type of internal connection and version 11.0.x generally did not display the connection name/description of internal connections for system or parallel worker connections.

permanent link

answered 15 Sep '14, 12:21

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%

What? No, of course not... oh, wait a minnit, I don't know, let me check... :)

(15 Sep '14, 12:27) Breck Carter
Replies hidden

...yes, indeed, four CREATE STATISTICS on the biggest tables, every three hours. Silly me...

alt text

(15 Sep '14, 13:00) Breck Carter
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: 12 Sep '14, 15:28

question was seen: 1,641 times

last updated: 15 Sep '14, 13:02