Training Material on Performance tuning
- shanthi
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 128
- Thank you received: 10
13 years 1 month ago #6456
by shanthi
Training Material on Performance tuning was created by shanthi
Dear All,
I am in midst of preparing Training Material that can help on Tuning T24 for Performance.
I have handful of Topics to cover and interested in more.
Please share your thoughts to help me compile a comprehensive material and in return you can have a copy of the material once completed.
Kind Regards,
Shanthi - (This email address is being protected from spambots. You need JavaScript enabled to view it.)
I am in midst of preparing Training Material that can help on Tuning T24 for Performance.
I have handful of Topics to cover and interested in more.
Please share your thoughts to help me compile a comprehensive material and in return you can have a copy of the material once completed.
Kind Regards,
Shanthi - (This email address is being protected from spambots. You need JavaScript enabled to view it.)
Please Log in or Create an account to join the conversation.
- chipom
- Offline
- Junior Member
-
Less
More
- Posts: 26
- Thank you received: 0
13 years 1 month ago #6461
by chipom
Replied by chipom on topic Re: Training Material on Performance tuning
Please sent me a copy once you are done. I dont know much about performace tuning on T24, still on Globus G13 but will be upgrading to T24 soon.
My email address is This email address is being protected from spambots. You need JavaScript enabled to view it.
Regards
chipom
My email address is This email address is being protected from spambots. You need JavaScript enabled to view it.
Regards
chipom
Please Log in or Create an account to join the conversation.
- sri
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 3
13 years 1 month ago #6463
by sri
Replied by sri on topic Re: Training Material on Performance tuning
Dear ,
Generally Triggers are maintained at database level for notifications to update external interface , which affects the Performance of the database.
I suggest, We need to remove Triggers at the database level and make use of the facility of the subroutines which can be attached to ACCOUNT.PARAMETER > SYSTEM. This routine is triggerred within the Transaction Bounday of any entry generated either Consol or Statement. So necessary update can be done at this level instead of maintaing triggers at Application levels like STMT.ENTRY which are sensitive in nature.
Regards,
Generally Triggers are maintained at database level for notifications to update external interface , which affects the Performance of the database.
I suggest, We need to remove Triggers at the database level and make use of the facility of the subroutines which can be attached to ACCOUNT.PARAMETER > SYSTEM. This routine is triggerred within the Transaction Bounday of any entry generated either Consol or Statement. So necessary update can be done at this level instead of maintaing triggers at Application levels like STMT.ENTRY which are sensitive in nature.
Regards,
Please Log in or Create an account to join the conversation.
- adeleke
- Offline
- New Member
-
Less
More
- Posts: 16
- Thank you received: 1
12 years 11 months ago #7347
by adeleke
Replied by adeleke on topic Re: Training Material on Performance tuning
Hi,
As a member of this contributive forum, kindly assist me by sending a copy to me when you are done with the Performance document you are preparing.
Please help me send it to this email address This email address is being protected from spambots. You need JavaScript enabled to view it..
Thank you.
Rgds
adeleke
As a member of this contributive forum, kindly assist me by sending a copy to me when you are done with the Performance document you are preparing.
Please help me send it to this email address This email address is being protected from spambots. You need JavaScript enabled to view it..
Thank you.
Rgds
adeleke
Please Log in or Create an account to join the conversation.
- AMMAR.FAIDI
- Offline
- Elite Member
-
Less
More
- Posts: 266
- Thank you received: 13
12 years 11 months ago - 12 years 11 months ago #7350
by AMMAR.FAIDI
Replied by AMMAR.FAIDI on topic Re: Training Material on Performance tuning
do you mean by tunning here communication wise or DB level and which DB
Last edit: 12 years 11 months ago by AMMAR.FAIDI.
Please Log in or Create an account to join the conversation.
- adeleke
- Offline
- New Member
-
Less
More
- Posts: 16
- Thank you received: 1
12 years 11 months ago #7354
by adeleke
Replied by adeleke on topic Re: Training Material on Performance tuning
Hi,
I mean Database-wise and i am on R10 Linux.
And do i need to be clearing any files each day before starting the jboss agent?
Thank you for your response.
kind regards Always,
adeleke
I mean Database-wise and i am on R10 Linux.
And do i need to be clearing any files each day before starting the jboss agent?
Thank you for your response.
kind regards Always,
adeleke
Please Log in or Create an account to join the conversation.
- AMMAR.FAIDI
- Offline
- Elite Member
-
Less
More
- Posts: 266
- Thank you received: 13
12 years 11 months ago #7356
by AMMAR.FAIDI
Replied by AMMAR.FAIDI on topic Re: Training Material on Performance tuning
hi
there is no need to clean the files and stop the jboss specially if you use the NS module , but you can maintain the DB by monitering the size of the files , run archive to minimize the files size in addition to that try to unlock the hang processes from the DB level
B.R
there is no need to clean the files and stop the jboss specially if you use the NS module , but you can maintain the DB by monitering the size of the files , run archive to minimize the files size in addition to that try to unlock the hang processes from the DB level
B.R
Please Log in or Create an account to join the conversation.
- srajput
- Offline
- New Member
-
Less
More
- Posts: 15
- Thank you received: 1
12 years 11 months ago #7439
by srajput
Replied by srajput on topic Re: Training Material on Performance tuning
Hi Shanti,
I believe that you have completed the document. you can send it to me may be I can add something in it as I have lots of experience in Performance Tunning.
Thanks
I believe that you have completed the document. you can send it to me may be I can add something in it as I have lots of experience in Performance Tunning.
Thanks
Please Log in or Create an account to join the conversation.
- phaysalshaikh
-
- Offline
- Senior Member
-
Less
More
- Posts: 45
- Thank you received: 0
12 years 11 months ago #7618
by phaysalshaikh
Replied by phaysalshaikh on topic Re: Training Material on Performance tuning
include the procedure to stop those sessions which are causing the system to work slow, for suppose there is an application called CHECK.ISSUE which is causing the system to work slow, now is there any process that can be used to kill all sessions at once with one command, or temporarily make un-available that application or LOCK, that application for a while.
kindly send me a copy of performance tuning also : This email address is being protected from spambots. You need JavaScript enabled to view it.
kindly send me a copy of performance tuning also : This email address is being protected from spambots. You need JavaScript enabled to view it.
Please Log in or Create an account to join the conversation.
- eddyblf
- Offline
- New Member
-
Less
More
- Posts: 3
- Thank you received: 0
12 years 9 months ago #7975
by eddyblf
Replied by eddyblf on topic Re: Training Material on Performance tuning
Dear Shanti,
Could you please send me also these documents : This email address is being protected from spambots. You need JavaScript enabled to view it.
Many Thanks
Could you please send me also these documents : This email address is being protected from spambots. You need JavaScript enabled to view it.
Many Thanks
Please Log in or Create an account to join the conversation.
- Pranav
- Offline
- Junior Member
-
Less
More
- Posts: 31
- Thank you received: 1
12 years 9 months ago #7980
by Pranav
Replied by Pranav on topic Re: Training Material on Performance tuning
Dear Shanti,
Greate Job,If you are preparing document for performance tuning, I think it should cover,
1. How to monitor increased file size, so that user can re-size on time.
2. How to minimize COB time.
3. Archival procedure for rapidly grow files.
4. Making Distributed File system for large file.
5. Procedure to Identify Corrupted Files and repair.
Pranav
Greate Job,If you are preparing document for performance tuning, I think it should cover,
1. How to monitor increased file size, so that user can re-size on time.
2. How to minimize COB time.
3. Archival procedure for rapidly grow files.
4. Making Distributed File system for large file.
5. Procedure to Identify Corrupted Files and repair.
Pranav
Please Log in or Create an account to join the conversation.
- emchch0040
- Offline
- Senior Member
-
Less
More
- Posts: 43
- Thank you received: 0
12 years 9 months ago #8153
by emchch0040
Replied by emchch0040 on topic Re: Training Material on Performance tuning
please if you see any material on performance tuning please send to my email @ This email address is being protected from spambots. You need JavaScript enabled to view it.
Please Log in or Create an account to join the conversation.
- udayangi01
- Offline
- Senior Member
-
Less
More
- Posts: 70
- Thank you received: 1
12 years 9 months ago #8162
by udayangi01
Replied by udayangi01 on topic Re: Training Material on Performance tuning
Hello Shanti,
If you have not added;
1) Use indexes to improve selection and search
2) Dos and Don'ts while writing subroutines
3) Resizing of work files used during COB
can also help improve performance.
If you have not added;
1) Use indexes to improve selection and search
2) Dos and Don'ts while writing subroutines
3) Resizing of work files used during COB
can also help improve performance.
Please Log in or Create an account to join the conversation.
- wam
- Offline
- Senior Member
-
Less
More
- Posts: 55
- Thank you received: 3
12 years 9 months ago #8170
by wam
Replied by wam on topic Re: Training Material on Performance tuning
Dear Shanti,
Could you please send me also these documents : This email address is being protected from spambots. You need JavaScript enabled to view it.
By the way we are in the process to fine tune our COB time by
1) Try to exclude reporting from T-24 and make them available offline
2) Fine tune the code
3) Build indexes in order to make selection criteria fast
4) improve hardware infrastructure
Could you please send me also these documents : This email address is being protected from spambots. You need JavaScript enabled to view it.
By the way we are in the process to fine tune our COB time by
1) Try to exclude reporting from T-24 and make them available offline
2) Fine tune the code
3) Build indexes in order to make selection criteria fast
4) improve hardware infrastructure
Please Log in or Create an account to join the conversation.
- Daryl.to.u
- Offline
- New Member
-
Less
More
- Posts: 18
- Thank you received: 0
12 years 9 months ago #8176
by Daryl.to.u
Replied by Daryl.to.u on topic Re: Training Material on Performance tuning
Hi,
Thats a great job.,
It will be good if u include the procedure to archive the files,.
and pls post the document here,..
Thanks in advance,.
Thats a great job.,
It will be good if u include the procedure to archive the files,.
and pls post the document here,..
Thanks in advance,.
Please Log in or Create an account to join the conversation.
- Anantayp
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
12 years 9 months ago #8279
by Anantayp
Replied by Anantayp on topic Re: Training Material on Performance tuning
please give the last copy you're done, at This email address is being protected from spambots. You need JavaScript enabled to view it.
thanks & Regards
thanks & Regards
Please Log in or Create an account to join the conversation.
- srajput
- Offline
- New Member
-
Less
More
- Posts: 15
- Thank you received: 1
12 years 9 months ago #8297
by srajput
Replied by srajput on topic Re: Training Material on Performance tuning
Hi Shanthi,
Can you please send me performance doc on This email address is being protected from spambots. You need JavaScript enabled to view it.
Can you please send me performance doc on This email address is being protected from spambots. You need JavaScript enabled to view it.
Please Log in or Create an account to join the conversation.
- wam
- Offline
- Senior Member
-
Less
More
- Posts: 55
- Thank you received: 3
12 years 8 months ago #8342
by wam
Replied by wam on topic Re: Training Material on Performance tuning
Please give the last copy you're done at This email address is being protected from spambots. You need JavaScript enabled to view it.
Thanks
Thanks
Please Log in or Create an account to join the conversation.
- kripesh
-
- Offline
- Platinum Member
-
Less
More
- Posts: 451
- Thank you received: 63
12 years 8 months ago #8569
by kripesh
Have a great day !
Replied by kripesh on topic Re: Training Material on Performance tuning
Hi Shanthi,
Were you able to complete the performance tuining Guide ? It would be nice if you could
share it for the benefit of other.
Please send to This email address is being protected from spambots. You need JavaScript enabled to view it.
Many thanks
K
Were you able to complete the performance tuining Guide ? It would be nice if you could
share it for the benefit of other.
Please send to This email address is being protected from spambots. You need JavaScript enabled to view it.
Many thanks
K
Have a great day !
Please Log in or Create an account to join the conversation.
- vijitizer
- Offline
- Junior Member
-
Less
More
- Posts: 31
- Thank you received: 3
12 years 8 months ago #8570
by vijitizer
Replied by vijitizer on topic Re: Training Material on Performance tuning
Hello Shanthi
Myself new to t24 if u could share that with me it will be very much helpful.
*Have to upgrade the classic navigation so that the work process can be faster....
by adding undo or other some tuning..
*COB wise logging should be upgrade......
This email address is being protected from spambots. You need JavaScript enabled to view it.
Myself new to t24 if u could share that with me it will be very much helpful.
*Have to upgrade the classic navigation so that the work process can be faster....
by adding undo or other some tuning..
*COB wise logging should be upgrade......
This email address is being protected from spambots. You need JavaScript enabled to view it.
Please Log in or Create an account to join the conversation.
Time to create page: 0.176 seconds