Top 10 Wait State Issues Reporter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rudy Panigas » Top 10 Wait State Issues Reporter

34 posts, Page 4 of 4

«««1 2 3 4

Top 10 Wait State Issues Reporter

Rate Topic

Display Mode

Topic Options

Author

Message

Rudy Panigas

Posted Tuesday, November 27, 2012 1:05 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 306, Visits: 1,016

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

Hats off to you all!!! Smile

Thanks,

Rudy

Post #1389389

Tony Trus

Posted Tuesday, November 27, 2012 1:21 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 9:34 AM
Points: 22, Visits: 47

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

nickm_GR

Posted Wednesday, November 28, 2012 6:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:53 AM
Points: 170, Visits: 151

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

nickm_GR

Posted Wednesday, November 28, 2012 7:08 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:53 AM
Points: 170, Visits: 151

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

« Prev Topic | Next Topic »

34 posts, Page 4 of 4

«««1 2 3 4

Permissions