Identity

Test-DbaIdentityUsage

Test-DbaIdentityUsage View Source Brandon Abshire, netnerds.net Windows, Linux, macOS Synopsis Analyzes IDENTITY column seed consumption and calculates percentage of available range used. Description Scans IDENTITY columns across databases to calculate how much of the available seed range has been consumed based on data type limits (tinyint, smallint, int, bigint). This helps DBAs proactively identify tables approaching identity exhaustion before they hit maximum values and cause application failures. The function calculates percentage used by comparing current identity values against theoretical maximums, so you can plan remediation like reseeding or changing data types before problems occur.