locked
deleteExpiredsessions cause databas server blocking issue RRS feed

  • Question

  • We recently found some SQL server jobs are delayed for serveral minutes at the peak hour in the morning.

    And at the same time we received some alerts about blocking happened on the server. 

    we also noticed in our SQL server jobs there are several deleteExpiredSessoins job of sharepoint, and in the early morning,

     It runs every minute. Is that possible it caused all these blocks?

     is it Ok to change it to run once a day?

     


    SQLFriend
    Tuesday, June 14, 2011 7:42 PM