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 ««123»»

Strange to me procedure Expand / Collapse
Author
Message
Posted Thursday, October 29, 2009 1:53 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 5,589, Visits: 24,948
Strictly as a pure guess -- Checking Books On Line for:
SQL Server, Wait Statistics Object at:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/cb7f917d-4291-4115-9b78-ee7692ebbb2d.htm

Can you associate any of the data returned with any of the items contained in the Wait Statistics Object?


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #811174
Posted Thursday, October 29, 2009 1:58 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:12 AM
Points: 77, Visits: 427

thnks SSCertifiable

solution:
I did as you suggested as found out it was the admin, when the system runs the tracer it creates the procedure and there it lies hiden, temp procedre.




"We never plan to Fail, We just fail to plan":)
Post #811178
Posted Thursday, October 29, 2009 2:03 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
lrosales (10/29/2009)

thnks SSCertifiable

solution:
I did as you suggested as found out it was the admin, when the system runs the tracer it creates the procedure and there it lies hiden, temp procedre.

Just a hint, "SSCertifiable" is a title for the number of posts, not the person. The username is right above that. Would be like addressing you as "Valued Member" (you'll see that right below your screen name). No big deal, but thought I'd mention it.

Traces are great for finding out "What the heck is going on in my database???"


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #811184
Posted Thursday, October 28, 2010 2:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 3, 2014 4:26 AM
Points: 16, Visits: 75
You are probably running the Activity monitor which generates:

EXEC #am_generate_waitstats

entries in the Profiler after an executed query
Post #1012130
Posted Monday, May 2, 2011 9:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:56 AM
Points: 1,002, Visits: 884
It is activity monitor, for the wait resources. However, does anyone know what goes into the SP #am_generate_waitstats?

I only get a couple of hits on Google for the SP and would really like to know how MSFT comes up with those values.


/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

Post #1101639
Posted Monday, May 2, 2011 9:16 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:00 AM
Points: 42,774, Visits: 35,871
Use profiler.

p.s. 2 year old thread



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1101652
Posted Monday, May 2, 2011 9:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:56 AM
Points: 1,002, Visits: 884
two year old thread, but one of only 5 hit's in google.

I found it in profiler, thanks


/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

Post #1101657
Posted Wednesday, July 11, 2012 4:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:45 AM
Points: 4, Visits: 93
I also noticed this suddenly appearing in SQL Server Profiler (SQL 2008R2).
EXEC #am_generate_waitstats; seems to execute if the Activity Monitor is open in SSMS 2008R2
Post #1328163
Posted Wednesday, April 17, 2013 4:19 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 12:03 PM
Points: 3, Visits: 18
This temporary stored procedure is part of the "Recent Expensive Queries" tab in Activity Monitor.

This along with a bunch of other queries are executed to populate the data in your recent expensive queries tab in Activity Monitor.

-Paul N.
Post #1443533
Posted Wednesday, April 17, 2013 4:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 12:03 PM
Points: 3, Visits: 18
Sorry actually that one is for "Resource Waits" tab in Activity Monitor.

-Paul N.
Post #1443539
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse