• State Suggested Answer
  • Locked Locked
  • Replies 11 replies
  • Answers 1 answer
  • Subscribers 94 subscribers
  • Views 3916 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

IT SHOP portal performance

hemasaiy534
over 4 years ago

Hello All,

Could any one of you give suggestions or inputs on the below.

So currently the IT shop web portal is taking 40seconds to load the page intially and if do any actions.

And we are planing to add few request process workflow calculation ....etc.

Will it impact more and how can we decress the loading time to the web page.

Parents
  • 0 over 4 years ago

    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?

  • 0 over 4 years ago in reply to Troy Grandy

    RAM 256

    AVG latency 29ms

  • 0 over 4 years ago in reply to hemasaiy534

    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?

  • 0 over 4 years ago in reply to Troy Grandy

    Version 8

    Ram percent 81

    Sql server 2014

    Avg latency read rows 23,24

    Write 29,13ms

    Avg letancy log 2,0ms

  • 0 over 4 years ago in reply to hemasaiy534

    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.

  • 0 over 4 years ago in reply to hemasaiy534

    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?

  • 0 over 4 years ago in reply to hemasaiy534

    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?

  • 0 over 4 years ago in reply to Paul Walker

    Daily we are handling 50 plus requests

    100 plus users are hitting portal.

    Will it handle sir or will we face an issues?

  • 0 over 4 years ago in reply to hemasaiy534

    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

Reply
  • 0 over 4 years ago in reply to hemasaiy534

    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

Children
No Data