asterisk users - Sep 2011 - FreeTDS and MS-SQL with Asterisk RealTime

We have successfully setup and tested integration between Asterisk and MS-SQL.
We are currently running about 70 simultaneous calls throughout the day however
after some time our MS-SQL server (Windows 2008 64bit, SQL Server 2008) starts
to increase it's memory usage exponentially. The MS-SQL server CPU also pegs
at around 90%+ and becomes unresponsive and cannot accept new connections. We
are running Asterisk 1.8.6 currently. FreeTDS version is 4.2 and UnixODBC is
2.2.12. The kernel information is : Linux 2.6.27.25-78.2.56.fc9.i686.PAE #1 SMP
Thu Jun 18 12:36:07 EDT 2009 i686 i686 i386 GNU/Linux. We are using Realtime and
using FreeTDS to connect to the MS-SQL server where we control sip users,
voicemail and so forth. This works fine however when we enable CEL and CDR into
MS-SQL the server begins to grow in memory usage / CPU usage until the SQL
server halts and stops taking new requests.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20110928/fa04db5e/attachment.htm>