Post reply

Top 10 Wait State Issues Reporter

  • November 27, 2012 at 1:05 pm

    #1562833

    I agree, the newer code is displaying the data much better than my code did. My apologies.

    Hats off to you all!!! 🙂

    Thanks,

    Rudy

    Rudy

  • November 27, 2012 at 1:21 pm

    #1562839

    I know that there is newer code but I wanted to help the person who asked about why there are the two straggler records. It comes from the fetch statement not being directed to a declared variable.

    To see what affect this has try doing the following as a learning experience:

    Add this line just below where it says "set nocount on"

    DECLARE @blah varchar(50)

    Next, add this to the end of the two fetch statements:

    into @blah

    Now @blah holds the unneeded value instead of the screen

    That was a great question to ask!

    Tony Trus

  • November 28, 2012 at 6:52 am

    #1563113

    Thanks, that was what I was wondering. I didn't know if it meant something important, like "these are the two wait states that are causing the biggest problem" or something. I'll just refer to the table.

    Thanks

    Nick

  • November 28, 2012 at 7:08 am

    #1563127

    Tony Trus;

    Ah, thanks! I tried that and those two extra results disappeared. It makes sense that they are dumped into that variable. Thanks for providing the example!

    Nick

  • July 25, 2013 at 4:24 am

    #1635658

    Hi. I'm getting a LCK_RIn_NL wait type in the project I'm currently working on. Can anybody help me solve this? Thanks a whole lot.

Viewing 5 posts - 31 through 34 (of 34 total)

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