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