Problem's there again. Googling brought me back to my own post

Last time the SQL service was restarted to reduce the size. That happened during a major version update. No updates coming up for a while.

SELECTTOP (3)

session_id,

AllocPages= internal_objects_alloc_page_count,

DeallocPages= internal_objects_dealloc_page_count,

AllocatedGBs= CAST(internal_objects_alloc_page_count / 128.0 / 1024.0 AS Dec(9,3)),

DeallocatedGBs= CAST(internal_objects_dealloc_page_count / 128.0 / 1024.0 AS Dec(9,3))

FROMsys.dm_db_Session_space_usage

WHEREinternal_objects_alloc_page_count > 0

AND internal_objects_dealloc_page_count > 0

ORDERBY internal_objects_alloc_page_count DESC

/*

session_idAllocPagesDeallocPagesAllocatedGBsDeallocatedGBs

35235674161017135227.21777.601

1502354440634835217.96348.434

39653588015009124.08811.451

*/

SELECTsession_id, [program_name]

FROMsys.dm_exec_sessions

WHEREsession_id IN (150, 352, 396)

/*

session_idprogram_name

150Replication Distribution History

352Replication Distribution History

396Replication Distribution History

*/

Any help would be appreciated