ASInternal_AutoPurge stored proc running for days at a time RRS feed

  • Question

  •  I recently noticed that the ASInternal_AutoPurge stored proc in AppFabricMonitoring has been running for days; since 10/4 to be exact.  I came across this because the avg disk queue length on the SQL box suddenly went up on a particular day and I was trying to see what was going on with the box.  I can't imagine this proc should run for days.  Previously it would run for only 90 seconds.  

    The below query returns APEnabled value of 1, APThreshold of 1500MB and APTrimPercentage of 10.  

    SELECT *
    FROM dbo.ASConfigurationPropertiesTable

    I am not at all familiar with AppFabric.  I suspect this is at least contributing to my problem.  How should I approach this issue?

    Lee Markum

    Wednesday, October 7, 2015 6:20 PM