We have a big reporting database on production server, and we have several SSIS jobs running against it.
Yesterday almost all this-database-related SSIS jobs stuck and running forever. Also the transaction log backup of this database never succeeded. I checked the SQL Server Error Log and I see lots of following errors:
Timeout occurred while waiting for latch: class 'ACCESS_METHODS_HOBT_COUNT', id 00000000EA7449F0, type 2, Task 0x0000000005817DC8 : 12, waittime 66300, flags 0x1018, owning task 0x0000000000000000. Continuing to wait.
Does anyone know what does it mean? And how we can solve it?
Aucun commentaire:
Enregistrer un commentaire