Да дело в том, что не каждый раз она выгружается. В процессе отладки загрузки были спецэффекты, и они не каждый раз вылезали. И по времени выполнения запроса видно, когда она отдает готовые данные, а когда заново все загружать начинает.
Basically from what I understand through reading several websites and talking with someone at Microsoft is that it is ok for them to unload and load. However, there are known issues with the CLR SQL and the Cumulative Updates have addressed them. I loaded CU6 and modified the memory on SQL Server to use only 5 GB instead of all that is available and we have almost eliminated the assemblies from being unloaded.
Comments 4
(The comment has been removed)
Reply
(The comment has been removed)
Reply
Basically from what I understand through reading several websites and talking with someone at Microsoft is that it is ok for them to unload and load. However, there are known issues with the CLR SQL and the Cumulative Updates have addressed them. I loaded CU6 and modified the memory on SQL Server to use only 5 GB instead of all that is available and we have almost eliminated the assemblies from being unloaded.
Reply
Reply
Leave a comment