TABLE 1: Sample Run Times for sp_table_validation on a Single Table
Table SizeTable Preloaded in Data Cache Table Not Preloaded in Data Cache
 rowcount-only rowcount + checksum rowcount-onlyrowcount + checksum
100,000 rows, 5MB < 1 second < 1 second < 1 second < 1 second
1 million rows, 50MB 1 second 4 seconds 5 seconds 5 seconds
5 million rows, 250MB 3 seconds 22 seconds 30 seconds 30 seconds