In the past two days we've seen a huge hit in performance between our OLEDB data connection with our ATS. As far as we can tell nothing has changed on the ATS, and we performed a reboot of our qlik server. What would take 60 or so seconds to pull 3M records (4 columned table extract), we are seeing it take up to 20 mins or longer. To the point that our task queue is getting overloaded.
Has anyone experienced an issue like this, and were they able to point to a setting change that might point to the cause?
Any help in pointing us in the right direction would be greatly appreciated.