Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

mwallman
Contributor II

Does Windows Disk Defragment help in run a Qlik Sense server better?

Hi,

Does running the Windows Defragement tool make the Qlik Sense server performance any better?

In our Qlik Sense server we have noticed some of the drives are 68% defragmented but don't know if that's a good thing or a bad thing.

Can someone with expert knowledge advice please?

3 Replies
Employee
Employee

Re: Does Windows Disk Defragment help in run a Qlik Sense server better?

It think the answer comes down to what type of disk you have deployed and sort of disk I/O your are experiencing.

Fragmentation mostly affects mechanical disk, where latency is added by additional physical effort related to the reading a fragmented file from disk. The file size and how much it is fragmented also affect the observed performance.
I have never experienced fragmentation related performance issues on SSD disks.

End-user triggered calculation and interaction runs in-memory, so slower disk will not typically impact end-user perception. Qlik Sense will access files when apps are opened, edited or reloaded. So it might be worth making some observations about response times, and evaluate if you perceive it as an issue or not. Then defrag and compare the results.
Highlighted
Partner
Partner

Re: Does Windows Disk Defragment help in run a Qlik Sense server better?

No, because Qlik Sense is a In Memory BI 🙂
Acceleration of the disk subsystem will not have a strong impact on the operation of the business analysis system
Employee
Employee

Re: Does Windows Disk Defragment help in run a Qlik Sense server better?

It depends on the serer side activities. You have to keep in mind that there is still a significant amount of disk I/0 for app and QVD files during opening closing a reload. Repository database also utilizes disk.
I would not neglect the risk with mechanical disk, but also recommend SSD disks to performance optimize disks.