Sage 300 (Accpac) SQL Server Performance and Batch-Posting Diagnostic Pack
For on-premises or IaaS Sage 300 (Accpac) where you have direct SQL Server access, this pack isolates the Sage-specific causes of slow GL posting, Day-End Processing, and period-end that generic SQL scripts miss. When Sage 300 drags, the cause is usually the GLBCTL batch control table getting scanned on every open-batch lookup when its batch-status index is missing, batches stuck in an Open or Post-In-Progress state, the GLPOST posting journal growing unbounded until Clear Posting Journals is run, the GLAFS fiscal-set balance rollup updated under lock during posting, ICILOC item-location on-hand rows (including zero-quantity orphans) behind slow inventory Day-End, or over-keyed indexes on the AR/AP open-document and Order Entry detail tables. This pack gives Sage 300 DBAs five ready-to-run SSMS scripts that use built-in SQL Server DMVs and understand Sage 300's real table names and its one-database-per-company layout, pre-targeted at the objects that most often cause Sage 300 slowdowns, so you can diagnose the bottleneck without third-party tools, schema changes, or any data modification. It applies to self-hosted Sage 300 and Sage 300cloud, which are the same SQL Server database; it does not apply to Sage Intacct or Sage X3, which are different products. Read-only by design: it reports the problem objects, it never changes them.
Get it → bearndeals.gumroad.com