SQL Server Performance Forum – Threads Archive
Impact of Debugging a CLR user-defined functionHi, 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
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
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.