Database Performance Issue RRS feed

  • Question

  • Hi

    I want to achieve 20k concurrent user load Database server but when I do load performance with 5k user database server gives 100% CPU utilization and application server is working fine

    I check process counter in perfmon : user time(sqlserver),process time(sqlserver) is always 100%

    I have 56 GB RAM, INTEL XEON E7 4870 2.4 GHz processor , 64 Bit Windows Server 2008 r2 OS

    So how can I achieve 20k concurrent user load on database server? And Why database server CPU utilization is 100 percent for only 5k concurrent user?

    • Edited by AK9841 Tuesday, August 12, 2014 11:23 AM
    Tuesday, August 12, 2014 11:18 AM