“Schema Cache Lookups” reports these activities:
Forward Schema – occasionally, Replication Agent must perform a forward scan on the primary transaction log looking for object schema changes.
Count – number of times Replication Agent performed a forward scan.
Total Wait – length of time, in milliseconds, Replication Agent spent performing forward scans.
Longest Wait – longest length of time, in milliseconds, Replication Agent spent performing a forward scan.
Average Time – average length of time, in milliseconds, Replication Agent spent performing forward scans.
