microsoft / microsoft/sql-server-samples
Issues with "Average available space in data files is less than threshold"
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
This is in reference to the SQL best practices assessment on Azure IaaS VM.
The HelpLink appears to be incorrect for check ID DbSpaceAvailable. The URL, [https://docs.microsoft.com/sql/relational-databases/databases/database-states], refers to the Online/Offline/Restoring/Recovering states of a database.
I spent some time trying to find a more accurate URL and this is the best I could find: [https://docs.microsoft.com/en-us/troubleshoot/sql/admin/considerations-autogrow-autoshrink#why-do-i-have-to-worry-about-disk-space-if-size-settings-are-automatically-controlled]
Pointing to documentation that talks about performance impact of data file growth might be another option.
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 SQL best practices assessment entry for check ID DbSpaceAvailable and inspect its current HelpLink. Compare the existing database-state URL with the proposed autogrow/autoshrink documentation, and consider whether a page about data-file growth performance is more accurate. Done means the HelpLink points to documentation relevant to the assessment.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, sql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100