Multi-Threading: CheckTable

In Minion CheckDB you can process many tables at the same time. Let me show you how to easily setup Minion CheckDB to run a multi-threaded CheckTable run. If you’ve got the resources, you can process tables much faster now. To download Minion CheckDB and to see full docs, go to http://MinionWare.net

Notes for this video:

MC allows you to process multiple tables at once within a database.

Use InternalThreads in Minion.CheckDBSettingsDB (or DBInternalThreads in Minion.CheckDBSettingsServer, or Minion.CheckDBMaster @DBInternalThreads) to use multithreading.

While the DBCC CheckTable processes are running, you can see the multiple threads running at once in the Minion.CheckDBLogDetails table.

So if you have 100 tables and you set @DBInternalThreads = 4, as each table completes it will start up a new thread, so that it’s always processing 4 tables at once (until it runs out of tables).

Rate this video

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Leave a Reply