SQL Server Performance

Impact of Debugging a CLR user-defined function

Discussion in 'SQL Server 2005 CLR' started by danie83, Feb 1, 2007.

  1. danie83 New Member

    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

  2. satya Moderator

    If this is a production server then refrain debugging such objects using VS, as it is by default the resources will be high to perform such changes and other processess are tyring to acquire locks on data during update/deletes action.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page