Post reply

Option 'include aktual execution plan' slows query down

  • April 5, 2011 at 7:15 am

    #248974

    Hello

    If I run a query (any query) in the SQL Server Manager and turn on the option 'include aktual execution plan', it runs about 10-15 times slower than the exact same query would run without the 'include aktual execution plan' option.

    Any idea what that could be? This SQL Server 2008 R2 instance runs on a virtual Windows Server 2008 R2 and is a developer maschine, there is no other activity on this maschine.

    thanks

    Heinz

  • April 5, 2011 at 7:20 am

    #1307430

    Got any function call or rbar or while loops in the code anywhere (could be triggers)?

  • April 5, 2011 at 8:03 am

    #1307460

    No, It also happens in Statements like:

    Select * from Table

  • April 5, 2011 at 8:05 am

    #1307462

    Then the select is the problem unless you have some sort of bug in your video card.

    I have noticed a slow down when showing plans, but showing only 1-2 plans never slowed anything down (ok maybe 1-2 seconds, but nothing more).

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

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