sql-docs icon indicating copy to clipboard operation
sql-docs copied to clipboard

Update sql-server-linux-performance-best-practices.md

Open bangjiehan opened this issue 10 months ago • 6 comments

Add a note for open file limitation.

This setting do not apply to systemd services. Most Linux dist now have hard limit of nofile at least 1048576.

There is no reason to set a lower soft limit and I don't know why original author choose a value of 32727 ($2^{15}-1-40$).

bangjiehan avatar Apr 19 '24 09:04 bangjiehan