I need some advice for a setup solution.
Windows Server 2016 with one SSD as boot drive and two hard drives in mirroring setup as E:\ drive.
RDP User profile Disks are under E:\profiles.
When I put some Microsoft Access tables to C: drive, i am only getting the performance of those hard drives. I am wrong to assume that User Profile Disks located on E: is the bottleneck here?
I cant tell why or how it just seems that everything is going through E: drive even when data is on C:.
The hard drives and SSD are healthy.
Checked them using different OS.
Also the performance of the SSD is fine when doing queries from a local computer.
Only when in remote session, everything is slow, like hard drive slow not extremely slow.
If thats the case, would installing SSDs instead of hard drives help with the performance?
Installing a SSD and cloning data to it along with user profile disks.