Rating
Dynamic Drive Tabs
Dynamic Drive Tabs
Dynamics Gp Partner News: Great Plains ERP Performance Tuning
If you have Microsoft Dynamics GP formerly known as Great Plains Dynamics implemented in your organization and you are experiencing performance issues, we would like to present you this small publication, written in the form of FAQ and highlights. Dynamics GP is module based application and it is hosted in Microsoft SQL Server 2005, 2008 or even 2000 on Microsoft Windows 2003 or 2008 Server Operating System – obviously performance tuning should be analyzed at Windows and SQL Server sides first:
1. Microsoft SQL Server. Here you should try to reduce number of protocols installed, ideally having TCP/IP only – if you do not have legacy Operating System and Networking parts, such as Novell – you should be OK to have TCP/IP as the only protocol. Normally you should allow SQL Server to control operating system RAM, however in the cases when you have other application potentially competing for the Server memory, try to reduce maximum SQL Server memory to 5-15% of total RAM. With older versions of Great Plains, we saw the issues with TCP address resolution by server name. So, please, check the resolution and potentially add IP address resolution locally in the hosts file, or even try to specify IP address directly in ODBC System DSN, usually named Dynamics GP
2. Windows Server side tuning. Control Panel System Properties, click Advanced tab and then Settings in the Performance section – be sure to switch Background Services in Adjust for the best performance. In the Virtual Memory section consider to place Pagefile.sys to the hard drive, different from the one, where SQL databases are hosted and size it at minimum being 1.5 of the system RAM. And the third hint – in File and Printer Sharing form Microsoft Networks Properties switch to Maximize data throughput for network applications
3. Hardware RAID consideration. In this paper we assume that you are mid-size or small organization, if you have over 75 Dynamics GP concurrent users, please give us a call for further directions. Consider SCSI RAID 0 for Log Files and Operating System, RAD 5 or RAID 10 for Database files. If you have some luxury hardware budget, consider placing SQL backup files to RAID 1 (stripping hard disks, having maximum writing performance). If possible, place page file to separate RAID 0 as well
4. Other hardware tips. Be sure that you have minimal number of switch-like connections to reach the server from your Dynamics GP workstation (versus cascade of passive hubs, obviously eliminate all 10BaseT nodes)
5. If all the above advises do not help you, then you should prepare to SQL Profiler tracing, logging Dex ODBC and SQL statements and other tools, typically recommended for Microsoft Dynamics GP technical consultant
About the Author
Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com 1-866-528-0577, http://www.albaspectrum.com. Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our Dynamics GP call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Costa Rica, Honduras, Nicaragua, Panama, Russia, Belgium, Holland, Germany, France, Central America
BMW Z4 sDrive35i
|
|
Rockford Fosgate Punch 400-Watt Stereo Amplifier $175.13 Whether you’re looking to drive high frequency component speakers or low frequency subwoofers, the P400-2 has the power and flexibility you need to put some serious PUNCH in your vehicle. The power available from such a small amp means it’s a great match for a 2-ohm DVC subwoofer or pair of 8-ohm SVC subwoofers. Rockford Fosgate Punch Series Amplification For over 25 years, Punch… |
|
|
Rockford Power T500-1bdCP Mono Amplifier $274.89 The T500-1bdCP is based on the legendary T500-1bd amplifier design with a proprietary “Constant Power” configuration delivering up to 25% more power (Watts) across all impedance loads. The listening experience is cleaner, louder and more impressive than ever before. With the T500-1bdCP, you can now use an “under-the-seat” dedicated subwoofer amplifier to drive two 4-Ohm DVC subwoofers. This amp wi… |
|
|
Rockford Fosgate Punch 200-Watt Stereo Amplifier $159.95 The P200-2 is a solid choice if you’re looking to drive coaxial speakers and/or one 4-ohm SVC subwoofer. With proven PUNCH technology, the P200-2 delivers real Rockford Fosgate power from a small footprint and won’t leave you strapped for cash. Rockford Fosgate Punch Series Amplification For over 25 years, Punch amplifiers have set the standard in the car audio amplifier industry… |
Have A Question?
Are you looking for something but can not find it, or have a question for us? We would love to help you. Just fill out the form below and we will get back to you as soon as possible.
