deleteExpiredsessions cause databas server blocking issue
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
June 14th, 2011 3:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics