Publisher tasks running extremely slow

[karensmith]

Tasks in Publisher have been fine for in QV9 SR5, but all of sudden since the past few days. Jobs have been processing extremely long. This is effecting QVD reloads from AS400, SQL server and straight qvw files. Example, jobs that use to run 23 minutes have now completed in 2.5 hours one day beyond three hours the next and today I terminated job after four hours.

QV Server client is also affected. Jobs running extremely long.

CPU% and Memory% are okay. Our server platform is Windows 2008 64bit, 32GB of memory...

This has caused our environment to become unavailable.

I noticed our QVPR is about 65mb. Is this reasonable for QV?

Any help will be greatly appreciated.

Any ideas?

[#2]

Your IT team may have already suggested/attempted this but a reboot of the server may sort things out.

Windows can be notoriuos for corrupting page files at times and it's not uncomment for virtual memeory to be used even when the physical RAM seems plentiful.

At the very least stopping and restarting the service(s) may be benificial (it may clear out any orphan tasks and release any memory leaks).

It may also be an idea to check if any scheduled backups have over-ran and integrity of the servers filesystem as the server may be struggling to repair it's filesystem and run your import jobs at the same time

[karensmith]

I like the profile name and picture...

Thank you for your response. We have rebooted several times and have stopped and started services.

I will investigate corrupt page file and file system....thanks.

[Anonymous]

If you run the reports on their own and not through Publisher, do you get the same reload time?

[karensmith]

Yes same result with 64bit client running on server

[beristardj]

Hello Karen:

In my case, I solved it!, starting qv distribution services with an user with administrative privileges on the server, not on the domain.