Previously I did a post with a few general performance tips for Office Accounting.

 

I just saw a question on the newsgroup about performance on a SQL Server; basically the application was running very slow even though the server machine was a very powerful machine with lots of RAM. (In this case it would take minutes to save a transaction from Office Accounting)

 

The problem was/ is that SQL Server will release memory if it senses that other processes use a lot of memory. In fact SQL Server will release so much memory that it will slow down to a crawl as it will have to go to disc all the time.

 

The solution is to increase the minimum memory usage for SQL by setting the “min server memory” option…

 

For more info take a look at this article on Server Memory Options or Effects of min and max server memory from SQL Server 2005 Books Online