SQL Server does not page, not in the sense the OS pages.
Data does not need to be paged becase the memory is just a cache of the data files. Data cacan simply be removed from memory and read back when needed.
Caches (eg. Procedure cache) are not paged either. Entries are removed and, if needed, they can be recreated from scratch (eg. compile).
The closest thing to paging are spills. These are operators that need intrmediateintermediate data and dontthat doesn't fit in memory. They spill to tempdb. The typical example is the sort operator.