12 Days of ECHO, Eleventh Day: My Admin Gave to Me, notes on Online Transaction Processing vs. Decision Support!
Enterprise Resource Planning (ERP): Online Transaction Processing vs. Decision Support So, you’ve got your ERP system up and running, and before long, the management team wants reports, dashboards and executive data out of the system. That makes perfect...
12 Days of ECHO, Tenth Day: My Admin Gave to Me, Epicor Performance and Diagnostic Tool Checks!
SQL and the Reporting Engine Epicor ERP 10 provides the Performance and Diagnostics Tool as part of your Epicor Administration Console. While the tool is often installed when setting up an E10 solution, it’s often forgotten about afterwards. The full tool has...
12 Days of ECHO, Ninth Day: My Admin Gave to Me, Fixes so SSRS Won’t Hog Epicor CPU!
SQL and the Reporting Engine Epicor ERP 10 requires two primary SQL functions, the SQL Engine and the Reporting Engine, also known as SSRS – SQL Server Reporting Services. Each require a SQL licensed, but if you run both on the SAME operating system instance,...
12 Days of ECHO, Eighth Day: My Admin Gave to Me, Tips on Epicor SQL Transaction Log Maintenance!
Epicor and Microsoft SQL Transaction Log Maintenance - Performance Tips and Tricks Many Epicor 10 ERP installations suffer from a “lack of DBA”. It’s not for lack of desire, but keeping a full-time DBA (Database Administrator) on staff can be expensive. ...
12 Days of ECHO, Seventh Day: My Admin Gave to Me, Tips on Epicor ERP 10 Server Disk Space!
Epicor ERP 10 Server Disk Space – Where'd It Go? Do you ever wonder where your server’s disk space goes? Many times, you might not even notice until a server crashes with an ‘out of disk’ error message, or some application stops working. Only then might you start...
12 Days of ECHO, Sixth Day: My Admin Gave to Me a Fix for Microsoft IIS Log Sprawl!
Microsoft IIS Log Sprawl: Getting Away from the Sprawl On the Sixth Day of ECHO, my admin gave to me, some tips about Microsoft Internet Information Services (IIS) and log files! Every Epicor E10 and Prophet 21 Middleware server uses Microsoft Internet...
12 Days of ECHO, Fifth Day: My Admin Gave to Me Too Much RAM for My Epicor VM!
Too Much CPU & RAM for Epicor Application Server Sometimes, more memory is not better. Often, server admins will throw more resources (CPU and RAM) at a server to make it go faster. Check our tidbit on SQL Licensing to see what that might hurt your licensing...
12 Days of ECHO, Fourth Day: My Admin Gave to Me Tips on SQL 64k Clusters!
Tips on SQL 64K Clusters and Epicor SQL Services Database Bytes Microsoft SQL likes to do all its input/output in 64k chunks, but Windows likes to format hard drives in 4K chunks called "clusters". Studies have shown that formatting the volumes that store SQL...
12 Days of ECHO, Third Day: Some Notes on Epicor ERP Auto-Login and SysConfig!
On the Third Day of ECHO, my sys admin gave to me, swift yet safe: Auto-Login in Epicor 10.1 and beyond. Interacting with technology can become a perpetual struggle between ease-of-use and security-of-use. The two seem at odds, such that increases in security...
12 Days of ECHO, Second Day: SQL Licensing
On the First Day of ECHO, my System Admin gave to me, SQL Licensing! You probably already know that Microsoft SQL Server is required for Epicor 10 and Prophet 21, but do you know if you are in Microsoft compliance? SQL licensing can be confusing, but in most...