Close Orphaned Sessions not completing RRS feed

  • Question

  • Has anyone encountered the issue of the SQL Server Agent job "Close Orphaned Sessions" not completing in a timely manner?

    We suspect this may be because of the sizes of the APPLICATION_USAGE and MESSAGE_LOG tables. I had to truncate the tables before the job succeeds. Even one months of data appears to be too much (setting the "Usage History" to keep only 1 month of data, followed by "Check Usage History"). Ideally we would like to keep one year's worth of utilisation data for reporting.

    Wednesday, November 9, 2011 10:03 PM


All replies