sql-docs
sql-docs copied to clipboard
Update sql-server-linux-performance-best-practices.md
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 : Thanks for your contribution! The author(s) have been notified to review your proposed change.
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:
- Try searching the learn.microsoft.com contributor guides
- Post your question in the Learn support channel
@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
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.
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:
- Try searching the learn.microsoft.com contributor guides
- Post your question in the Learn support channel
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:
- Try searching the learn.microsoft.com contributor guides
- Post your question in the Learn support channel
PR 9761 has been merged from bangjiehan:patch-1 to MicrosoftDocs:live by rwestMSFT.
@bangjiehan, @tejasaks, @amitkh-msft, @rwestMSFT