The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
26.6k418575824
accept rate: 21%

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...
6.2k2890
accept rate: 30%

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
2

...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

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:

×2

question asked: 12 Sep '14, 15:28

question was seen: 496 times

last updated: 15 Sep '14, 13:02