SAP b1 utilization going high.

[shree29]

On SAP b1 server 55 user connected on shingle data base. & SAP b1 utilization going high.

per user utilization above 3 GB

please suggest how to decrease memory utilization

we are using SAP 9.2 PL9

SQL R2 2008

8 core CPU

32 GB RAM

[Johan_H]

Hi Rahul,

Please also tell us the size of the database.

Regards,

Johan

[kaus19d]

Hi shree29,

Could you help us with some application logs. For Windows Server, please check via Task Manager, which application is consuming the top memories... Also from SQL Server login, you can find the Top 50 SQL Queries consuming most of the memory. You can try the query mentioned in the below, for example,

https://www.red-gate.com/simple-talk/blogs/how-to-find-cpu-intensive-queries/

Thanks,

Kaushik