Test-DbaIdentityUsage
Brandon Abshire, netnerds.net
Test-DbaIdentityUsage View Source Brandon Abshire, netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.
Read more
dbatools