Impact of Debugging a CLR user-defined function

• Daniel Jebaraj

  SSC Veteran

  Points: 245

  More actions

  January 31, 2007 at 8:27 am

  #172105

  Hi,

  I debugged a CLR user-defined function using Sql server project in Visual Studio 2005. After that, my server has become very slow. The queries which used to take 5 seconds, now taking 10 or 15 seconds.

  And also I noticed that while I was debugging the CLR UDF on the server, the other users who are using the application got very slow response or time out error.

  Does debugging a CLR sp/functions/triggers have impact on performance or CPU usage?...

  Can anyone please help me out.......

   

  Regards

  Daniel

   

   

   

   

• twillcomp

  SSC Eights!

  Points: 989

  More actions

  February 1, 2007 at 4:37 am

  #687062

  I'm not sure about any lasting effect of debugging, but check out BOL for "debugging [CLR integration]" and read the permissions and restrictions.

  For the reasons given there the sensible recommendation is to debug only on a test server.