As most people know, Outlook 2007 with Business Contact Manager requires an instance of SQL Server 2005 to be installed.

Unfortunately, when unchecked, SQL Server 2005 tends to hug immense amounts of memory, and even though I had installed the maximum amount of memory that could be used by my computer, I still found myself low on physical memory resources. Using task manager to identify the main culprit, I found SQL Server was using several hundred Mb of memory! I set out to research the problem but found no way to regulate the amount of memory using  SQL Server Configuration Manager.

Also found that a number of people had the same problem, and no solution in sight. Until I finally found a tool that allowed me to set the amount of memory SQL Server uses! After applying it, looked at the task manager again – SQL Server was using less than 100 Mb of memory, with the same or better perfomance than before!

For more information or to get help with issue, contact me.