Large Tables Performance

Mar 16 at 9:25 AM
I tried to find information of how SqlTableDependency works, particularly does it retrieve all records from a table to be able to track changes. If I want to track changes of 1M rows, does SqlTableDependency retrieves all the rows at start?
Are there any detailed performance results for various situations in real life?
Coordinator
Mar 16 at 9:30 AM
Hi

SqlTableDependency create service brkerm queue and trigger (on interested database table).

Every change done on records, the trigger put a message in a queue that is read from SqlTableDependency, reporting you the info about he change.
Mar 17 at 1:55 PM
Thank you for the answer!
My question was motivated because I read about "native" SqlDependency, and as far as I understood, SqlDependency tracks changes on rows retrieved from a database.