Dynamics,Partner,News,Great,Pl computer Dynamics GP Partner News: Great Plains ERP performance tunin
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
Dynamics GP is module based application and it is hosted inMicrosoft SQL Server 2005, 2008 or even 2000 on Microsoft Windows 2003 or 2008Server Operating System obviously performance tuning should be analyzed atWindows and SQL Server sides first: 1. Microsoft SQL Server. Here you should try to reduce number of protocolsinstalled, ideally having TCP/IP only if you do not have legacy OperatingSystem and Networking parts, such as Novell you should be OK to have TCP/IPas the only protocol. Normally youshould allow SQL Server to control operating system RAM, however in the caseswhen you have other application potentially competing for the Server memory, tryto reduce maximum SQL Server memory to 5-15% of total RAM. With older versions of Great Plains, we sawthe issues with TCP address resolution by server name. So, please, check the resolution andpotentially add IP address resolution locally in the hosts file, or even try tospecify IP address directly in ODBC System DSN, usually named Dynamics GP 2. Windows Server side tuning. Control Panel System Properties, clickAdvanced tab and then Settings in the Performance section be sure to switchBackground Services in Adjust for the best performance. In the Virtual Memory section consider toplace Pagefile.sys to the hard drive, different from the one, where SQLdatabases are hosted and size it at minimum being 1.5 of the system RAM. And the third hint in File and PrinterSharing form Microsoft Networks Properties switch to Maximize data throughputfor network applications 3. Hardware RAID consideration. In this paper we assume that you are mid-sizeor small organization, if you have over 75 Dynamics GP concurrent users, pleasegive us a call for further directions. ConsiderSCSI RAID 0 for Log Files and Operating System, RAD 5 or RAID 10 for Databasefiles. If you have some luxury hardwarebudget, consider placing SQL backup files to RAID 1 (stripping hard disks,having maximum writing performance). Ifpossible, place page file to separate RAID 0 as well 4. Other hardware tips. Be sure that you have minimal number ofswitch-like connections to reach the server from your Dynamics GP workstation (versuscascade of passive hubs, obviously eliminate all 10BaseT nodes) 5. If all the above advises do not help you, thenyou should prepare to SQL Profiler tracing, logging Dex ODBC and SQL statementsand other tools, typically recommended for Microsoft Dynamics GP technicalconsultant
Dynamics,Partner,News,Great,Pl