title: SQL Server CLR Memory Allocation
body: <p>Currently we have MS SQL Server 2005 (32 bit). We have 1 assembly (and only 1 assembly) which we use for encryption and decryption. Only 512 MB of system memory is allocated to CLR. The assembly runs pretty slow, and I'm trying to rule out if its from memory or not. When I run the SQL code in query analyzer (not in an assembly) it runs quick. We are using symmetric keys and certificates for encryption / decryption.</p>
  
  <p>Is there a recommended amound of memory to allocate to CLR? 
  How can I tell if a lack of memory allocation is slowing down the performance of this assembly?</p>