Tips and Techniques to Expand the&

Rex

SQL Memory and Performance

--ACT! has a config setting which allows memory “crunching” when using a local database

--Configured in ActSage.exe.config
--Can either enable/disable for all identified tasks

--Affects all databases on the local SQL instance

Disable SQLServerMemoryManager if…
--Logging onto local database(s)
--Local database is a workgroup database
--Multiple databases that others use
--Running ACT! 9.x or 10.x
--Plenty of RAM (2GB+)
--Syncing