microsoft / microsoft/sql-server-samples
SQL assessment API / MaxDopFewNumaOver15 rule
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
Hi,
MaxDopFewNumaOver15 rule (Microsoft Ruleset 1.0.261) raises a warning when evaluated against a server with 32 logical cores on 2 NUMA nodes with a Maxdop equals to 16.
Message: "Update MAXDOP configuration option value: 16 – it should be half the number of logical processors per NUMA node"
This warning should be raised when a server has more than 16 cores by NUMA node.
sqlserver module 21.1.18226
Regards
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the MaxDopFewNumaOver15 rule in the SQL assessment API and compare its current threshold with the linked Microsoft MAXDOP guidance. Reproduce the reported topology and verify that the warning is raised only when a NUMA node has more than 16 logical cores, using the stated message as the expected result.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100