Post reply

what queries are Hyper Threaded and what are not??

  • November 13, 2006 at 2:06 pm

    #114189

    how could i find this information?

    _________________________

  • November 14, 2006 at 5:17 am

    #671569

    you need to look at query plan and look for parallelism operator. I am not able to think of an easy way.

     

  • November 14, 2006 at 2:07 pm

    #671768

    so no chance to query this information from

    system tables or other wise?

    nuts!

    _________________________

  • November 14, 2006 at 2:13 pm

    #671772

    I think you can save the query plan in a trace.  Then save the trace in a table and then search for the operator in question... No idea on how to do that however.  But it's worth searching for.

     

    Keep us posted please!!

  • November 14, 2006 at 2:22 pm

    #671776

    there must be a way...

    i want to track Hyper Threaded queries and get see

    those transactions so i know which ones to set the

    MAXDOP hint on.

    _________________________

  • November 14, 2006 at 2:26 pm

    #671777

    I just gave you a way.  But I have no idea how to execute it as I've never done it.

     

    You can search for profiler and execution plan as a start.  That should give you some leads...  I can't you much more than that at the moment!

  • November 14, 2006 at 2:35 pm

    #671781

    i was thinking out loud...

    not really a duplicate question... and figure

    i would mention why i was looking.

    _________________________

  • November 14, 2006 at 2:38 pm

    #671785

    Alright... just keep us posted.  I'm curious to see how you'll solve this one .

  • November 16, 2006 at 2:34 pm

    #672465

    question is what exact operator would i be looking for...

    ie; Distribute Streams or Parallelism

    _________________________

  • November 16, 2006 at 2:37 pm

    #672467

    No idea.  Find a query that uses parallilisn.  Run it and catch the plan with profiler... Then check out the exact word to search for.  I'm sorry I can't help more but I have no multi proc machine around here.

  • November 16, 2006 at 3:40 pm

    #672485

    is no problem... turns out the Parallelism Operator innitiates

    the Distribute Streams Operator which in turns runs the threads

    (steams) against the various CPU's available.

    still checking this out... i'll post any results.

    _________________________

Viewing 11 posts - 1 through 10 (of 10 total)

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