After UpgradeSAP B1 10.0 , the server running performance too slow

[SAdmin]

Hi :

Vmware Exsi 6.7

Xeon Gold 6152 2.1GHz (66 CPU) + 300GB Memory

OS: Windows Server 2019 Std

Database:SQL Server 2017 Enterprise

SAP Businesss One 10.00.200 version,

After UpgradeSAP B1 10.0 , the server running performance too slow

Same Hardware configruation with SAP B1 9.3, but the running performace too slow compared with SBO 9.3

Anybody know what's going on ? And how to solve it ? Thank you

[SAdmin · Accepted solution]

Reason which is Mssing sone Index after upgrade Dababase SAP10.0

[SAdmin]

Database server is installled on same server of Business One? YES

SQL SERVER was upgraded? No, still using SQL 2017 Enterprise

The DB statistics were updated after the upgrade? I only using SAP Setup to upgrade Database, this item how to do?

STORED PROCEDURES are recompiled? I don't know how recomplie.

Check also for the DB WAITS to see if the slow is comming from the DB or from the SAP Business One itself...

Seems slow comming DB it self.

[mamartins]

Database server is installled on same server of Business One? If not, pay attention to network configuration of the ESXi host and virtual machine, especially to drop packets.

SQL SERVER was upgraded? If so, did you upgraded the DB compatibility level to match the server version?

The DB statistics were updated after the upgrade? STORED PROCEDURES are recompiled?

Check also for the DB WAITS to see if the slow is comming from the DB or from the SAP Business One itself...