Greetings, Autodesk Community.
We did migrate from the old hardware/operation system to newer ones.
The previous physical server ran Windows 2008 R2, Storage RAID 1 SATA III SSDs, 32 GB RAM, and SQL 2014 Express.
The current physical Server is a Dell R540 with 2 sockets Intel Xeon Silver 4110 and Storage RAID 1 SATA III HDDs.
Storage has ~ 200 MByte/s read speed.
Virtual machine with Windows 2016 Server, SQL 2019, 16 GB RAM, 6 Virtual CPUs.
The drafting department has concerns about slowdowns in getting, check-in.
According to the https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/How-to-improve-Vau..., I did identify bottleneck MS SQL utilizing CPU and read speed from storage.
According to monitoring from last month, Microsoft SQL Server in peak utilizes
only 15-20% virtual CPU and 5-20% disk read speed maximum.
I suggest three possible ways to increase Vual server performance possibly:
Scenario 1. Tune up the MS SQL.
Scenario 2. Try Vault Professional.
Scenario 3. Try a server with faster storage read/write speeds and a faster/better CPU.
Could I kindly ask you to help find the best way to improve Vault server performance?
