Post reply

SQL Server 2005 Profiler and Functions

  • August 3, 2008 at 12:13 am

    #124345

    I'm trying to improve the performance of my user defined SQL Server 2005 user defined functions. I've ran the SQL Server Profiler program and captured events using the tuning template, however I'm not getting any events captured. Does the SQL Server Profiler not capture these? Any suggestions? Thanks, Mike

  • August 3, 2008 at 9:57 am

    #852437

    Which events are you capturing? There are lots of events, down to the statement level, that you can capture. You can modify any trace to include the events.

    Profiler allows you to examine how long various statements take.

    you can also get an execution plan in SSMS and then work to find which parts of your UDF are taking the most resources and try to tune those.

Viewing 2 posts - 1 through 2 (of 2 total)

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