SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    Senior Member
    Join Date
    Nov 2007
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Analysis of Performance results.

    Hi Friends,

    Here is the scenario: I was given a XYZ web-application to load/performace test.

    --> To come up with result/report giving them Concurrent/simultaneous number of users that current system configuration will support.

    --> The only feature I had to consider was “Registration of a new user” and also the time limit was set, lets say: Registration should be done within ‘S’ seconds.

    I did the test came up with a result and informed them: This current configuration will allow ‘Val’ number of concurrent users to register simultaneously and that too within the time constraint i.e. ‘S’

    Note: Here I did not find any “Hardware” related saturation.

    I had done this Load test with single test machine with OpenSTA installed on it.

    Then I was given a new configuration, IBM HS 22 Blade server which was 10 times better than the previous one, I repeated the Load test process, and again got the same result.

    Okay,so I do understand that the point of bottleneck is in the application… but telling them just that much, won’t be enough. Please if you can suggest from your experience what all problem there can be from application’s side that would effect the performance. Application is in ASP.NET, with database on SQL Server.

    I tried to make the value of “Worker process” for application to the number of CPUs(I think it ran than number of instances of Application to serve parallel users), but then the application when ran manually did not perform correctly, It logged me off every time I refresh the page. May be instances were many but session created at server was one. Not sure of the other settings required to make. Also if a DBA can tell me the settings needed to be done for SQL Server database’s improved performance.


    Thanks in advance,
    -Mash

  2. #2
    Senior Member
    Join Date
    May 2005
    Location
    England
    Posts
    120
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Analysis of Performance results.

    [ QUOTE ]

    Note: Here I did not find any “Hardware” related saturation.


    [/ QUOTE ]
    There's the issue. If you don't have any hardware bottlenecks then the issue is probably locks or queues of some sort. This could be caused by indices on the wrong fields in the database, too few channels between tiers, too few workers processing queues.

    Go through perfmon and live-monitor every relevant counter with a lock or a queue in its name. Also look for any graphs which show a plateau, but keep in mind that correlation does not imply causation.

    [ QUOTE ]
    Also if a DBA can tell me the settings needed to be done for SQL Server database’s improved performance.

    [/ QUOTE ]
    In my experience it's usually not a matter of database server settings, but database design.

    You can look at all kinds of database stats in perfmon, and use Microsoft's SQL trace tool to find out which queries are running the slowest and causing the most reads (during a manual test), but it's best if you're actually sat with a DBA or ideally the developer who wrote the thing, who can interpret the figures and make the necessary changes. It could be something as simple as an index on the wrong thing or as complex as an exercise in normalization.
    04h

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 09:45 PM.

Copyright BetaSoft Inc.