• Thanks, I'm getting closer to finding the issue.

    When I execute

    select * from sys.dm_db_task_space_usage

    where internal_objects_alloc_page_count <> 0

    Session 10 and 14 have a very high number of internal_objects.

    Activity monitor show system events any more. I hate AM in SQL 2008.

    Does anyone feel it hasn't improved or is it just me.

    Mine seems to be service broker.

    Now how to fix the thing or is that how it generally works.