@Evdlaar Evdlaar released this Dec 30, 2016 · 2 commits to master since this release

Assets 3
  • Additional error handling on the SourceServer connection
  • Additional error handling during replay phase on TargetServer connection
  • Added parameter $SelectOnly.
    If set to $false not only SELECT statements will generate a replay .sql file but
    also UPDATE, INSERT and DELETE statements.
    By default the setting is set to $true which means only SELECT queries will
    be replayed against the TargetDatabase.
  • Added parameter $PlanConsistency.
    If set to $true an extra check will be ran to detect non-consistent execution plan generation on
    the TargetServer. This parameter requires the Query Store to be enabled on the TargetDatabase.
  • Added parameter $ComparePerf.
    If set to $true the last duration metrics of the query execution on the source and target and recorded
    and returned. This parameter requires the Query Store to be enabled on the TargetDatabase.
  • Added parameter $IncludeStatements.
    If set to $true the table returned by the ComparePerf parameter also includes the first 100
    characters of the query statement.

@Evdlaar Evdlaar released this Dec 19, 2016 · 3 commits to master since this release

Assets 3

The first public release of the Query Store Replay script!

You can find all the information you need to start running the script on the wiki: https://github.com/Evdlaar/QueryStoreReplay/wiki.