Solved: Re: shared storage solution is supported by Qlikvi... - Qlik Community

mohamed_ahid · ‎2019-10-08

Hello

which shared storage solution is supported by Qlikview server .

i'v found here that the only one is windows shared files and nas in only few cases .

https://qliksupport.force.com/articles/Basic/Does-QlikView-Support-NAS-Storage?articleId=Does-QlikVi...

Can you give more details about that ? in which case is supported on nas storage ?

Thank you

Brett_Bleess · ‎2019-10-17

Mohamed, I would not recommend putting file services on the QVServer, that can become a potential bottleneck if the QVServer gets very busy handling the users, it would be best to have a separate file server machine... If the 10 apps are pretty small and have very efficient data models and the users will not be creating a lot of server objects etc., then it may be ok, but I would keep a close eye on things... The VM hit these days is much smaller than it used to be as well in regard to performance, provided the VM host machine is not oversubscribed... Be sure the VM admins understand our product is more like SQL Server than it is a File Server...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

NadiaB · ‎2019-10-08

hI @mohamed_ahid

Have you checked the "Shared Network Storage" section in our Qlik Help portal?

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm

mohamed_ahid · ‎2019-10-14

Hi @NadiaB ,

Thank you .that was usefull .

Regards

Brett_Bleess · ‎2019-10-14

Mohamed, just wanted to let you know NAS is only going to work for you if the admins can pretty much keep the disk response to less than 4ms and there is no I/O bottleneck or network latency etc. NAS is not officially supported at this point too, just FYI, so if you were to submit an issue that is deemed to be storage related, we would need to test things using either local disks on one of the servers or a SAN unit etc. to confirm we still see the issue there... I do know a handful of customers that use NAS and seem to not have issues, it pretty much boils down to the knowledge of the NAS admins and them being able to optimized things for high I/O and low disk response etc. Hopefully this may help a little more in addition to what is stated in the Help. R&D do continue to look at NAS to come up with supported solution, but thus far we have not been able to do so on the QlikView side.

Cheers,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

mohamed_ahid · ‎2019-10-15

Hi BrettBleess,

Thank you for theses precisions .

Is there some tests that you suggest me to proceed before setuping this solution?

when using windows shared storage or Nas .schould i have a publisher server ?

Regards

Brett_Bleess · ‎2019-10-15

Mohamed, here would be the best place to look around, the Scalability area, they have some tools you may be able to run in order to see what kind of load things will handle before you start having issues.

https://community.qlik.com/t5/Qlik-Scalability/gp-p/qlik-scalability

Not sure I understand your question on Publisher, sorry, if you do have Publisher, would recommend you run that on its own server if you can, and it should point to separate driver/partition on the storage device. Here is a new scalability article for Publisher that may be helpful:

Scaling QlikView Publisher

If you just have the Reload Engine, then that has to run on the QVServer machine, but if you are doing most of your reloading overnight, things should be fine, the only thing you may need to do potentially is tweak your QVServer Low Working Set limit on the Performance tab settings of your QVS resource in QMC to free up some memory resources for the Reloads... The default setting is 70% there, if the Reloads seem to be causing the server to have to hit disk page file, you can drop that low limit to say 50% and try that and see if that helps. What that will do is force the QVS to release memory if other services need it...

Shout if you have further questions, but hopefully this helps.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

mohamed_ahid · ‎2019-10-16

Ok Thank you .

To come back to my initial need .The purpose is not really clustering my architecture but only create a shared storage solution for my stand alone QV server (we do not have the right to copy applications or data directly into the windows server) .So the QV server can access to this storage and copy by it self applications and data when loading .(see the attachement)

i think may be SAN will be better and more efficient .

any suggestions ?

Regards

Brett_Bleess · ‎2019-10-16

Mohamed, the only thing that confused me is you used SAN on the Developer side and NAS on the QVS side! 🙂 If you have VM running Windows OS that is running the File Services role and is attached to a SAN or other storage unit via direct connection, say fiber etc., that should definitely work pretty well. So, just to confirm, the QVS settings on the Folder tab in the QMC are pointing to a UNC path, correct? If so, the only danger with things is really accessing the .shared/.tshared and .meta files as well as the .pgo files, those need to be able to run pretty quickly, so that is going to be your potential issue area if you have any. If NAS is all you have at the moment, I would say go ahead and run with things and see how it goes, if you do not have too many apps etc., and the NAS is very fast and properly optimtized, things may be fine for now. Hopefully this makes sense, shout if you have further questions. What you will want to watch for are messages in the QVS Event log along the lines of Warning or Error messages that say the service could not reach the .pgo, .shared, .tshared or .meta files as well as the .qvw files for that matter. If you start seeing those, that will be a likely indication the storage is not able to keep up with things.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

mohamed_ahid · ‎2019-10-17

Hello Brettbleess,

Thank you for your help.

I'm sorry ,i have mistaked on the schema .I was meaning SAN for two sides .(the schema is corrected)

until today, we have not yet decided what to take as architecture(SAN? ,NAS? other ?) .But we know that we will not have access directly to the windows server who will be hosting the qlikview server (for security purpose).That's why i thought about using a shared storage area .(may be if you have any other suggestions will be welcome)

This shared storage area will be accessible for developpers from one side and the server from other side .The question is should i just setting the QVS Folder tab in the QMC to point to a UNC path(on the shared area) or completely copy what i need from the shared area to the server ?

what are the possibilities to have the fastest ,secured and stable solution possible ?

What type of shared storage will be most suitable for us?which type .physical or virtual ?

Thank you !

Regards

Brett_Bleess · ‎2019-10-17

Mohamed, stick with your SAN unit, that is supported, so you should be good there, and as far as specs, you want disk response on the file server in front of the SAN at 4ms or less, and be sure things the SAN is configured to optimize for high input/output as well, that should put in good shape. The only other thing I can tell you is be sure the Windows box attached to the SAN is running the Max Performance power option in the Windows Control Panel Power Options settings as well to be sure the OS can run as efficiently as possible too.

Here is a Help link for you as well that talks a little about storage that may be useful too:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Server/Content/QV_Server/QlikView-Server/Q...

It is applicable whether you have a cluster or not! 🙂

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.