Post reply

Profiler Updates

  • December 9, 2014 at 12:27 am

    #312962

    Hi All

    Has anyone encountered an instance whereby SQL profiler in SQL 2012 RTM, performs updates, inserts and deletes when replayed?

    My understanding is that Profiler engine when replaying, will simulate user connections.

    Any advice would be greatly appreciated.

  • December 9, 2014 at 1:15 am

    #1763431

    Because the updates, inserts and deletes were in the workload that you're replaying? Whatever's in the workload will get run against the target server if you're replaying it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 9, 2014 at 1:19 am

    #1763434

    Thanks GilaMonster for your reply.

    Should it not only simulate the users actions and not actually perform their transactions?

  • December 9, 2014 at 1:32 am

    #1763439

    I think you're missing the point of a replay. A replay replays the workload against the target server. The entire workload. If that workload that you're replaying does data modifications, then they get replayed against the target server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply