Is there an easy way to determine the number of times a stored procedure has been recompiled

  • Thread starter Thread starter pskubal1
  • Start date Start date
P

pskubal1

Guest
Is there an easy way to determine the number of times a stored procedure has been recompiled. We have some vendor code with WITH RECOMPILE in the stored procedure. I would like to see how many times they get recompiled. I already am getting perfmon counters and profiler traces.


THanks

Pam

Continue reading...
 

Similar threads

A
This new true crime series is so controversial, Netflix has been ordered to delete an episode
Replies
0
Views
132
Andy Meek
A
C
MacBook Pro 2021 notch is a smart way to increase display size, says Apple
Replies
0
Views
132
Chris Smith
C
C
New Spider-Man: No Way Home image confirms a crazy spoiler
Replies
0
Views
132
Chris Smith
C
Y
How to stop Google from spying on your Gmail in a few easy steps
Replies
0
Views
92
Yoni Heisler
Y
M
[vb.net] How to organize a long procedure
Replies
0
Views
160
Mattia Fanti
M
Back
Top