How to assess whether in-memory cache size is optimal?

Here are the settings I have for database;

image

I have 16G RAM on my PC. So far, performance is good but I'm wondering if it can still be better. From performance tuning article, it seems for in-memory cache size, too large is bad. Too little is bad either.

Do my database settings look reasonable?

How do I decide whether in-memory cache size is optimal?

1 Like

Half the RAM size is OK.

2 Likes