I have a sproc that generates an 80,000-row temp table which is passed as a table-valued parameter to 32 different other sprocs (each sproc the TVP as an input parameter).
- Should I be concerned that I am going to get a balloon of memory I can't manage?
- What is a good way to monitor (PerfMon?) how the memory is being used/tracked?
Thanks.