dsccommunity / dsccommunity/SqlServerDsc
SqlMaxWorkerThreads: New resource proposal
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 385
- Forks
- 224
- PR merge metrics
- No merged PRs in 30d
Description
Description
We could also add AutoTune for one more configuration item:
MaxWorkerThreads: We have a few sharepoint SQL servers:
When a Farm has dozens of web servers, and SQL is on a AlwaysOn cluster:
two availability groups, each one in a datacenter, and above that there is a distributed availibility group.
then when there would be 500 databases just for the alwayson part there would be around 1500 threads needed.
https://www.sqlshack.com/max-worker-threads-for-sql-server-always-on-availability-group-databases/
Proposed properties
TBD
Special considerations or limitations
None at this time.
Originally posted by @Fiander in https://github.com/dsccommunity/SqlServerDsc/issues/1539#issuecomment-738068471
Contributor guide
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
No files, tests, or entry points are named. Start by locating the existing AutoTune configuration in SqlServerDsc and review the linked SQL Server Max Worker Threads reference, then define the proposed properties for AlwaysOn scenarios. Done means the properties and limitations are specified and the resource behavior is covered by tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100