Technical Debt Overview
The technical debt overview analyzes the technical debt on a single database.
Some of the SQL Server technical debt that are caught by the Technical Debt Analysis report are:
- Cursors in Stored Procedures
- Usage of SELECT * rather than specific columns
- Use of NOLOCK hint
- Multiple RETURN statements
- And many more
Rank, Score and Debt
The rank column simply sorts the debt by the most expensive (highest score and debt) numbers first.
The score is determined by the complexity of the issue times the number of occurrences.
The Debt or dollar value (sorry no internationalization on this), shows the score divided by the Average points per hour fixed times the average hourly cost to fix debt. See the settings dialog for details.
Related Links
Leave a Reply