Home Forums SQL Server 2005 Administering multiple execution plans - not sure why? RE: multiple execution plans - not sure why?

  • March 29, 2013 at 1:19 pm

    #1602135

    sqldba_newbie (3/29/2013)

    I can see that every time it is creating a new execution plan. I took the stored procedure ,opened two sessions in ssms and executed the sproc. I do see it is creating two new plans.

    How are you seeing that?

    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