Forum Discussion

soundhar's avatar
soundhar
New Contributor
17 years ago

How to monitor the web server, app server and DB server performance ?

Hi,



I am conducting load and performance testing for a web application using Testcomplete HTTP load test project. In test compelete how can I monitor the performance of web, app and DB servers? what is the procedure? After completion of the test how can I export the results with graphs to word or excel sheet? currently I can able to export the results in xml format or directly to IE.



Please provide solution for the above.



Thanks



soundhar

5 Replies

  • AlexanderM's avatar
    AlexanderM
    Icon for Staff rankStaff
    17 years ago
    Hello soundhar,




    >>> In test compelete how can I monitor the performance of web, app and DB servers?

    No, currently TestComplete cannot do this. We have a suggestion to make it possible to do that, and your request has increased its rating, thank you.




    At the moment, you can use the PerfMon tool to collect performance information on the server PC:





    >>> After completion of the test how can I export the results with graphs to word or excel sheet?

    You can export results to XML or HTML files only.




  • johny2010_1's avatar
    johny2010_1
    Contributor
    15 years ago
    Hi Alex, beside the performance monitor, there are also other drawbacks of the feature of the program.



    some really important information is not shown in the log pages and I do not know why didnt developers addeed these



    For example, for a test



    request number for a second ?

    Total request for a specific user ?

    yes default log page gives total request for a test but not for a user.





    What is the reason  that the columns in the log pages does not offer a total for the numbers in the columns ?
  • AlexanderM's avatar
    AlexanderM
    Icon for Staff rankStaff
    15 years ago

    Hello Johny,





    We have improved the Load Testing functionality in the recent TestComplete 8.10 release. Now you can see a number of runtime counters during your Load Test execution. Please check the new functionality and let me know what you think.





    You can read about this functionality in the Runtime Graphs Page (LoadTesting Project Item Editor) help topic.





    What is the reason  that the columns in the log pages does not offer a total for the numbers in the columns ?


    You can configure the needed summary values - check the Viewing Summary Values help topic for details.
  • johny2010_1's avatar
    johny2010_1
    Contributor
    15 years ago
    Hi Alex,

    Sory you are right, actually summary option was given in the columns, that is great! I dont have to copy and paste all pages to excel.



    And for the Runtime Graphs,yes I should know it also includes request number.

    That functionality is great I think,



    Just a point I need to be clear about.

    For the Description of the Passed Request Count in Run Time Graph help pages it says that



    The number of requests that have passed since the last call.



    What last call means here ? and how can I get number of requests for a second from this value ?



    Thanks a lot!
  • AlexanderM's avatar
    AlexanderM
    Icon for Staff rankStaff
    15 years ago

    Hello Johny,





    What last call means here ? and how can I get number of requests for a second from this value ?


    This parameter shows the number of requests that were sent to the tested server since the last measurement of this parameter.

    Since the measurements are done every second, this is actually the number of requests sent per second.





    We will improve the help topic to make the description more clear.