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
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Download this page in PDF format
Dear Mr. Stedman, this is an great work foranalyzing technical debt in a database, I just want to ask what are the other debts the can be found on a database ?
kindly can you guide me on how to list all the possible debts that can be found on a database?
best regards