BSavoie
SSCertifiable
Points: 6309
More actions
September 20, 2011 at 1:37 pm
#243424
I need to find out how many times a table-value function has executed on my sql azure database. Any suggestions?
thanks!
.
Grant Fritchey
SSC Guru
Points: 398872
January 5, 2012 at 6:41 am
#1428973
Take a look at the sys.dm_exec_query_stats DMO. You should be able to get a count from that assuming the statement is still in cache.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply