Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

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
ToniKautto
Employee
Employee

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.
korsikov
Partner - Specialist III
Partner - Specialist III

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
ToniKautto
Employee
Employee

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.