Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Function Execution Count Expand / Collapse
Posted Tuesday, September 20, 2011 1:37 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 30, 2016 4:03 PM
Points: 323, Visits: 788
I need to find out how many times a table-value function has executed on my sql azure database. Any suggestions?


Post #1178215
Posted Thursday, January 5, 2012 6:41 AM



Group: General Forum Members
Last Login: Today @ 6:22 AM
Points: 17,171, Visits: 32,132
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
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1230704
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse