As said in the previous section threading model of .NET and SQL Server is completely different. So SQL Server has to handle threads in a different way for SQLCLR. So a little different threading architecture is implemented termed as "Tasking of Threads". In tasking thread architecture there is switching between SQLCLR threads and SQL Server threads, so that .NET threads do not consume full resource and go out of control. SQL Server introduced blocking points which allows this transition to happen between SQLCLR and SQL Server threads.
0 comments:
Post a Comment