I am performing CHECKDB, INDEXING, Update STATISTICS on DB.
I have multiple DB on my instance.
so Can i Perform CHECKDB Simultaneously(AT Same time) on Multiple DB. using different query windows.
I have 3 databases Sales_Data, HISTORY, APP_BANK each of size near by 800 GB.
Can I perform CheckDB at a time for all databases.
in one query windows
use Sales_Data
DBCC CHECKDB()
in another Query Windows
>use HISTORY
DBCC CHECKDB()
in next query window
use APP_BANK
DBCC CHECKDB()
and run all three windows simultaneous (at a time).
what will impact on server performance
also Can i Perform same for Indexing, and update statics.
What I have tried:
I am new in this profession so dont know impact of above on server performance (memory utilization, CPU utilization)
kindly help me