We normally leave our GP support to our vendor but now and then I (solo IT guy) need to troubleshoot some issues.
Our SQL Server which hosts our GP 2010 application is a Windows Server 2008 Standard 32 Bit with 4GB of RAM. Since we have other DB's on here, the machine is pretty busy. While CPU usually is low, the Memory usage is usually over 3GB over time. I usually reboot on Sunday evenings as it improves performance for Monday's payroll entry and other things.
The biggest complain is the transaction entry screen. Usually on the first entry of the day, it is very sluggish...tabbing through fields can take forever. However, usually after the first entry, it will be fine. Sometimes, it may slow down again but it is usually the first entry of the day that is so slow.
As a Systems Administrator, I am planning on getting us upgraded to a 64 bit OS with more memory, so I know that can't hurt. However, for now, I need to find ways to fix this problem. We are allowed 6 calls a year to MS for GP issued but wanted to hit the forums first.
Thanks...
Brian
*This post is locked for comments