Comments (0)

  1. Eric in Sacramento

    I don’t get it. If the question is, “are my temp objects being maintained in memory or on disk,” how does the result set answer the question? It looks like all of them are being maintained mostly in memory yet partially on disk.

    1. Tempdb attempts to save the objects in memory as much as possible. It’s not always possible. Your output may look similar to this or it may look grossly different if your tempdb isn’t able to keep things in memory.

Leave a Reply