THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2008 » SQLCLR » C#   (RSS)
  • Performance impact: Try/Catch blocks in SQLCLR – a follow up

    My previous post showed a simple test that appears to suggest that you may experience significant performance degradation if multiple users are calling the same SQLCLR function at the same time and they are all catching a lot of exceptions.   However, it’s not clear whether that behavior is limited to SQLCLR or applies to .NET in general. ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 7, 2011
  • Performance impact: too many try/catch blocks may be harmful in SQLCLR

    If you have many try/catch blocks in your .NET code and your code execution actually passes through them, you should expect a performance hit. That’s intuitive and no surprise.   What is surprising is the extent to which you may experience severe performance degradation when multiple users are executing a piece of SQLCLR code (e.g. calling ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 6, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement