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 12:00 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:12 AM
Points: 77, Visits: 428

does anyone know what the exec #am_generate_waitstats purpose is




"We never plan to Fail, We just fail to plan":)
Post #811070
Posted Thursday, October 29, 2009 1:02 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Looks like you have a temporary proc there. Kind of like a temp table, but it's a proc instead.

- 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 #811123
Posted Thursday, October 29, 2009 1:09 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:12 AM
Points: 77, Visits: 428
I am aware of that, the store procedure is created in the tempdb, but still does not answer the Question of how what and why is created or the Purpose of it.

thanks




"We never plan to Fail, We just fail to plan":)
Post #811130
Posted Thursday, October 29, 2009 1:30 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 7:27 PM
Points: 33,204, Visits: 15,351
If it's a temp proc, it was created on your system. We have no way of knowing what it is.

You could try scripting it to see the code.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #811143
Posted Thursday, October 29, 2009 1:34 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:12 AM
Points: 77, Visits: 428
I have Attempted that, with no luck.



"We never plan to Fail, We just fail to plan":)
Post #811148
Posted Thursday, October 29, 2009 1:37 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 8:15 AM
Points: 653, Visits: 1,428
From the name of it, I'd have to take a wild guess and think that it's something a DBA came up with the gather wait stats of some sort. If that's the case, I'd look at the scheduled jobs on the box to see if I can find it (you can also try querying the command column in msdb..sysjobsteps). I'd also look at the auto startup stored procedures to see if it's being kicked off from there.

As a last resort, I'd search through the syscomments table in all databases for something where text like '%wait_stats%'
Post #811151
Posted Thursday, October 29, 2009 1:42 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Where are you seeing the exec command on it? In a trace?

- 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 #811155
Posted Thursday, October 29, 2009 1:46 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:12 AM
Points: 77, Visits: 428
a trace is correct.



"We never plan to Fail, We just fail to plan":)
Post #811161
Posted Thursday, October 29, 2009 1:48 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:12 AM
Points: 77, Visits: 428
I have schedule no such job.



"We never plan to Fail, We just fail to plan":)
Post #811166
Posted Thursday, October 29, 2009 1:48 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
Take a look in the trace for what commands were being run by the same SPID (if that's in the trace). That should tell you what proc or script is being run. If you have the text field in the trace (assuming that you do and that's where you got the exec command), it might even contain the create command for the temp proc. That's where I'd start.

- 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 #811167
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse