If your<\/span>ERP system<\/span> is unresponsive or seemigly <\/span>gets stuck a lot <\/span> then you are in the right place to fix the issues. Firstly we are going to analyse,<\/span>why there is two types<\/span> of slow. We will differentiate between 2 types of slowness and then give you 5 practical troubleshooting tips. <\/span>With the quick fixes we offer you should have the needed<\/span> tools to immediatly test it for yourself. Improvements should be <\/span>noticeable<\/span> immediatly.<\/span><\/span><\/p>\n<\/div><\/div><\/div><\/div><\/div> Everything has 2 few seconds of delay. Logging in takes longer. A constant feeling of lagginess. Sometimes clicks do not seem to register at all.<\/p>\n<\/div> Long load times<\/strong>: Logging in takes much longer then you would expect.<\/p>\n<\/div><\/li> Delayed reaction times<\/strong>: Every interaction, wether clicking or changing a setting, seems to only register after a relatively constant delay time.<\/p>\n<\/div><\/li> Non responses<\/strong>: Sometimes actions seem to be not registered at all.<\/p>\n<\/div><\/li> … <\/strong><\/p>\n<\/div><\/li><\/ul><\/div><\/div> General overload of the hardware or network. Possible misconfiguartion, or overload because of legacy data.<\/span><\/span><\/p>\n<\/div> Outdated system configuration<\/strong>: Best practices for servers and databases are constantly changing. In combination with accumulating data, this can cause significant slowing of your systems.<\/p>\n<\/div><\/li> Overburdened hardware resources:<\/b> A continuous increase in data and processes can push the hardware beyond its limits, affecting the performance of the ERP system.<\/p>\n<\/div><\/li> To improve the performance of your ERP system, it is recommended to identify and implement the latest ‘best practice’<\/i> infrastructure settings. This includes reviewing and adjusting Windows Server configurations as well as global settings of the database system. Furthermore, a hardware upgrade could be considered to achieve more efficient system performance. For detailed instructions and further information, we refer you to the “First Aid for Everyone”<\/u><\/span><\/a> section in the second part of the blog.<\/span><\/p>\n<\/div><\/div><\/div><\/div><\/div> In the “Slow 2” category, users of the ERP system experience significant delays in various processes, far exceeding the expected processing time. A classic case of: “You click and nothing happens, maybe an endless loading wheel”<\/span><\/i>.<\/span><\/p>\n This is not only inefficient but can also negatively affect the mental readiness and attitude of employees towards the ERP system. When everyday tasks become a drag and a frustrating experience, it can lead to the system being perceived negatively overall. This affects not only individual productivity but also overall workplace morale and the efficiency of the company. Therefore, it is crucial to identify and address these specific performance issues to ensure optimal system performance and a positive user experience. Examples of such actions include:<\/p>\n<\/div><\/div><\/div> Month-end closing<\/strong>: An excessively long process for month-end closing in the ERP system can delay important business decisions and impact efficiency.<\/p>\n<\/div><\/li> Production line evaluation<\/strong>: Delayed analysis of production data in the ERP system can lead to bottlenecks in production and delayed adaptation to market changes.<\/p>\n<\/div><\/li> Generating of new quotes<\/strong>: Slow generation of quotes in the ERP system affects customer response time and can reduce competitiveness.<\/p>\n<\/div><\/li><\/ul><\/div><\/div><\/div><\/div> What are the possible causes for these delays? In our experience, it is not the logic of the ERP system that is primarily responsible in most cases, but rather a suboptimal database query. But what specific errors could be behind this? Given the countless possibilities, a remote diagnosis is difficult. Here are some issues we frequently encounter:<\/p>\n<\/div> Database query issues:<\/strong>: This indicates inefficiencies in query management that can lead to excessive wait times. Unnecessary data might be queried.<\/p>\n<\/div><\/li> Suspected loops or multiple data retrievals<\/strong>: The system may unnecessarily repeat data queries, leading to delays. By effectively referencing already queried data, the process can avoid being slowed down by repeatedly requesting the same information.<\/p>\n<\/div><\/li> Indexing issues (no or incorrect indexing)<\/strong>: Without proper indexing, the system has to sift through all data until it finds the relevant entry. When data is indexed, it can be found much faster. Incorrect indexing can significantly slow down the search.<\/p>\n<\/div><\/li> Errors in setting the date filter (incorrectly or too late)<\/strong>: A common issue we see a lot. Initially, all data is retrieved regardless of the date, and then it is specified that only data from the last month is needed. By setting the filter early, retrieving irrelevant data can be effectively avoided.<\/p>\n<\/div><\/li><\/ul><\/div><\/div><\/div><\/div> The examples listed in the diagnosis provide insight into the variety of reasons that can lead to performance issues in ERP systems.<\/p>\n The key to the solution? By default, Windows Servers have the ‘Balanced’<\/i> power option enabled, which is not recommended for server applications.<\/span> An initial improvement can be achieved by switching this option to ‘High Performance’<\/i>.<\/p>\n …> ….<\/p>\n<\/div><\/div><\/div> Quick Analysis:<\/strong> For a fast and effective analysis of system performance, the reliable Windows Task Manager can be used. This helps to monitor CPU and RAM usage in real-time. Ensure that the idle capacities ideally do not exceed 30%. If these values are regularly exceeded, it is an indicator that increasing resources should be considered to ensure optimal system performance.<\/p>\n<\/div><\/li> Long-term Analysis:<\/strong> For a more in-depth analysis of system performance, it is recommended to use specialized external tools. These applications provide extensive insights into the long-term usage and efficiency of system resources, far beyond the current usage view of the Task Manager. Such tools enable the recognition of trends and patterns in resource usage, which is particularly helpful in identifying potential bottlenecks and taking preventive measures. Examples of such tools include SolarWinds<\/u><\/span><\/a><\/b><\/span>, Nagios<\/u><\/span><\/a><\/span><\/span><\/b> or 1. Slow \u2260 Slow<\/h2><\/h2><\/div>
1.1 Slow 1 – Everything seems laggy<\/h2><\/h2><\/div>
1.1.1 The symptoms of slow 1<\/h3><\/h3><\/div><\/div><\/div>
![\"An](\"https:\/\/netxconsult.de\/wp-content\/uploads\/2023\/12\/ERP_Langsam1_Traege.png\" "\\"ERP_Langsam1_Traege\\"")
<\/span><\/div><\/div><\/div><\/div><\/div>1.1.2 Diagnosis of slow 1<\/h3><\/h3><\/div>
1.1.3 Antidote to slow 1<\/h3><\/h3><\/div>
1.2 Slow 2 – A single function\/action takes very long (>eg. more then 20min)<\/h2><\/h2><\/div>
1.2.1 The symptons and the effects of slow 2<\/h3><\/h3><\/div>
![\"People](\"https:\/\/netxconsult.de\/wp-content\/uploads\/2023\/12\/Langsam_2_Lange_Wartezeit.png\" "\\"Langsam_2_Lange_Wartezeit\\"")
<\/span><\/div><\/div><\/div>1.2.2 Diagnoses of slow 2<\/h3><\/h3><\/div>
1.2.3 The antidote
\nagainst slow 2<\/h3><\/h3><\/div>
\nA detailed analysis of the system queries. Through such an in-depth investigation, problematic functions can be identified and subsequently optimized or reconfigured. There are numerous specialized tools from the manufacturers available for this purpose. However, it can be challenging for non-experts to apply these effectively.<\/a><\/p>\n<\/div><\/div><\/div>![\"A](\"https:\/\/netxconsult.de\/wp-content\/uploads\/2023\/12\/Diagnose_Langsam2_Kompliziert.png\" "\\"Diagnose_Langsam2_Kompliziert\\"")
<\/span><\/div><\/div><\/div><\/div><\/div><\/span> <\/span><\/h2><\/div>
2. First Aid for everyone<\/h1><\/h1><\/div><\/div><\/div><\/div><\/div>
![\"The](\"https:\/\/netxconsult.de\/wp-content\/uploads\/2023\/12\/Erste_Hilfe_Neu.png\" "\\"Erste_Hilfe_Neu\\"")
<\/span><\/div><\/div><\/div><\/div><\/div>2.1 Windows Server<\/h2><\/h2><\/div>
2.1.1 Power Options<\/h3><\/h3><\/div>
![\"The](\"https:\/\/netxconsult.de\/wp-content\/uploads\/2023\/11\/Energieoptionen_Windows_Server.jpg\" "\\"Energieoptionen_Windows_Server\\"")
<\/span><\/div><\/div><\/div><\/div><\/div>2.1.2 Analysis of Server Resources<\/h3><\/h3><\/div>