On a qv11 server I sometimes had reload problems and, after failed reload, performance problems.
I scheduled a weekly restart and, since that, I didn't get any other problem.
Per se, restarting any Windows service does not stabilize the environment nor the service. But for the hundred different reasons in your environment, you may need to do that, and there is nothing wrong in it.
But I agree as well that if you need to do that is probably because you are experiencing issues. If that is correct, then try to find out which issues they are, and do not work the symptoms, but the causes:
- heavier expressions?
- heavier documents with more objects and more sheets?
- more complex data model?
- more rows in the same model?
- more users or concurrent users?
Maybe you need a complete infrastructure and applications healthcheck.
Thanks for your reply..
Yes due to perform reasons we are restarting it, feel much better when we do this.
We are using System monitor in our environment, so before we bring in the process of restarting the services weekly, it was showing up inappropriate details especially in Performance tab, for few users itself it was showing 100 GB like that.
But now this looks more reliable.
One more thing I'm bothered is about the Garbage collection of QV10 I don't know whether it is that efficient as latest version.
Thanks & Regards,
Restarting the services clears the cache. This means that the next time you start using documents things might be a bit slower, as everything needs to be "cached up" and loaded into memory.
If you are experiencing issues with this, you might have a resource issue.
What specifically is "much better" due to your restarts?
Yes, old cache that is not used will be replaced by newer cache if needed. If not, it will stay in memory. Have a look at http://www.qlik.com/jp/~/media/Files/resource-library/global-us/direct/datasheets/DS-Technical-Brief-QlikView-Architecture-and-System-Resource-Usage-EN.ashx or http://www.qlik.com/au//~/media/Files/resource-library/global-us/direct/datasheets/DS-Technical-Brief-QlikView-Server-Me… which can explain further in-depth about how it is used.