Sage 100

 View Only

  • 1.  Sage 100 Premium (4.50) - This was an upgrade from

    Posted 03-24-2014 12:03
    Sage 100 Premium (4.50) - This was an upgrade from 4.50 MAS 200. Reports are running incredibly slow. To run General Ledger Detail for cash account (one month) takes over 30 minutes. I suspect it could be bad indexes. Any resolutions on this?


  • 2.  RE: Sage 100 Premium (4.50) - This was an upgrade from

    Posted 03-24-2014 12:19
    You're SURE it's not the AV? Maybe scanning this new folder? Otherwise, blame it all on SQL. :-)


  • 3.  RE: Sage 100 Premium (4.50) - This was an upgrade from

    Posted 03-24-2014 12:27
    Just check the server. No AV installed on the server.


  • 4.  RE: Sage 100 Premium (4.50) - This was an upgrade from

    Posted 03-24-2014 12:32
    Is it SQL Server Standard or just Express edition? Express limits to 1 CPU and 1GB RAM, I believe. While the report is running, what are the CPU and RAM specs of the server itself (is it maxing out either or both, etc)?


  • 5.  RE: Sage 100 Premium (4.50) - This was an upgrade from

    Posted 03-24-2014 19:10
    SQL Server Standard. Will get specs.


Related Content