Showing results for 
Search instead for 
Did you mean: 

Slow Queries

0 Kudos

Hi i have created new company database in SAP B1as per instruction. But when i execute query with multiple tables i take 3-4 mins in new company created and 7-8 seconds in existing company.

I have rebuild all indexes and constraints in new database,clear cache and temp folders,took database offline and later brought it online,rebuild log file.

Still it takes 3-4 mins for new company only.

I am missing something.
Experts, i need your help.

Please Note : Programs and Both databases are on same server.

Server Config :
Processor : Intel (R) Xeon (R) Silver 4208 CPU @2.10 GHz 2.10 GHz
OS : Windows Server 2016
RAM : 31.5
No. of users : 7-8

Please help.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hello Ganesh,

It's hasty to say what would be causing the poor performance without a previous analysis which will determine where is located the bottleneck, you could start by monitoring the OS and hardware performance then at the database level tracing the query which is being performed and analysing the query plan will give you and good insight of the problem.