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: Friday, July 18, 2014 12:37 PM
Points: 312, Visits: 1,098
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: Wednesday, June 18, 2014 11:40 AM
Points: 26, Visits: 76
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 11:47 AM
Points: 297, Visits: 193
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 11:47 AM
Points: 297, Visits: 193
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