How do you determine the appropriate memory configuration settings for a database server, and what are the key memory parameters to tune?

Sample answer preview

Memory configuration is one of the most impactful tuning areas for database performance. Properly configured memory settings can mean the difference between a database that reads primarily from fast memory versus one that constantly reads from slow disk.