A technician is troubleshooting a Windows 11 workstation hosting a localized database service that experiences severe responsiveness degradation during peak data processing hours. Using Resource Monitor, the technician observes that the hard faults per second for `dbengine.exe` frequently exceed 800/sec, and the Average Disk Queue Length on the primary storage volume () remains continuously above 12. However, Task Manager indicates total physical RAM utilization is at only 60%. Further inspection reveals that an automated script recently disabled `pagefile.sys` on the primary drive. Which of the following actions will best resolve the performance degradation and high disk latency?
- Re-enable a system-managed virtual memory paging file on the primary SSD drive.Answer
- BExecute `sfc /scannow` from an elevated command prompt to repair corrupted system memory management binaries.
- CUse Performance Monitor to add a custom Data Collector Set that dynamically forces additional physical RAM allocation to `dbengine.exe`.
- DModify the application properties of `dbengine.exe` to run under Windows 10 compatibility mode with administrator privileges.
Answer
Re-enable a system-managed virtual memory paging file on the primary SSD drive.
High hard faults/sec combined with excessive disk queue length indicate severe virtual memory paging pressure on the storage subsystem. Disabling `pagefile.sys` forces the Windows Memory Manager to discard executable code pages from memory and repeatedly reload them from disk when needed, generating continuous disk reads and thrashing. Re-enabling a system-managed paging file on the primary SSD restores proper virtual memory mapping, drastically reducing hard fault latency.
Step-by-Step Solution
Key Concept
Windows Virtual Memory and Pagefile Misconfiguration