Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Top 10 Wait State Issues Reporter Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 1:05 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:58 AM
Points: 313, Visits: 1,111
I agree, the newer code is displaying the data much better than my code did. My apologies.

Hats off to you all!!!

Thanks,

Rudy



Post #1389389
Posted Tuesday, November 27, 2012 1:21 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 28, 2014 11:16 AM
Points: 27, Visits: 77
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
Post #1389396
Posted Wednesday, November 28, 2012 6:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:39 AM
Points: 301, Visits: 199
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
Post #1389738
Posted Wednesday, November 28, 2012 7:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:39 AM
Points: 301, Visits: 199
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
Post #1389753
Posted Thursday, July 25, 2013 4:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 25, 2013 6:49 AM
Points: 2, Visits: 2
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.
Post #1477426
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse