Experiencing extreme slowness and sys.scripts.do transaction runningIssue Experiencing extreme slowness and sys.scripts.do transaction runningCause/sys.script.do transaction was running and causing a cache flush every second To see this, we had to tail the log and grep for the worker that running this jobResolutionCustomer or Support can terminate the transaction from the UI but that was the resolution. In this case, it took 1-2 minutes for the instance to recover once the script was terminated.