What does it mean by footprints in SQL Server?
here's a snippet from MSDN "reduce the lock footprint of expensive queries" LINK
The footprint in this case means the number of different locks being made. e.g. the more locks - the larger the footprint.