NAS taking more and more memory

Business Central/NAV Developers Forum
1

I have 2 NAS running on a SQL-server database (3.60). They run a single-instance codeunit with a timer. So each time the timer is called, the nassql.exe process takes a bit more memory. This goes on and on, so in the end we need to restart the NAS because the server is slowing down too much. Anyone experienced this before and knows a solution ? Thanks in advance

2

After testing I come to the following conclusion : every time I use an Automation variable the memory builds up. Clearing the variable after usage has no effect at all. Any suggestions ?

3

I guess that you define the automation variable as a global ? What automation servers are you using ?

4

Changed them to local, but this had no effect. I use the Microsoft CDO 1.21 Library.

5

Are you using the automation server in the single instance CU ?

6

yes, I do