x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 146 subscribers
  • Views 613 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
8k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
15
topics
20
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
443
replies
James RL Smith

Poor Sage 100 Contractor Performance

Posted By

We are currently fighting a weird issue with a customers installation. We are running Sage 100 Contractor and when users use the print preview function when generating reports Sage will hang for a good 1-5 minutes depending on the report. After the preview is generated the same type of delay can happen when printing to local printers. Server specs are below:

OS: Windows Server 2019 Essentials

Processor: Xeon E-2278G

Ram: 32 (16 dedicated to SQL whilst troubleshooting)

Storage: 10k SAS Drives in a Raid 0 config (again for troubleshooting)

Sage: Sage 100 Contractor 2022 with Database version 24.3.1.0003

I have been looking around the internet to no real avail in addition to contacting Sage support and after a year we are still having issues.

Any help would be appreciated.

  • 0

    I'm not sure if this is the answer to your problem but I know we have a similar issue with Sage 300 CRE and it's because we haven't archived old data for a while. It took me over an hour to generate a 941 tax report just last week. AR reports are also generally run overnight because they take so long. Good luck!

  • 0

    I have more questions (which may provide some direction/help):

    1. Are you using SQL Express or Standard?
    2. What version of SQL are you using?
    3. Have you looked at the SQL Server Memory Allocation Status and Recent PLE (in Sage 100 Contractor Database Administration under Toolbox > Dashboard) and what do you find there?
    4. How many SQL Instances do you have on this machine?
    5. As ALICIADH suggests, have you archived data and if so, when was the last archive?

    Todd Baker
    Consultant

*Community Hub is the new name for Sage City