How to Improve Webgility Desktop Performance by Upgrading System Resources and SQL Server
This article helps Webgility Desktop users improve performance and resolve lag issues caused by insufficient system resources or outdated SQL Server configurations. It provides steps for upgrading hardware and optimizing SQL Server settings.
Causes of Performance Issues
Webgility Desktop performance issues may occur due to:
-
Outdated SQL Server version (e.g., SQL Server 2016).
-
Limited RAM (less than 16GB of system memory).
-
Unoptimized SQL Server configuration (memory allocation or service roles).
Step-by-Step Instructions
1. Check System Specs
-
Go to Control Panel > System and Security > System.
-
Verify your system has at least 16GB RAM.
-
Note the SQL Server version installed (SQL Server 2016 may need an upgrade).
2. Upgrade RAM (If Less Than 16GB)
-
Shut down the computer.
-
Install additional memory modules to reach 16GB or more.
-
Restart the machine and verify the upgrade in System Properties.
3. Optimize SQL Server Memory Allocation
-
Open SQL Server Management Studio (SSMS).
-
Right-click on the SQL Server instance > Properties.
-
Go to Memory section.
-
Set Maximum Server Memory to around 75% of total RAM (e.g., 12GB if system has 16GB).
4. Restart SQL Services
-
Open Services (services.msc).
-
Locate SQL Server (InstanceName).
-
Right-click and choose Restart.
5. Relaunch Webgility Desktop
-
Open Webgility Desktop.
-
Perform routine operations and confirm improved speed and responsiveness.
Notes
-
Always allocate enough memory for the OS when configuring SQL Server.
-
Avoid running heavy background processes while using Webgility Desktop.
-
Periodic maintenance (e.g., SQL indexing, disk cleanup) also helps maintain performance.