Server Driven Workload
When enabled retrieves iteration and command settings iteratively dynamically at thread level.
Stored procedure name for retrieving iteration settings is “Stored Procedure Prefix”_IterationSettings_Proc. Stored procedure name for retrieving command settings is “Stored Procedure Prefix”_CommandSettings_Proc.
In the below example different connection string, SQL command and iteration count are supplied to threads 1 and 2.
The below example uses “Data Source=SQLWorkshops\SQL2012;Database=test;Integrated Security=true” as “Connection String” and “SQLTest1” as “Stored Procedure Prefix” in test database.
SQLTest1_IterationSettings_Proc and SQLTest1_CommandSettings_Proc:
use test
go
drop proc SQLTest1_IterationSettings_Proc
go
drop proc SQLTest1_CommandSettings_Proc
go
drop table SQLTest1_IterationSettings_Log_Table
go
drop table SQLTest1_CommandSettings_Log_Table
go
create table SQLTest1_IterationSettings_Log_Table (id int identity primary key, ctime datetime, SQLTestInstanceGUID uniqueidentifier, SQLTestWorkloadGUID uniqueidentifier, SQLTestWorkloadName nvarchar(256), Workload int, Connection int, Thread int, AbortWorkloadOnError bit, CancelQueryOnDurationExpiration bit, AllowFindAndReplaceInSQLCommand bit, AllowFindAndReplaceInConnectionString bit, IncludeConnectionInformationInResults bit, ApplicationNamePrefix nvarchar(max), NumberOfConnectionRetries int, DelayBeforeConnectionRetry int, NumberOfCommandRetries int, DelayBeforeCommandRetry int, TraceLevel int, LogErrors bit, LogMessages bit, LogResults bit, LogTrace bit, LogReport bit, EvaluateDBCalls bit, EvaluateResults bit, EvaluateChecksum bit, EvaluateRecordsAffected bit, IterationsConfigured int, ConnectionString nvarchar(max), SQLCommands nvarchar(max), ConnectBeforeEveryIteration bit, BeginTransactionOnceForAllIterations bit, BeginTransactionBeforeEveryIteration bit, CommitTransaction bit, ExecuteNonQuery bit, ExecuteRead bit, StoredProcedure bit, ExecuteNextResult bit, RetrieveInfoMessages bit, FetchAllRows bit, FetchTopRows int, FetchAllResults bit, FetchTopResults int, ParameterizeQuery bit, PrepareQuery bit, SubstituteValues bit, AllowIgnoreErrors bit, CommandTimeout int, ShowResults bit, EnableProviderStatistics bit, TransactionIsolationLevel nvarchar(max), DelayBeforeFirstIterationFrom int, DelayBeforeFirstIterationTo int, DelayBeforeIterationFrom int, DelayBeforeIterationTo int, DelayBeforeConnectFrom int, DelayBeforeConnectTo int, DelayBeforeDisconnectFrom int, DelayBeforeDisconnectTo int, DelayBeforeBeginTransactionFrom int, DelayBeforeBeginTransactionTo int, DelayBeforeCommitTransactionFrom int, DelayBeforeCommitTransactionTo int, DelayBeforeRollbackTransactionFrom int, DelayBeforeRollbackTransactionTo int, DelayBeforeExecuteNonQueryFrom int, DelayBeforeExecuteNonQueryTo int, DelayBeforeExecuteReaderFrom int, DelayBeforeExecuteReaderTo int, DelayBeforeExecuteReadFrom int, DelayBeforeExecuteReadTo int, DelayBeforeExecuteNextResultFrom int, DelayBeforeExecuteNextResultTo int, Response int)
go
create table SQLTest1_CommandSettings_Log_Table (id int identity primary key, ctime datetime, SQLTestInstanceGUID uniqueidentifier, SQLTestWorkloadGUID uniqueidentifier, SQLTestWorkloadName nvarchar(256), Workload int, Connection int, ConnectionString nvarchar(max), Thread int, BatchIndex int, AbortWorkloadOnError bit, CancelQueryOnDurationExpiration bit, AllowFindAndReplaceInSQLCommand bit, AllowFindAndReplaceInConnectionString bit, IncludeConnectionInformationInResults bit, TraceLevel int, LogErrors bit, LogMessages bit, LogResults bit, LogTrace bit, LogReport bit, EvaluateDBCalls bit, EvaluateResults bit, EvaluateChecksum bit, EvaluateRecordsAffected bit, SQLCommand nvarchar(max), ExecuteNonQuery bit, ExecuteRead bit, StoredProcedure bit, ExecuteNextResult bit, FetchAllRows bit, FetchTopRows int, FetchAllResults bit, FetchTopResults int, ParameterizeQuery bit, PrepareQuery bit, SubstituteValues bit, AllowIgnoreErrors bit, CommandTimeout int, ShowResults bit, DelayBeforeExecuteNonQueryFrom int, DelayBeforeExecuteNonQueryTo int, DelayBeforeExecuteReaderFrom int, DelayBeforeExecuteReaderTo int, DelayBeforeExecuteReadFrom int, DelayBeforeExecuteReadTo int, DelayBeforeExecuteNextResultFrom int, DelayBeforeExecuteNextResultTo int, Response int)
go
create proc SQLTest1_IterationSettings_Proc @SQLTestInstanceGUID uniqueidentifier, @SQLTestWorkloadGUID uniqueidentifier, @SQLTestWorkloadName nvarchar(256), @Workload int, @Connection int, @Thread int, @AbortWorkloadOnError bit, @CancelQueryOnDurationExpiration bit, @AllowFindAndReplaceInSQLCommand bit, @AllowFindAndReplaceInConnectionString bit, @IncludeConnectionInformationInResults bit, @ApplicationNamePrefix nvarchar(max), @NumberOfConnectionRetries int, @DelayBeforeConnectionRetry int, @NumberOfCommandRetries int, @DelayBeforeCommandRetry int, @TraceLevel int, @LogErrors bit, @LogMessages bit, @LogResults bit, @LogTrace bit, @LogReport bit, @EvaluateDBCalls bit, @EvaluateResults bit, @EvaluateChecksum bit, @EvaluateRecordsAffected bit, @IterationsConfigured int, @ConnectionString nvarchar(max), @SQLCommands nvarchar(max), @ConnectBeforeEveryIteration bit, @BeginTransactionOnceForAllIterations bit, @BeginTransactionBeforeEveryIteration bit, @CommitTransaction bit, @ExecuteNonQuery bit, @ExecuteRead bit, @StoredProcedure bit, @ExecuteNextResult bit, @RetrieveInfoMessages bit, @FetchAllRows bit, @FetchTopRows int, @FetchAllResults bit, @FetchTopResults int, @ParameterizeQuery bit, @PrepareQuery bit, @SubstituteValues bit, @AllowIgnoreErrors bit, @CommandTimeout int, @ShowResults bit, @EnableProviderStatistics bit, @TransactionIsolationLevel nvarchar(max), @DelayBeforeFirstIterationFrom int, @DelayBeforeFirstIterationTo int, @DelayBeforeIterationFrom int, @DelayBeforeIterationTo int, @DelayBeforeConnectFrom int, @DelayBeforeConnectTo int, @DelayBeforeDisconnectFrom int, @DelayBeforeDisconnectTo int, @DelayBeforeBeginTransactionFrom int, @DelayBeforeBeginTransactionTo int, @DelayBeforeCommitTransactionFrom int, @DelayBeforeCommitTransactionTo int, @DelayBeforeRollbackTransactionFrom int, @DelayBeforeRollbackTransactionTo int, @DelayBeforeExecuteNonQueryFrom int, @DelayBeforeExecuteNonQueryTo int, @DelayBeforeExecuteReaderFrom int, @DelayBeforeExecuteReaderTo int, @DelayBeforeExecuteReadFrom int, @DelayBeforeExecuteReadTo int, @DelayBeforeExecuteNextResultFrom int, @DelayBeforeExecuteNextResultTo int
as
begin
declare @tab1 table (id int)
declare @tab2 table (id int)
insert into SQLTest1_IterationSettings_Log_Table (ctime, SQLTestInstanceGUID, SQLTestWorkloadGUID, SQLTestWorkloadName, Workload, Connection, Thread, AbortWorkloadOnError, CancelQueryOnDurationExpiration, AllowFindAndReplaceInSQLCommand, AllowFindAndReplaceInConnectionString, IncludeConnectionInformationInResults, ApplicationNamePrefix, NumberOfConnectionRetries, DelayBeforeConnectionRetry, NumberOfCommandRetries, DelayBeforeCommandRetry, TraceLevel, LogErrors, LogMessages, LogResults, LogTrace, LogReport, EvaluateDBCalls, EvaluateResults, EvaluateChecksum, EvaluateRecordsAffected, IterationsConfigured, ConnectionString, SQLCommands, ConnectBeforeEveryIteration, BeginTransactionOnceForAllIterations, BeginTransactionBeforeEveryIteration, CommitTransaction, ExecuteNonQuery, ExecuteRead, StoredProcedure, ExecuteNextResult, RetrieveInfoMessages, FetchAllRows, FetchTopRows, FetchAllResults, FetchTopResults, ParameterizeQuery, PrepareQuery, SubstituteValues, AllowIgnoreErrors, CommandTimeout, ShowResults, EnableProviderStatistics, TransactionIsolationLevel, DelayBeforeFirstIterationFrom, DelayBeforeFirstIterationTo, DelayBeforeIterationFrom, DelayBeforeIterationTo, DelayBeforeConnectFrom, DelayBeforeConnectTo, DelayBeforeDisconnectFrom, DelayBeforeDisconnectTo, DelayBeforeBeginTransactionFrom, DelayBeforeBeginTransactionTo, DelayBeforeCommitTransactionFrom, DelayBeforeCommitTransactionTo, DelayBeforeRollbackTransactionFrom, DelayBeforeRollbackTransactionTo, DelayBeforeExecuteNonQueryFrom, DelayBeforeExecuteNonQueryTo, DelayBeforeExecuteReaderFrom, DelayBeforeExecuteReaderTo, DelayBeforeExecuteReadFrom, DelayBeforeExecuteReadTo, DelayBeforeExecuteNextResultFrom, DelayBeforeExecuteNextResultTo) output inserted.id into @tab1 select getdate(), @SQLTestInstanceGUID, @SQLTestWorkloadGUID, @SQLTestWorkloadName, @Workload, @Connection, @Thread, @AbortWorkloadOnError, @CancelQueryOnDurationExpiration, @AllowFindAndReplaceInSQLCommand, @AllowFindAndReplaceInConnectionString, @IncludeConnectionInformationInResults, @ApplicationNamePrefix, @NumberOfConnectionRetries, @DelayBeforeConnectionRetry, @NumberOfCommandRetries, @DelayBeforeCommandRetry, @TraceLevel, @LogErrors, @LogMessages, @LogResults, @LogTrace, @LogReport, @EvaluateDBCalls, @EvaluateResults, @EvaluateChecksum, @EvaluateRecordsAffected, @IterationsConfigured, @ConnectionString, @SQLCommands, @ConnectBeforeEveryIteration, @BeginTransactionOnceForAllIterations, @BeginTransactionBeforeEveryIteration, @CommitTransaction, @ExecuteNonQuery, @ExecuteRead, @StoredProcedure, @ExecuteNextResult, @RetrieveInfoMessages, @FetchAllRows, @FetchTopRows, @FetchAllResults, @FetchTopResults, @ParameterizeQuery, @PrepareQuery, @SubstituteValues, @AllowIgnoreErrors, @CommandTimeout, @ShowResults, @EnableProviderStatistics, @TransactionIsolationLevel, @DelayBeforeFirstIterationFrom, @DelayBeforeFirstIterationTo, @DelayBeforeIterationFrom, @DelayBeforeIterationTo, @DelayBeforeConnectFrom, @DelayBeforeConnectTo, @DelayBeforeDisconnectFrom, @DelayBeforeDisconnectTo, @DelayBeforeBeginTransactionFrom, @DelayBeforeBeginTransactionTo, @DelayBeforeCommitTransactionFrom, @DelayBeforeCommitTransactionTo, @DelayBeforeRollbackTransactionFrom, @DelayBeforeRollbackTransactionTo, @DelayBeforeExecuteNonQueryFrom, @DelayBeforeExecuteNonQueryTo, @DelayBeforeExecuteReaderFrom, @DelayBeforeExecuteReaderTo, @DelayBeforeExecuteReadFrom, @DelayBeforeExecuteReadTo, @DelayBeforeExecuteNextResultFrom, @DelayBeforeExecuteNextResultTo
if (@Thread = 1)
begin
select @ConnectionString = 'Data Source=SQLWorkshops\SQL2014;Database=master;Integrated Security=true;Pooling=false',
@SQLCommands = 'select @@version',
@IterationsConfigured = 50
end
else if (@Thread = 2)
begin
select @ConnectionString = 'Data Source=SQLWorkshops\SQL2012;Database=master;Integrated Security=true;Pooling=false',
@SQLCommands = 'select @@version',
@IterationsConfigured = 60
end
else
begin
select @ConnectionString = 'Data Source=SQLWorkshops\SQL2014;Database=master;Integrated Security=true;Pooling=false',
@SQLCommands = 'select @@version',
@IterationsConfigured = 1
end
insert into SQLTest1_IterationSettings_Log_Table (ctime, SQLTestInstanceGUID, SQLTestWorkloadGUID, SQLTestWorkloadName, Workload, Connection, Thread, AbortWorkloadOnError, CancelQueryOnDurationExpiration, AllowFindAndReplaceInSQLCommand, AllowFindAndReplaceInConnectionString, IncludeConnectionInformationInResults, ApplicationNamePrefix, NumberOfConnectionRetries, DelayBeforeConnectionRetry, NumberOfCommandRetries, DelayBeforeCommandRetry, TraceLevel, LogErrors, LogMessages, LogResults, LogTrace, LogReport, EvaluateDBCalls, EvaluateResults, EvaluateChecksum, EvaluateRecordsAffected, IterationsConfigured, ConnectionString, SQLCommands, ConnectBeforeEveryIteration, BeginTransactionOnceForAllIterations, BeginTransactionBeforeEveryIteration, CommitTransaction, ExecuteNonQuery, ExecuteRead, StoredProcedure, ExecuteNextResult, RetrieveInfoMessages, FetchAllRows, FetchTopRows, FetchAllResults, FetchTopResults, ParameterizeQuery, PrepareQuery, SubstituteValues, AllowIgnoreErrors, CommandTimeout, ShowResults, EnableProviderStatistics, TransactionIsolationLevel, DelayBeforeFirstIterationFrom, DelayBeforeFirstIterationTo, DelayBeforeIterationFrom, DelayBeforeIterationTo, DelayBeforeConnectFrom, DelayBeforeConnectTo, DelayBeforeDisconnectFrom, DelayBeforeDisconnectTo, DelayBeforeBeginTransactionFrom, DelayBeforeBeginTransactionTo, DelayBeforeCommitTransactionFrom, DelayBeforeCommitTransactionTo, DelayBeforeRollbackTransactionFrom, DelayBeforeRollbackTransactionTo, DelayBeforeExecuteNonQueryFrom, DelayBeforeExecuteNonQueryTo, DelayBeforeExecuteReaderFrom, DelayBeforeExecuteReaderTo, DelayBeforeExecuteReadFrom, DelayBeforeExecuteReadTo, DelayBeforeExecuteNextResultFrom, DelayBeforeExecuteNextResultTo) output inserted.id into @tab2 select getdate(), @SQLTestInstanceGUID, @SQLTestWorkloadGUID, @SQLTestWorkloadName, @Workload, @Connection, @Thread, @AbortWorkloadOnError, @CancelQueryOnDurationExpiration, @AllowFindAndReplaceInSQLCommand, @AllowFindAndReplaceInConnectionString, @IncludeConnectionInformationInResults, @ApplicationNamePrefix, @NumberOfConnectionRetries, @DelayBeforeConnectionRetry, @NumberOfCommandRetries, @DelayBeforeCommandRetry, @TraceLevel, @LogErrors, @LogMessages, @LogResults, @LogTrace, @LogReport, @EvaluateDBCalls, @EvaluateResults, @EvaluateChecksum, @EvaluateRecordsAffected, @IterationsConfigured, @ConnectionString, @SQLCommands, @ConnectBeforeEveryIteration, @BeginTransactionOnceForAllIterations, @BeginTransactionBeforeEveryIteration, @CommitTransaction, @ExecuteNonQuery, @ExecuteRead, @StoredProcedure, @ExecuteNextResult, @RetrieveInfoMessages, @FetchAllRows, @FetchTopRows, @FetchAllResults, @FetchTopResults, @ParameterizeQuery, @PrepareQuery, @SubstituteValues, @AllowIgnoreErrors, @CommandTimeout, @ShowResults, @EnableProviderStatistics, @TransactionIsolationLevel, @DelayBeforeFirstIterationFrom, @DelayBeforeFirstIterationTo, @DelayBeforeIterationFrom, @DelayBeforeIterationTo, @DelayBeforeConnectFrom, @DelayBeforeConnectTo, @DelayBeforeDisconnectFrom, @DelayBeforeDisconnectTo, @DelayBeforeBeginTransactionFrom, @DelayBeforeBeginTransactionTo, @DelayBeforeCommitTransactionFrom, @DelayBeforeCommitTransactionTo, @DelayBeforeRollbackTransactionFrom, @DelayBeforeRollbackTransactionTo, @DelayBeforeExecuteNonQueryFrom, @DelayBeforeExecuteNonQueryTo, @DelayBeforeExecuteReaderFrom, @DelayBeforeExecuteReaderTo, @DelayBeforeExecuteReadFrom, @DelayBeforeExecuteReadTo, @DelayBeforeExecuteNextResultFrom, @DelayBeforeExecuteNextResultTo
update SQLTest1_IterationSettings_Log_Table set Response = (select id from @tab2) where id = (select id from @tab1)
select IterationsConfigured, ConnectionString from SQLTest1_IterationSettings_Log_Table where id = (select id from @tab2)
end
go
create proc SQLTest1_CommandSettings_Proc @SQLTestInstanceGUID uniqueidentifier, @SQLTestWorkloadGUID uniqueidentifier, @SQLTestWorkloadName nvarchar(256), @Workload int, @Connection int, @ConnectionString nvarchar(max), @Thread int, @BatchIndex int, @AbortWorkloadOnError bit, @CancelQueryOnDurationExpiration bit, @AllowFindAndReplaceInSQLCommand bit, @AllowFindAndReplaceInConnectionString bit, @IncludeConnectionInformationInResults bit, @TraceLevel int, @LogErrors bit, @LogMessages bit, @LogResults bit, @LogTrace bit, @LogReport bit, @EvaluateDBCalls bit, @EvaluateResults bit, @EvaluateChecksum bit, @EvaluateRecordsAffected bit, @SQLCommand nvarchar(max), @ExecuteNonQuery bit, @ExecuteRead bit, @StoredProcedure bit, @ExecuteNextResult bit, @FetchAllRows bit, @FetchTopRows int, @FetchAllResults bit, @FetchTopResults int, @ParameterizeQuery bit, @PrepareQuery bit, @SubstituteValues bit, @AllowIgnoreErrors bit, @CommandTimeout int, @ShowResults bit, @DelayBeforeExecuteNonQueryFrom int, @DelayBeforeExecuteNonQueryTo int, @DelayBeforeExecuteReaderFrom int, @DelayBeforeExecuteReaderTo int, @DelayBeforeExecuteReadFrom int, @DelayBeforeExecuteReadTo int, @DelayBeforeExecuteNextResultFrom int, @DelayBeforeExecuteNextResultTo int
as
begin
declare @tab1 table (id int)
declare @tab2 table (id int)
insert into SQLTest1_CommandSettings_Log_Table (ctime, SQLTestInstanceGUID, SQLTestWorkloadGUID, SQLTestWorkloadName, Workload, Connection, ConnectionString, Thread, BatchIndex, AbortWorkloadOnError, CancelQueryOnDurationExpiration, AllowFindAndReplaceInSQLCommand, AllowFindAndReplaceInConnectionString, IncludeConnectionInformationInResults, TraceLevel, LogErrors, LogMessages, LogResults, LogTrace, LogReport, EvaluateDBCalls, EvaluateResults, EvaluateChecksum, EvaluateRecordsAffected, SQLCommand, ExecuteNonQuery, ExecuteRead, StoredProcedure, ExecuteNextResult, FetchAllRows, FetchTopRows, FetchAllResults, FetchTopResults, ParameterizeQuery, PrepareQuery, SubstituteValues, AllowIgnoreErrors, CommandTimeout, ShowResults, DelayBeforeExecuteNonQueryFrom, DelayBeforeExecuteNonQueryTo, DelayBeforeExecuteReaderFrom, DelayBeforeExecuteReaderTo, DelayBeforeExecuteReadFrom, DelayBeforeExecuteReadTo, DelayBeforeExecuteNextResultFrom, DelayBeforeExecuteNextResultTo) output inserted.id into @tab1 select getdate(), @SQLTestInstanceGUID, @SQLTestWorkloadGUID, @SQLTestWorkloadName, @Workload, @Connection, @ConnectionString, @Thread, @BatchIndex, @AbortWorkloadOnError, @CancelQueryOnDurationExpiration, @AllowFindAndReplaceInSQLCommand, @AllowFindAndReplaceInConnectionString, @IncludeConnectionInformationInResults, @TraceLevel, @LogErrors, @LogMessages, @LogResults, @LogTrace, @LogReport, @EvaluateDBCalls, @EvaluateResults, @EvaluateChecksum, @EvaluateRecordsAffected, @SQLCommand, @ExecuteNonQuery, @ExecuteRead, @StoredProcedure, @ExecuteNextResult, @FetchAllRows, @FetchTopRows, @FetchAllResults, @FetchTopResults, @ParameterizeQuery, @PrepareQuery, @SubstituteValues, @AllowIgnoreErrors, @CommandTimeout, @ShowResults, @DelayBeforeExecuteNonQueryFrom, @DelayBeforeExecuteNonQueryTo, @DelayBeforeExecuteReaderFrom, @DelayBeforeExecuteReaderTo, @DelayBeforeExecuteReadFrom, @DelayBeforeExecuteReadTo, @DelayBeforeExecuteNextResultFrom, @DelayBeforeExecuteNextResultTo
if (@BatchIndex <= 6 and @Thread in (1, 2))
begin
if (@BatchIndex = 1)
begin
select @SQLCommand = 'use test if exists (select * from sys.objects where name = ''tab73' + '_' + cast(@Workload as varchar(max)) + '_' + cast(@Connection as varchar(max)) + '_' + cast(@Thread as varchar(max))+ ''') drop table tab73' + '_' + cast(@Workload as varchar(max)) + '_' + cast(@Connection as varchar(max)) + '_' + cast(@Thread as varchar(max))+ '',
@ExecuteNonQuery = 1,
@ShowResults = 0
end
else if (@BatchIndex = 2)
begin
select @SQLCommand = 'use test create table tab73' + '_' + cast(@Workload as varchar(max)) + '_' + cast(@Connection as varchar(max)) + '_' + cast(@Thread as varchar(max))+ ' (c1 int primary key clustered, c2 int, c3 char(2000)) ',
@ExecuteNonQuery = 1,
@ShowResults = 0
end
else if (@BatchIndex = 3)
begin
select @SQLCommand = 'use test insert into tab73' + '_' + cast(@Workload as varchar(max)) + '_' + cast(@Connection as varchar(max)) + '_' + cast(@Thread as varchar(max))+ ' values (1, 1, replicate(''a'', 2000))',
@ExecuteNonQuery = 1,
@ShowResults = 0
end
else if (@BatchIndex = 4)
begin
select @SQLCommand = 'use test update tab73' + '_' + cast(@Workload as varchar(max)) + '_' + cast(@Connection as varchar(max)) + '_' + cast(@Thread as varchar(max))+ ' set c3 = replicate(''b'', 2) where c1 = 1',
@ExecuteNonQuery = 1,
@ShowResults = 0
end
else if (@BatchIndex = 5)
begin
select @SQLCommand = 'use test select c1, c2, c3 from tab73' + '_' + cast(@Workload as varchar(max)) + '_' + cast(@Connection as varchar(max)) + '_' + cast(@Thread as varchar(max))+ ' where c1 = 1',
@ExecuteNonQuery = 0,
@ShowResults = 1
end
else if (@BatchIndex = 6)
begin
select @SQLCommand = 'use test delete tab73' + '_' + cast(@Workload as varchar(max)) + '_' + cast(@Connection as varchar(max)) + '_' + cast(@Thread as varchar(max))+ ' where c1 = 1',
@ExecuteNonQuery = 1,
@ShowResults = 0
end
insert into SQLTest1_CommandSettings_Log_Table (ctime, SQLTestInstanceGUID, SQLTestWorkloadGUID, SQLTestWorkloadName, Workload, Connection, ConnectionString, Thread, BatchIndex, AbortWorkloadOnError, CancelQueryOnDurationExpiration, AllowFindAndReplaceInSQLCommand, AllowFindAndReplaceInConnectionString, IncludeConnectionInformationInResults, TraceLevel, LogErrors, LogMessages, LogResults, LogTrace, LogReport, EvaluateDBCalls, EvaluateResults, EvaluateChecksum, EvaluateRecordsAffected, SQLCommand, ExecuteNonQuery, ExecuteRead, StoredProcedure, ExecuteNextResult, FetchAllRows, FetchTopRows, FetchAllResults, FetchTopResults, ParameterizeQuery, PrepareQuery, SubstituteValues, AllowIgnoreErrors, CommandTimeout, ShowResults, DelayBeforeExecuteNonQueryFrom, DelayBeforeExecuteNonQueryTo, DelayBeforeExecuteReaderFrom, DelayBeforeExecuteReaderTo, DelayBeforeExecuteReadFrom, DelayBeforeExecuteReadTo, DelayBeforeExecuteNextResultFrom, DelayBeforeExecuteNextResultTo) output inserted.id into @tab2 select getdate(), @SQLTestInstanceGUID, @SQLTestWorkloadGUID, @SQLTestWorkloadName, @Workload, @Connection, @ConnectionString, @Thread, @BatchIndex, @AbortWorkloadOnError, @CancelQueryOnDurationExpiration, @AllowFindAndReplaceInSQLCommand, @AllowFindAndReplaceInConnectionString, @IncludeConnectionInformationInResults, @TraceLevel, @LogErrors, @LogMessages, @LogResults, @LogTrace, @LogReport, @EvaluateDBCalls, @EvaluateResults, @EvaluateChecksum, @EvaluateRecordsAffected, @SQLCommand, @ExecuteNonQuery, @ExecuteRead, @StoredProcedure, @ExecuteNextResult, @FetchAllRows, @FetchTopRows, @FetchAllResults, @FetchTopResults, @ParameterizeQuery, @PrepareQuery, @SubstituteValues, @AllowIgnoreErrors, @CommandTimeout, @ShowResults, @DelayBeforeExecuteNonQueryFrom, @DelayBeforeExecuteNonQueryTo, @DelayBeforeExecuteReaderFrom, @DelayBeforeExecuteReaderTo, @DelayBeforeExecuteReadFrom, @DelayBeforeExecuteReadTo, @DelayBeforeExecuteNextResultFrom, @DelayBeforeExecuteNextResultTo
update SQLTest1_CommandSettings_Log_Table set Response = (select id from @tab2) where id = (select id from @tab1)
select SQLCommand, ExecuteNonQuery, ShowResults from SQLTest1_CommandSettings_Log_Table where id = (select id from @tab2)
end
end
go
select * from SQLTest1_IterationSettings_Log_Table
go
select * from SQLTest1_CommandSettings_Log_Table
go
Please help us improve this page by entering your comments and suggestions below: