2

I created an index for my ginormous (250 million+ records) SQL table and it has been several hours. How can I tell if it's still going? Or if the process is frozen/dead?

If you have an answer about how to check if SQL (SQLite3) is still running in general, that'd be super. However, if you have an approach for my specific case, that's good as well. This is what I did.

CREATE INDEX index_name ON table_name(column_name);

j08691
  • 204,283
  • 31
  • 260
  • 272
puifais
  • 738
  • 2
  • 9
  • 20

2 Answers2

1

You have to use some monitoring mechanism of your OS (top, Task Manager, etc.) to check whether the process is using CPU or disk I/O.

CL.
  • 173,858
  • 17
  • 217
  • 259
-1

Have you tried to check:

sp_who2

You can also use active to see active connections:

sp_who2 active
RFerreira
  • 39
  • 1
  • 1
  • 6