The space available property is not computed correctly

Open Beginner friendly
#147 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
2/5
Estimated time
1-3 hours
Newbie friendliness
62/100
Issue type
Bug
Clarity
Clearly specified
Activity status
Stale
Tech stack
csharp, sql
Domain
databases

Research direction

Start in src/Microsoft/SqlServer/Management/SqlEnum/PostProcessDatabaseInsideAttribs.cs at the linked calculation of Database.SpaceAvailable. Review how sys.allocation_units and sys.partitions are joined, then verify the result for a database using columnstore indexes. Done means the property reports the correct available space without the incompatible join.

Written by the indexing model from the issue text.

Description

The Database.SpaceAvailable property is not computed correctly. The reason for this issue is that the input used in the calculation of this property, as seen in the source code, relies on a join operation between the sys.allocation_units and sys.partitions DMVs. However, this inner join is incompatible with columnstore indexes, as clearly documented in the official documentation. Consequently, the size is inaccurately computed for databases using columnstores. The solution is straightforward: remove this incompatible join operation from the calculation.

Dominant language
C#
Stars
143
Forks
28
No merged PRs in 30d

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from microsoft/sqlmanagementobjects

All issues in microsoft/sqlmanagementobjects

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.