@ECHO OFF

SETLOCAL
SET SCENARIONAME=DB_Upgrade_Post

IF "%1"=="" (
  @ECHO Warning: SQLSERVER env var undefined - assuming a default SQL instance. 
  SET SQLSERVER=.\SQL2008R2
) ELSE (
  SET SQLSERVER=%1
)

REM ========== Setup ========== 
@ECHO %date% %time% - Starting scenario %SCENARIONAME%...

REM ========== Start ========== 
REM Start expensive query
@ECHO %date% %time% - Starting foreground queries...
SET /A NUMTHREADS=%NUMBER_OF_PROCESSORS%
.\ostress -E -iWorkload.sql -n%NUMTHREADS% -r25 -q -S%SQLSERVER%

REM @ECHO %date% %time% - Press ENTER to end the scenario. 
REM pause %NULLREDIRECT%
@ECHO %date% %time% - Shutting down...

REM ========== Cleanup ========== 
REM sqlcmd.exe -S%SQLSERVER% -E -dAdventureWorksDW2008R2 -ooutput\PreSetup.out -iPostSetup.sql %NULLREDIRECT%