IT SHOP portal performance

What version of Identity Manager? How much ram is allocated on the SQL server hosting the Identity Manager database? If you open Manager and then go to Help > Info > System Information, does your SQL server meet the recommended values for AVG latency and other options such as RAM?

RAM 256

AVG latency 29ms

Is the SQL server hosting other applications databases? What is the RAM percent for SQL Server? Which of the avg latency is 29MS? You need to look through that System Information report and compare your SQL Server/Database values agianst the recommended values provided. If they are higher than the recommended values then you will need to work with your DBA to see what can be done from the SQL side. What version of Identity Manager what version of SQL are you using?

Version 8

Ram percent 81

Sql server 2014

Avg latency read rows 23,24

Write 29,13ms

Avg letancy log 2,0ms

Definitely worth looking at Cumulative Update Package 17 for SQL Server 2014 SP2 - KB4491540. , As well as tracing top SQL queries issued by the ITShop against the OneIM dB.

So you mean to say everything looks fine?

So we are planning to add 8account type new requests and adding groups to the request and provisioning.

So will it be safe doing this or will face any performance issues if we add this.

And where can we look into this issue excatly?

So you mean to say everything looks fine?

So we are planning to add 8account type new requests and adding groups to the request and provisioning.

So will it be safe doing this or will face any performance issues if we add this.

And where can we look into this issue excatly?

What I was suggesting as best practice is to adopt the latest MSFT CU update for your sql platform, are you on 2014 SP2?

The web page that you say is taking 40seconds to load, have you done a SQL trace to capture the sql statements that the page issues ? Have you engaged your DBAs to take a look? Is the web page you mention a stock page or has it been modified?

Has the Identity Manager Db maintenance task run recently?

Daily we are handling 50 plus requests

100 plus users are hitting portal.

Will it handle sir or will we face an issues?

1. Any suggestions please

For our 8.0.1, there are about 180 ITShop requests being handled daily. The baseline to measure the performance (i.e. request a product and approval step in WP < 10s ~ 15s) we used is first to check if the results of QBMVSystemOverview meet the recommended value of the parameters, secondly check if ITShop structure can improve the performance, last to monitor/tune index fragmentation. HTH