.::: bat script to simulate pararel query thread or Injector CPU in MSSQL SQL Server :::.

 

1. create script cpu_injector_mssql.bat  

@echo off
setlocal enabledelayedexpansion

REM ===== CONFIG DATABASE =====
set DB_HOST=10.10.10.7
set DB_PORT=1433
set DB_USER=sa
set DB_PASS=P@ssw0rd
set DB_NAME=teguhth

REM ===== QUERY =====
set QUERY=SELECT 'CPU Injector by Teguh Triharto',WAITFOR DELAY '00:00:00.001';
 
REM ===== INPUT =====
set /p TOTAL=Jumlah eksekusi (TOTAL): 
set /p PARALLEL=Jumlah paralel (THREAD): 

echo Menjalankan %TOTAL% query dengan %PARALLEL% paralel...
echo Query: %QUERY%

REM ===== INIT =====
set COUNT=0

:loop
if %COUNT% GEQ %TOTAL% goto done

set /a COUNT+=1

REM Jalankan paralel pakai start
start "" /b cmd /c ^
sqlcmd -S %DB_HOST%,%DB_PORT% -U %DB_USER% -P %DB_PASS% -d %DB_NAME% -Q "%QUERY%" >nul 2>&1

REM Batasi jumlah paralel
set /a mod=!COUNT! %% %PARALLEL%
if !mod! EQU 0 (
    timeout /t 1 >nul
)

echo Progress: !COUNT!/%TOTAL%

goto loop

:done
echo Selesai semua eksekusi.
pause

2. run 
 
3. pararel check cpu