1 Reply Latest reply: Dec 24, 2012 12:28 AM by Pratheej RSS

    Criterion for memory usage for ttcserver

    Pratheej
      Hi,

      Following is the sys.odbc.ini and ttendeamon options of our setup.

      sys.odbc.ini
      ----------------
      DataStore=/Database/DG_011171
      PermSize=16000
      TempSize=800
      LogBufMB=64
      DurableCommits=0
      AutoCreate=0
      OverWrite=0
      LockWait=5
      LogFileSize=64
      Isolation=1
      LockLevel=0
      SMPOptLevel=1
      Connections=1200
      DatabaseCharacterSet=TIMESTEN8
      TypeMode=1
      CkptFrequency=60
      CkptLogVolume=0
      SqlQueryTimeout=180
      Preallocate=0
      PLSQL=1
      MemoryLock=4
      MaxConnsPerServer=100
      ServersPerDSN=12
      DuplicateBindMode=1
      DDLCommitBehavior=0

      ttendaemon.options
      ------------------


      -server 53389
      -showdate
      -serverpool 6



      from the top output we could see that the ttcserver is consuming high physical memory.
      From the follwoing top output, it can be observed that RES column for ttcserver process is high, sometimes we have noticed it crossing 1gb.
      Please let me know what is the criterion for the memory usage for ttcserver... with reference to RES column in the top output.


      Top output
      -----------     


      PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

      24429 root 20 0 18.2g 575m 256m S 0.1 2.5 11:27.15 ttcserver
      11812 root 20 0 19.4g 944m 283m S 0.1 4.0 48:19.06 ttcserver
      12665 root 20 0 19.1g 653m 279m S 0.0 2.8 41:57.51 ttcserver
      12345 root 20 0 19.5g 686m 285m S 0.0 2.9 56:40.31 ttcserver
      24371 root 20 0 18.2g 431m 267m S 0.0 1.8 12:58.14 ttcserver
      5960 root 20 0 18.5g 302m 267m S 0.0 1.3 34:43.17 ttcserver
      24366 root 20 0 18.4g 519m 252m S 0.0 2.2 12:29.71 ttcserver
      24382 root 20 0 18.3g 548m 263m S 0.0 2.3 14:29.40 ttcserver
      24393 root 20 0 18.2g 545m 255m S 0.0 2.3 10:08.29 ttcserver
      24431 root 20 0 18.0g 412m 254m S 0.0 1.8 9:39.42 ttcserver
      12640 root 20 0 19.0g 350m 272m S 0.0 1.5 44:14.63 ttcserver
      24430 root 20 0 18.2g 370m 262m S 0.0 1.6 11:42.95 ttcserver
      3337 root 20 0 407m 924 384 S 0.0 0.0 6:22.39 ttcserver
      24432 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24433 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24434 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24435 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24455 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24456 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24371 root 20 0 18.2g 431m 266m S 0.1 1.8 12:58.65 ttcserver
      24430 root 20 0 18.2g 368m 263m S 0.1 1.6 11:43.44 ttcserver
      24366 root 20 0 18.4g 513m 251m S 0.1 2.2 12:30.19 ttcserver
      12345 root 20 0 19.5g 683m 284m S 0.0 2.9 56:40.74 ttcserver
      12665 root 20 0 19.1g 648m 278m S 0.0 2.8 41:57.92 ttcserver
      11812 root 20 0 19.4g 943m 282m S 0.0 4.0 48:19.46 ttcserver
      5960 root 20 0 18.5g 300m 266m S 0.0 1.3 34:43.54 ttcserver
      24431 root 20 0 18.0g 411m 253m S 0.0 1.8 9:39.75 ttcserver
      24393 root 20 0 18.2g 544m 254m S 0.0 2.3 10:08.56 ttcserver
      24429 root 20 0 18.2g 573m 254m S 0.0 2.5 11:27.39 ttcserver
      12640 root 20 0 19.0g 349m 272m S 0.0 1.5 44:14.80 ttcserver
      24382 root 20 0 18.3g 547m 262m S 0.0 2.3 14:29.56 ttcserver
      3337 root 20 0 407m 688 148 S 0.0 0.0 6:22.48 ttcserver
      24432 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24433 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24434 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24435 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24455 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver
      24456 root 20 0 70200 8 4 S 0.0 0.0 0:00.00 ttcserver

      Regards
      Pratheej