Corruption of ETL repository on SQL server version 5.7.9.42

HI:

we seem to be experiencing some corruption/slowdown of the repository database for ETL enterprise 5.7.9.42 on SQL server. we have experienced this behavior in the past but not since upgrading to this current version.

have any other user of enterprise experienced any random corruption of the db repository?

thanks

mike

May be you need to patch it?

www.etl-tools.com/articles/repository-patch-script.html

Any error messages?

mike:

we don't have any error messages, however we run a query for our in house reporting site which normallly takes a couple of seconds to run, but now takes over 1:40 1 min 40 seconds. almost as though it stalls for a period.

this has been working without issue for quite a while then suddenly this weekend it now times out.


thanks

mike

So have run this patch?

www.etl-tools.com/articles/repository-patch-script.html

have run the patch and it moved 0 records for all queries.

I believe the system is keeping up with the history migration.

thanks

mike

I see,

If you run SQL against the database does it take 1.4o seconds?