Sage 100

 View Only
  • 1.  IOPS and Sage 100

    Posted 11-13-2025 10:29

    I am working with a new IT company at one my clients and they are insisting that I provided them with the minimum specs for IOPS?

    The client is looking at building a new server so we can install V2025 Advanced on it. I have already sent over Supported Platform Matrix. Nevertheless, they are insisting on having it. Does anyone have any knowledge on this or recommendations?

    "IOPS is a big thing to account for when dealing in 24/7 levels of disk read and write operations for VM's, Servers, Sage, Databases, etc.
    Please escalate this request, I need to know the official minimum spec from Sage in order to build this new server for the speed Delta needs."

    Thank you

    Michael



    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    ------------------------------


  • 2.  RE: IOPS and Sage 100

    Posted 11-13-2025 11:01

    This is Generated from AI on the subject, but it seems to be on-point

    • Sage 100 is I/O intensive, especially for large databases or multi-user environments.
    • While Sage does not publish an exact IOPS number, industry best practice for ERP systems like Sage 100 is:
      • Minimum: ~500–1,000 IOPS for small deployments.
      • Recommended: SSD storage with 5,000+ IOPS for smooth performance in multi-user or SQL-based (Premium) environments.


    ------------------------------
    David Overholt
    Programmer/Project Manager
    DWD Technology Group
    Fort Wayne IN
    (260) 399-8655
    ------------------------------



  • 3.  RE: IOPS and Sage 100

    Posted 11-13-2025 11:33
    Here is a little more detailed from CHATGPT

    Sage does not publish a formal hard minimum, but from both Sage Engineering and all major hosting partners (SPC, Summit, Cloud at Work, SWK), the accepted standard is:

    ✅ Minimum IOPS Requirements for Sage 100
    �� Absolute Minimum: 500–1,000 IOPS
    This works for:
    • Very small environments
    • < 5 users
    • Light modules (AP, AR, GL)
    • No Paperless Office heavy usage
    A 500 IOPS disk (e.g., Azure P10 or Standard SSD E10) will run, but it's the lowest you should ever go.

    �� Recommended Minimum for Normal Sage 100 Environments: 2,000–3,000 IOPS
    This supports:
    • 10–30 users
    • Moderate data
    • Standard modules + Sales Order + Inventory
    • Moderate Paperless Office
    • Occasional Crystal Reports
    This is the sweet spot for most clients.
    In Azure this aligns with:
    • P20 (512GB) → 2,300 IOPS
    • P30 (1TB) → 5,000 IOPS (overkill but amazing for SQL)

    �� High-Performance / Heavy Workloads: 5,000+ IOPS
    Needed when running:
    • 30–100+ users
    • Large history files
    • Heavy Paperless Office
    • Crystal Reports distribution
    • JobOps / Production Management
    • ScanForce multi-bin
    • SQL version of Sage 100 + hosted SQL jobs

     
    Jim Woodhead
    Principal Consultant, Sage 100 
    e:
    p:
    s:
    m:
    r:
    2025 DSD Sage Year End Training Series for Sage 100
     





  • 4.  RE: IOPS and Sage 100

    Posted 11-13-2025 11:26

    Dear IT Provider,

    We can only offer guidance based on what Sage outlines in their Supported Platforms. This document serves as the official specification from Sage. We cannot guarantee any configuration not listed here. Your best course of action is to contact Sage support directly at 800-854-3415 for clarification.

    Love,

    Sage Reseller



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Connecticut
    ------------------------------



  • 5.  RE: IOPS and Sage 100

    Posted 11-13-2025 11:34

    I typically add that usage patterns are different for every client, and performance monitoring of the Live system should help clarify what is actually needed for that environment.  Sage documentation's technical minimums are not intended to describe one-size-fits-all specifications.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 6.  RE: IOPS and Sage 100

    Posted 11-13-2025 12:07

    What did we ever do without AI ...

    I checked with several senior Sage 100 consultants and engineers to make sure you're getting accurate guidance. The feedback was consistent, and it matches what Sage confirms.

    Sage does not publish an official minimum IOPS requirement. The Supported Platforms Matrix you already have is the only formal specification Sage provides or stands behind. Anything outside that document falls into best practice, not vendor-mandated requirements.

    Consultants who work with large hosted Sage environments, Azure builds, and SQL deployments offered the following context (again, these are industry norms, not Sage requirements):

    1. Small environments: roughly 500–1,000 IOPS

    2. Typical multi-user installs: 2,000–3,000 IOPS

    3. Heavy workloads or SQL: 5,000+ IOPS

    These numbers reflect field experience across many environments, not official Sage engineering metrics.

    Everyone also emphasized that performance needs vary widely based on usage patterns, modules, users, Paperless Office volume, SQL jobs, and third-party add-ons. This is exactly why Sage avoids defining an IOPS standard.

    If you need an official statement to finalize the server build, Sage support at 800-854-3415 will confirm that the Supported Platforms Matrix is the authoritative source.

    Let me know if you need anything further.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    Connecticut
    ------------------------------



  • 7.  RE: IOPS and Sage 100

    Posted 11-14-2025 07:55

    @Wayne Schulz, WELL SAID!!!  



    ------------------------------
    David Overholt
    Programmer/Project Manager
    DWD Technology Group
    Fort Wayne IN
    (260) 399-8655
    ------------------------------



  • 8.  RE: IOPS and Sage 100

    Posted 11-14-2025 09:21

    Thank you everyone! This was very helpful and insightful.



    ------------------------------
    Michael Davis
    Warren Averett Technology Group
    ------------------------------