Browse by Tags

• Performance
• Profiler
• UDF

• SQL Trace challenge: a simple requirement

  SQL Trace (or SQL Profiler) is no doubt an excellent tool. But its filtering capability is rather primitive, and is very poorly documented. Here is a request that is simple and seems to be rather reasonable. Create a trace to filter for the following: Read More... Posted Thursday, April 29, 2010 12:48 AM by Linchi Shea | 20 Comments Filed under: Profiler, SQL Trace

• Performance impact: SQL trace and user defined scalar functions

  Certain things just don’t go well together! No, not talking about liberals and Republicans. Rather, I’m talking about user defined scalar functions and SQL traces. If you run SQL Trace or SQL Profiler often, you’d find user defined scalar functions to Read More... Posted Monday, June 15, 2009 2:21 PM by Linchi Shea | 9 Comments Filed under: Performance, Profiler, SQL Trace, UDF Attachment(s): UDF_Trace.GIF