The installer of SQL Server has a little annoyance: By default, the available memory for your database is set to 2147483647 (or Int32.MaxValue) :
If you do not notice the checkbox at the end and check it, you allow SQL Server to take every last byte of RAM. This greedy monster will go unnoticed for a long time. You may never experience any problem caused by this misconfiguration.
However, a more likely scenario is that at one day in the distant future (or tomorrow) strange little errors happen. One job in SQL Server Integration Services fails, then another one, and so forth. It may take you a long time to figure out the source of these problems – it sure took us a long time.
All those pesky little errors stopped immediately after we changed the available memory to a value 2 GB less than the amount of memory we assigned to the machine. You can do this in the server properties
by the Memory settings:
You need to restart the database server to get this change activated. Since we did this simple little change these strange errors stopped. Try it if your SQL Server suddenly runs into strange errors.