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 1 year 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

@bangjiehan : Thanks for your contribution! The author(s) have been notified to review your proposed change.

prmerger-automator[bot] avatar Apr 19 '24 09:04 prmerger-automator[bot]

Learn Build status updates of commit d27ef84:

:white_check_mark: Validation status: passed

File Status Preview URL Details
docs/linux/sql-server-linux-performance-best-practices.md :white_check_mark:Succeeded

For more details, please refer to the build report.

For any questions, please:

@tejasaks

Can you review the proposed changes?

When the changes are ready for publication, add a #sign-off comment to signal that the PR is ready for the review team to merge.

#label:"aq-pr-triaged" @MicrosoftDocs/public-repo-pr-review-team

Court72 avatar Apr 19 '24 15:04 Court72

Adding @amitkh-msft to review. Original entry was made for Red Hat Enterprise Linux 7 which had a much lower default limit and caused certain issues. probably doesn't apply to RHEL 9 or even 8 but needs to be verified.

tejasaks avatar Apr 19 '24 17:04 tejasaks

Learn Build status updates of commit 5e6bcfa:

:white_check_mark: Validation status: passed

File Status Preview URL Details
docs/linux/sql-server-linux-performance-best-practices.md :white_check_mark:Succeeded

For more details, please refer to the build report.

For any questions, please:

Learn Build status updates of commit 2263eb3:

:white_check_mark: Validation status: passed

File Status Preview URL Details
docs/linux/sql-server-linux-performance-best-practices.md :white_check_mark:Succeeded

For more details, please refer to the build report.

For any questions, please:

PR 9761 has been merged from bangjiehan:patch-1 to MicrosoftDocs:live by rwestMSFT.

@bangjiehan, @tejasaks, @amitkh-msft, @rwestMSFT

prmerger-automator[bot] avatar Jun 10 '24 16:06 prmerger-automator[bot]