Strange to me procedure

Question

Strange to me procedure

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Use profiler.

p.s. 2 year old thread

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

GregoryF SSCertifiable Points: 6296 More actions · Answer 2

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!

Robin de Mercado Grasshopper Points: 14 More actions · Answer 3

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

sky_night SSC Enthusiast Points: 145 More actions · Answer 4

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.

sky_night SSC Enthusiast Points: 145 More actions · Answer 5

Sorry actually that one is for "Resource Waits" tab in Activity Monitor.

-Paul N.

sandos SSC Veteran Points: 248 More actions · Answer 6

This appears to be generated when you run a Activity Monitor in the SQL Management Studio.

m.r.piatek Valued Member Points: 72 More actions · Answer 7

Hi,

this one is for the activity monitor and checks the ressource waits.

kr