Managed File Transfer

Sterling Managed File Transfer

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  SFG Performance Tuning Advise Required

    Posted Tue March 09, 2021 03:51 PM
    Hi all,

    A customer performed a load test on myFileGateway by simulating 110 concurrent users that will login, upload file (50KB) and logout. Please see table below. The server was sized to handled 274 concurrency with a throughput of 2.5MB/s and was load tested successfully. (I have request a Techline sizing based on SFTP 274 concurrency and HTTPS 110 concurrency, and the hardware recommendation is the same). I have shared all the tuning guide with the BP and they have implemented all of them.

    The customer setup is 2-2-2 (PRD) 2-2-2 (HA) and SQL Server.

    Please advise:
    a) If a 3s page load time is achievable.
    b) What further tuning is possible?
    c) BP identify some long running SQL. Please see attached SQL files and logs.


    Thank you.

    ------------------------------
    TIONG GHEE TAN
    ------------------------------

    #DataExchange
    #IBMSterlingB2BIntegratorandIBMSterlingFileGatewayDevelopers

    Attachment(s)

    txt
    SQL Checking.txt   2 KB 1 version
    xlsx
    result sql checking.xlsx   87 KB 1 version


  • 2.  RE: SFG Performance Tuning Advise Required

    Posted Wed March 10, 2021 01:52 AM
    This is helpful. Thank you.

    ------------------------------
    Pranjit Biswas
    ------------------------------

    Original Message