jeudi 26 mars 2015

Timeout occurred while waiting for latch: class 'ACCESS_METHODS_HOBT_COUNT'


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