November 13, 2007 at 5:39 am
Is there any tool to monitor or to find the performance of an UDF????
November 13, 2007 at 8:37 am
SQL Profiler?
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
November 14, 2007 at 1:33 am
can you able to send the URL for learning SQL Profiler where the performance of UDF only can monitored?
November 14, 2007 at 2:18 am
I don't have a URL, but to use SQL Profiler do the following:-
1) Start / Programs / Microsoft SQL Server>/Profiler
2) file / new trace
3) login to SQL server
4) Select the relevant template ( using the template filename )
5) click run
Then you should see a list of SQL statements that are running
Pete
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
November 15, 2007 at 7:43 am
You can filter on ObjectID (Filters tab of Trace Properties form) for the UDF. Obtain ID from sysobjects system table.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply