Forum Replies Created

Viewing 15 posts - 361 through 375 (of 1,129 total)

  • RE: Sort works on one index and doesn't work on the other?

    Lynn Pettis (3/21/2013)

    sqldba_newbie (3/21/2013)

    I have a query which does a order by at the end.

    where WFID ='Something'

    Order by Rkey asc, NFD desc

    And my index is:

    CREATE NONCLUSTERED INDEX [temp] ON [dbo].[WrkFS]

    (

    [WFid]...

    March 21, 2013 at 11:09 am

    #1599490

  • RE: maxdop doesn't take effect?

    GilaMonster (3/19/2013)

    sqldba_newbie (3/19/2013)

    opc.three (3/19/2013)

    Even though estimated cost is well over 20, i still see query using all the cores?

    Cores, or threads? What exactly are you seeing that is making you...

    March 19, 2013 at 3:03 pm

    #1598645

  • RE: maxdop doesn't take effect?

    opc.three (3/19/2013)

    Even though estimated cost is well over 20, i still see query using all the cores?

    Cores, or threads? What exactly are you seeing that is making you think it...

    March 19, 2013 at 11:44 am

    #1598566

  • RE: maxdop doesn't take effect?

    opc.three (3/19/2013)

    sqldba_newbie (3/18/2013)

    opc.three (3/18/2013)

    Cost estimate compared to the Cost threshold for parallelism setting. The QO is a cost-based optimizer.

    Thanks. Do you mean Cost from estimate plan?

    Yes. There is only an...

    March 19, 2013 at 9:55 am

    #1598515

  • RE: maxdop doesn't take effect?

    opc.three (3/18/2013)

    Cost estimate compared to the Cost threshold for parallelism setting. The QO is a cost-based optimizer.

    Thanks. Do you mean Cost from estimate plan?

    March 18, 2013 at 10:23 pm

    #1598286

  • RE: maxdop doesn't take effect?

    Does sql engine calculate estimated cost and then spin in different threads?

    The Query Optimizer determines whether a plan will take advantage of parallelism.

    edit: clarify around "operator"[/quote]

    based on what?

    March 18, 2013 at 4:00 pm

    #1598201

  • RE: does index also change the output?

    I think i found the root cause here. The query which we were using brings top 15 records in asc order based on a column which has NULL or 0...

    March 4, 2013 at 9:00 am

    #1593046

  • RE: does index also change the output?

    Jeff Moden (3/1/2013)

    opc.three (3/1/2013)

    Jeff Moden (3/1/2013)

    Actually, the change of an index CAN very much change the result especially where UPDATEs are concerned.

    I think we covered the OP's question about SELECT...

    March 1, 2013 at 9:35 am

    #1592443

  • RE: Any thoughts on this process?

    Steve Thompson-454462 (2/19/2013)

    I'm assuming that total number of pages is a presentation-level metric indicating that at a rate of x records per page, you'll need to link to, and maybe...

    February 19, 2013 at 8:53 am

    #1589243

  • RE: How come my log file is still now able to grow?

    GilaMonster (2/13/2013)

    You've probably got a % growth like 10% (very bad default) and an IO subsystem under strain so that the log can't grow and zero-out the requested size in...

    February 13, 2013 at 8:59 am

    #1587527

  • RE: Any recommendations on this - Manage Statistics ?

    Balance (1/30/2013)

    If the db on server b is selected from only then there is no reason why the stats would be updated so the auto settings are not going to...

    January 30, 2013 at 3:23 pm

    #1582720

  • RE: very high CX packet waits

    GilaMonster (1/29/2013)

    If you want all queries to only use one processor, why not pull the other 23 out? That's essentially what you've done by setting maxdop to 1. It is...

    January 29, 2013 at 12:07 pm

    #1582292

  • RE: One SPID - Split into 127?

    GilaMonster (1/28/2013)

    sqldba_newbie (1/28/2013)

    GilaMonster (1/28/2013)

    Each operator in the parallel portion of the query plan can parallel up to maxdop/number of cores. They won't all be running, but they can all exist.

    I...

    January 28, 2013 at 5:14 pm

    #1581856

  • RE: One SPID - Split into 127?

    GilaMonster (1/28/2013)

    Each operator in the parallel portion of the query plan can parallel up to maxdop/number of cores. They won't all be running, but they can all exist.

    I see 127...

    January 28, 2013 at 3:41 pm

    #1581835

  • RE: very high CX packet waits

    Bhuvnesh (1/28/2013)

    Another thing which we need to consider is ,look for queries that run under parallelism and test them manually using different levels of DOP using the OPTION(MAXDOP n) query...

    January 28, 2013 at 9:27 am

    #1581684

Viewing 15 posts - 361 through 375 (of 1,129 total)