Post reply

forcing parallelism when excecuted via asp.net

  • July 17, 2012 at 11:45 am

    #261224

    When executing a proc in SQL Management Studio (SMS), the query plan shows parallelism is used. However, the query plan is different in when executed by am asp.net program (dot net 4.0). Is there a way to force parallelism when executing via asp.net?

    thanks


    smv929

  • July 17, 2012 at 11:49 am

    #1513772

    nope no way to force it.

    you can use MAXDOP to limit the parallelism, but there's no MINDOP feature.

    if the execution plans were the same, it should use the same paralell query plan that was saved, but things like ansi settings and stuff can make the code us it's own plan instead of one you know exists.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 17, 2012 at 12:00 pm

    #1513778

    Thanks for the reply.

    BTW, I forgot to mention that it WILL reuse the plan query plan that has parallelism -- if it exists. I was trying to plan for the case where that query plan doesn't exist.

    Thx


    smv929

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

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