What is EndTxn Verb? It takes 50% of the clients time.
- it indicates the end-transaction verb time on the server.that is
the time it takes to close the transaction.the fact that in the trace Data
Verb is high as well points to a problem on the server.
Cache Hit Pct.: 98.25
we'd like to see this figure >99%.
the fact that you are running the server on solaris and the DB is only made
up of 2 physical volumes would seem the place to start with.
you should, if you haven't done so already, move the db volumes to Raw
Logical Volumes and create more volumes as this will improve performance.
Cordiali saluti
Gianluca Mariani
Tivoli TSM Global Response Team, Roma
Via Sciangai 53, Roma
phones : +39(0)659664598
+393351270554 (mobile)
gianluca_mariani AT it.ibm DOT com
----------------------------------------------------------------------------------------------------
The Hitch Hiker's Guide to the Galaxy says of the Sirius Cybernetics
Corporation product that "it is very easy to be blinded to the essential
uselessness of them by the sense of achievement you get from getting them
to work at all. In other words ? and this is the rock solid principle on
which the whole of the Corporation's Galaxy-wide success is founded
-their fundamental design flaws are completely hidden by their
superficial design flaws"...
Miguel Demaerel
<Miguel.Demaere
l AT BRUSSELS DOT SEMA
To
.SLB.COM> ADSM-L AT VM.MARIST DOT EDU
Sent by: "ADSM: cc
Dist Stor
Manager" bcc
<ADSM-L AT VM DOT MARI
ST.EDU> Subject
Performance problem
07/02/2003
10.40
Please respond
to "ADSM: Dist
Stor Manager"
Hoi
Can someone help me with this.
TSM Server 4.2.2.12
Sun Solaris 8 (E450)
BA Client 4.2.1.0
Connect thru Fast ethernet.
Sometimes time the backup takes hours to complete.
Yesterday
Tivoli Storage Manager
Version 4, Release 2, Level 1.0
------------------------------------------------------------------
Final Detailed Instrumentation statistics
Elapsed time: 22013.450 sec
Section Total Time(sec) Average Time(msec) Frequency used
------------------------------------------------------------------
Client Setup 0.459 459.3 1
Process Dirs 784.543 60.3 13020
Solve Tree 0.000 0.0 0
Compute 17.605 0.0 2378504
Transaction 119.315 0.0 7271635
BeginTxn Verb 0.014 0.0 963
File I/O 2150.921 0.9 2499558
Compression 0.000 0.0 0
Encryption 0.000 0.0 0
Delta 0.000 0.0 0
Data Verb 6582.896 2.8 2378504
Confirm Verb 3.148 25.2 125
EndTxn Verb 13139.736 13644.6 963
Client Cleanup 1.345 1345.4 1
------------------------------------------------------------------
Today
Tivoli Storage Manager
Version 4, Release 2, Level 1.0
------------------------------------------------------------------
Final Detailed Instrumentation statistics
Elapsed time: 28370.683 sec
Section Total Time(sec) Average Time(msec) Frequency used
------------------------------------------------------------------
Client Setup 0.310 310.0 1
Process Dirs 805.894 61.9 13021
Solve Tree 0.000 0.0 0
Compute 8.768 0.0 1263556
Transaction 103.700 0.0 3926255
BeginTxn Verb 0.011 0.0 708
File I/O 2565.036 1.9 1384594
Compression 0.000 0.0 0
Encryption 0.000 0.0 0
Delta 0.000 0.0 0
Data Verb 5483.521 4.3 1263556
Confirm Verb 2.878 24.6 117
EndTxn Verb 20212.193 28548.3 708
Client Cleanup 1.080 1079.8 1
------------------------------------------------------------------
What is EndTxn Verb? It takes 50% of the clients time.
tsm: ADSM>q db f=d
Available Space (MB): 18,000
Assigned Capacity (MB): 18,000
Maximum Extension (MB): 0
Maximum Reduction (MB): 9,944
Page Size (bytes): 4,096
Total Usable Pages: 4,608,000
Used Pages: 2,058,256
Pct Util: 44.7
Max. Pct Util: 44.7
Physical Volumes: 2
Buffer Pool Pages: 32,768
Total Buffer Requests: 130,231,713
Cache Hit Pct.: 98.25
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 0.09
Percentage Changed: 0.00
Last Complete Backup Date/Time: 02/07/2003 09:45:03
There is no waiting and the cache hit is ok.
tsm: ADSM>q log f=d
Available Space (MB): 2,072
Assigned Capacity (MB): 2,072
Maximum Extension (MB): 0
Maximum Reduction (MB): 2,068
Page Size (bytes): 4,096
Total Usable Pages: 529,920
Used Pages: 54
Pct Util: 0.0
Max. Pct Util: 10.2
Physical Volumes: 2
Log Pool Pages: 512
Log Pool Pct. Util: 0.62
Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 626,585.08
Consumption Reset Date/Time: 03/06/2002 10:40:02
Even log wait is 0.
Can someone help me with this?
Thanks
/////
(o o)
==============oOO==(_)==OOo==============
Miguel Demaerel
System Engineer
Schlumberger
Raketstraat 98, B-1130 Brussels, Belgium
Tel +32 (0)2 724 93 17
Fax +32 (0)2 724 92 92
Email Miguel.Demaerel AT SLB DOT COM
=========================================
|