Our company has twenty users on a domain environment. We are running SQL Server 2014 on Hyper-V with static RAM of 136 GB and 32 virtual processors. The VHD is also static.
The host machine has a total of 192 GB RAM and two, 16-Core processors (Intel Xeon).
We have only the one SQL server with about 12 databases. We are in the painful mode of migrating our query logic from pass-through queries in Access to stored procedures in SQL. Years of VB code are being rewritten, so this is going to take several more months.
In the meantime, we are incredibly frustrated with performance. The most common issue is ODBC timeouts using Access queries. The funny thing is that the same query may run just fine on one workstation, but not another. Then, the next minute it is fine. Other times, there may not be a timeout error but it's just super slow.
We invested in a 10Gb backbone and have teamed up the NICs on the server to ensure bandwidth is not the issue. There is plenty of hard drive space. The SQL server and data resides on the server's RAID-5 array. We have regular maintenance for indexing, etc.
What other areas might I check? Is it possible that 15-20 users is too much for this kind of SQL configuration? I am just trying to see what threshold we are up against. Thank you for any guidance.