asked on Optimize ODBC in a Windows 2019 Terminal Server Environment
Optimize the performance of Microsoft Access ODBC in a Windows Server 2019 Terminal Server Environment. We have an MS Access DB, connected via QODBC to a very large QuickBooks Company File. I am hoping to find registry entries that might improve the performance. The hardware is quite new. SSD's in a RAID 10. The terminal server is a VM on the same physical machine as the Quickbooks file.
Windows OSMicrosoftMicrosoft Access
Last Comment
Rick Rudolph
Have you checked optimization tips : https://support.flexquarters.com/esupport/index.php?/Knowledgebase/Article/View/2358
ASKER
I did actually already go through the optimizer. I am closing this question, we are going to have to compress the database, which will involve Intuit support as the process always throws some errors, which is why the database has grown to such an unmanageable size.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Slow performance deals with multiple users accessing it?
The QB is managed by the host while you are working within the VM?
I think I see your issue, the hypervisor scheduler is subordinated by the host priority which is higher.
Which hypervisor? Hyper-V?