Forum Replies Created

Viewing 15 posts - 46 through 60 (of 100 total)

  • RE: Does alter index rebuild cause sp recompile?

    GilaMonster (12/14/2011)

    Lexa (12/14/2011)

    GilaMonster (12/14/2011)

    sroumel (12/14/2011)

    Maybe it doesn't matter,

    rebuild index triggers update statistics and then the plan recompiles

    Rebuild doesn't trigger update stats, it does the update as part of the...

    December 14, 2011 at 3:41 pm

    #1421669

  • RE: Does alter index rebuild cause sp recompile?

    GilaMonster (12/14/2011)

    sroumel (12/14/2011)

    Maybe it doesn't matter,

    rebuild index triggers update statistics and then the plan recompiles

    Rebuild doesn't trigger update stats, it does the update as part of the index rebuild,...

    December 14, 2011 at 3:17 pm

    #1421657

  • RE: Failover question

    Henrico Bekker (12/13/2011)

    from your question I assume you are running an Active/Active Cluster?

    when a resource in N1 fails, the whole resource group will fail over to N2, and if a...

    December 13, 2011 at 10:02 pm

    #1420997

  • RE: TempDB Test question

    GilaMonster (12/13/2011)

    Lexa (12/13/2011)

    What if the server does not come back up? If you can't connect to the server to alter tempdb location, what are the options?

    You can start...

    December 13, 2011 at 4:45 pm

    #1420939

  • RE: TempDB Test question

    Ninja's_RGR'us (12/13/2011)

    Err, you don't update master DB you alter tempdb location.

    Assuming this is a test server just come back here to debug. This is a relatively low risk action.

    That's...

    December 13, 2011 at 11:13 am

    #1420773

  • RE: DB Size Space Used vs. sp_spaceused for each table

    Looks like sp_spaceused is the mechanism used to get space used/available at a database level. Still not sure why there is a discrepancy. Can't imagine system objects to...

    December 5, 2011 at 8:24 am

    #1416726

  • RE: Table Hints question

    Grant Fritchey (12/1/2011)

    Lexa (11/30/2011)

    After going back and re-reading available info http://msdn.microsoft.com/en-us/library/ms187373.aspx still not sure on the best case usage of

    1. UPDLOCK [what happens when used in "insert...

    December 2, 2011 at 1:52 pm

    #1416178

  • RE: performance issue

    Grant Fritchey (11/23/2011)

    Lexa (11/23/2011)

    Grant Fritchey (11/23/2011)

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but...

    November 23, 2011 at 7:31 am

    #1412190

  • RE: performance issue

    Grant Fritchey (11/23/2011)

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S...

    November 23, 2011 at 5:56 am

    #1412093

  • RE: performance issue

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S locks becuase of...

    November 22, 2011 at 4:19 pm

    #1411903

  • RE: performance issue

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S locks becuase of the recompiles. ...

    November 22, 2011 at 2:16 pm

    #1411819

  • RE: performance issue

    Kudikai (11/22/2011)

    Has there been any hardware changes recently?

    I only ask since I had a similar issue come up once....and it was after I upgraded the memory on the server from...

    November 22, 2011 at 2:03 pm

    #1411808

  • RE: performance issue

    Grant Fritchey (11/22/2011)

    Lexa (11/22/2011)

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S locks becuase of the recompiles. ...

    November 22, 2011 at 12:28 pm

    #1411750

  • RE: performance issue

    So far "with recompile" seems to prevent massive issues with the proc where the server becomes unresponsive but it causes LCK_M_SCH_S locks becuase of the recompiles. Looks like it's...

    November 22, 2011 at 5:31 am

    #1411368

  • RE: performance issue

    Grant Fritchey (11/21/2011)

    Lexa (11/21/2011)

    Grant Fritchey (11/21/2011)

    Lexa (11/20/2011)

    Grant Fritchey (11/20/2011)

    Try getting the execution plan when it's slow and when it's fast. Compare the two. It could be bad parameter sniffing.

    But...

    November 21, 2011 at 9:14 am

    #1410813

Viewing 15 posts - 46 through 60 (of 100 total)