SQL Server, Columnstore, Data Platform & Community
Contact me
If you wish to contact me, then the best way to do it – is to write here. :)
102 thoughts on “Contact me”
Glen Schwickerath
Help!
I created a nonclustered columnstore index on a table with 240mil rows. Then, I performed many updates to the table. Subsequently, the weekly index maintenance process (Ola Hallengren) ran. Now there is a background process running (“Create Index”) that prevents me from dropping the index, dropping the table, etc. It’s also taking many locks.
I just want the columnstore index to be removed, but the background process prevents any other DDL.
Internet searches are not giving me any clues here.
it is not easy from the distance to determine what is the exact cause of that background process – I would make sure that the job has ended, that Tuple Mover is not running, etc …
There is a trace flag 643 that disables the tuple mover …
There has been reported SOME problems with the TM on SQL 2019 …
Help!
I created a nonclustered columnstore index on a table with 240mil rows. Then, I performed many updates to the table. Subsequently, the weekly index maintenance process (Ola Hallengren) ran. Now there is a background process running (“Create Index”) that prevents me from dropping the index, dropping the table, etc. It’s also taking many locks.
I just want the columnstore index to be removed, but the background process prevents any other DDL.
Internet searches are not giving me any clues here.
What can I do?
Thanks in advance,
Glen Schwickerath
Loved your SQL PASS sessions.
Hi Glen,
it is not easy from the distance to determine what is the exact cause of that background process – I would make sure that the job has ended, that Tuple Mover is not running, etc …
There is a trace flag 643 that disables the tuple mover …
There has been reported SOME problems with the TM on SQL 2019 …
Best regards,
Niko