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:


  • Captcha image