Browse By Tags

  • Application Performance

    Will inactivating or deleting assets help make the program run smoother/faster? Our database has a significant number of fixed/intangible assets and running reports sometime takes a long time and I am sometimes booted out of the program. Our program…
  • Performance: "Call SYSTEME From ORDSYS" takes about 15 seconds

    Dear readers Does anybody know how to investigate a performance issue that obviously takes places in the X3 standard function ORDSYS.SYSTEME() ? Any help is welcome! Regards, Benjamin
  • Internet Speed Affecting Performance

    Hello! My office is in a remote area, so the internet can be inconsistent at times. I've noticed when we have internet slowdowns or outages, Sage moves so slowly that we can't get any work done. My Sage 50 company is hosted on an onsite server.…
  • Sage 300 2022 (PU1) Workstation clients - Random Database connection errors and terrible performance

    We have Sage 2022.1 on our server which is performing perfectly (on the server or through RDP with our VPN firewall). We've installed the Sage Workstation (WSSETUP), ran the Database Setup which created the ODBC and the test connection is fine. Hours…
  • How can I find the SQL execution plan for a custom view in SQL Server Management Studio?

    You may have created some custom views in your Sage X3 system but are finding them slow to execute. The first step in diagnosing poorly performing SQL is often checking the SQL execution plan, but how can you do this with Sage X3 custom views? First…
  • Problem opening Sage 300 desktop form

    Hi all, I have problem opening any Sage 300 desktop form which just happen this week after windows update. The form still opening but the popup and error are annoying. Anyone know how to solve this? Thank you.
  • Sage 100 2021.1 slow module opening

    The slow performance within a module that I complained about last month seems to be cured by rebuilding the search index, but performance when opening a screen (eg. item inquiry) is quite a bit slower than 2018. (old thread: https://www.sagecity.com/support_communities…
  • Sage 100 2021 premium slow performance

    Setting up my testing environment (test => prod) and performance is unberably slow. Typing in an item code in inquiry has a multiple-second delay between key presses and seeing letters. Search-while-typing is enabled, as it is in in my live 2018 installation…
  • sage 50 quantum v2019.1-2019.4 performance with Windows 10 updates 20h2

    hi i'm not a Sage user but i'm helping my client with a sage issue she is running Sage 50 quantum v2019.1 PC is a i5 7500, 8GB on a dell WS + mirrored HDD drives. Win10Pro v1809 Sage is ran locally on this PC, which she RDPs to from her mail PC…
  • TSService (32 bit)

    Hi, TSService (32 bit) is constantly eating up the cpu even when timeslips is not open or in use. It's a fresh install on a new server since I was having the same issue on an old server so tried everything from scratch with a clean install. This is…
  • New Sage 100 2020 Advanced Installation - Poor Performance

    We're in the process of upgrading from Sage 100 2017 Standard to Sage 100 2020, and while I'm not clear on the details (the accounting guys take care of that) based on our license we apparently were able to acquire Sage 100 2020 Advanced free of charge…
  • Has anyone noticed Estimating performing slower when connecting to SQL Database with Windows 10 machine?

    Finding that the response of SQL Estimating is delayed when working with a Windows 10 machine (specifically when modifying a column with grouped items). Here is what we've tried/found so far: Working in an environment where the SQL Database is hosted…
  • Sage Advanced vs Premium

    We are planning to upgrade Standard to Premium based on the assumption that Premium is comparable (or not much slower than) to Advanced in terms of data input and reporting speed. Standard is very slow and painful to use, so our team needs better performance…
  • Sage 300 Performance

    Hello All , Quick Question, Could Sage 300 cope up with a load 20-30k transactions per day? Thanks
  • customer pricing best practices for many customers

    We have many customers that require we treat their various ship tos as bill to's. So, despite the customer locations having a common owner, the billing and account maintenance of each location must be treated as it's own entity. Since MAS90 (sage 100c…
  • The Design of Web Service Applications and Performance

    My hope is that if you have attended any of my presentations about the Web Services interface for Sage CRM you will have taken away with you an impression of the importance of the design of the client application and how this would affect performance…
  • MSSQL Index analysis and creation from Sage CRM (Part 1 of 2)

    This article has come from a very experienced colleague in Australia. Introduction Microsoft SQL Server 2005 added new system tables to assist in the system reporting. Three of these tables in particular are written to every time a query is run. Microsoft…
  • Sage 300 2019 very slow connection to SQL database

    Hi, Upgraded a client to sage 6.6 and sql 2017. When users log in to Sage, the screen hangs on connecting to database and takes a while to establish connection. Once connected, processing is ok however report printing is again very slow. Ping test…
  • Abnormally High/Rapidly increasing Fragmentation Levels?

    Hello, We have been trying to troubleshoot our slow performance with SAGE 100 PREMIUM 2018 and are running out of options. I have read all the articles here and on the knowledge-base, and nothing seems to be improving our performance. My last inquiry…
  • sage300 OE performance Issue

    we are running sage300 2017 with the latest PU. We are experiencing system freeze mostly when users are performing entries using OE. we have set the Day END to run using DAY periodic function instead of during posting, this still did not resolve the…
  • Data Purge Parameters

    Hi, We are a Blending & Packaging plant and have v9 Patch 5. We have 'never' archived/purged in our Sage X3 (EM) so we have over 10yrs of data (Since June 2008...) We've started to purge out some old data like the ATRACE and investigating into the…
  • TimeSlips 2019 slow response issues

    FormerMember
    FormerMember
    Greetings everyone, We are experiencing a lot issues with TimeSlips 2019 being unresponsive. When we go to look up and or enter timeslips, we have to wait a few seconds for the screen to populate. This is running from local network clients and also…
  • What is accpac so busy doing when its idle?

    I have been troubleshooting a performance issue with Sage 300 ERP 2018 (Bulid 0). It is exacerbated when more users are on the system which for us is only about 10 people. If one or two are on then its tolerable. Nothing has really changed in the last…
  • Sage 300 2018 PU4 PJC Performance

    FormerMember
    FormerMember
    Anybody have any idea about the Sage 300 2018 PU4 PJC Performance? Sage300 v6.0 performance is fine but slow after upgraded to v6.5 PU4 (Sage 2018). The PJC UI always become “Not Responding” (But NOT hang). The result will come out 5-10 mins for each…
  • Sage 18.2 Performance

    We recently upgraded to Sage 18.2 and have noticed a significant delay using Sage Desktop. Clicking on an application can take 5-10 seconds to respond and open the menu. Additionally, particularly in AP, clicking on Tasks takes an additional 5-10 seconds…