| 12345678910111213141516171819202122232425262728 |
- @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%
|
