I have an ACT! professional for Windows V11.1, with the latest SQL service pack (SP3) and have an apparent memory leak on the server.
After a restart the ACT! SQL instance (SQLSERVR) consumes almost all the available memory on the server, we have added more memory to the server (it is running under Hyper-V) but it continues to consume it all.
I have not been able to connect to the SQL server instance using management studio in order to limit the amount of RAM it is allocated.
Are there any potential solutions for this? or should I continue to restart the services?