I have just noticed that in the past few days a Maintenance Plan job that we have on SQL 2012 database seems to be taking a long time to complete. The last job was completed in over 12hrs, however so far i have not been able to pin point exactly what is causing this issue and this job use to complete in 30-60 minutes before. This is not a very large database either as its just 37GB.
From the logs i have worked out that its the CHECK Database Integrity Task which is taking 12hrs, this would start at 01:00AM and Complete at 13:00PM, other task are completed in normal times.
This is the OperationsManager Database within System Center 2012.
Wondering if anyone has an idea of what could be causing this issue.