ASE 12,5,0,1 on Sun Solaris 8 very high Transaction...

Question by DEBO
Submitted on 11/7/2003
Related FAQ: N/A
Rating: Not yet rated	Rate this question:
ASE 12,5,0,1 on Sun Solaris 8 very high Transaction intensive and we use dedicated caches binded to some tables where some tables fits into their dedicated cache. Recently, many Users Databases Tables have been upgraded; the DBA has proceed with an sp_rename 'actual table' into 'actual_table_OLD', recreate 'actual table', copy data's from 'OLD' and so on for each affected table. When completed, he has drop and recreate all the triggers, view's and procedures. After, we have observe a degradation of performance for some transactions without pinpointing any cause. Finally, we have discover two tables in 'OLD' into the original dedicated cache. Whe have unbind the two tables in 'OLD' from their cache and redo the bind to the correct object ID. For the same price, we have decide to recycle all ASE, doing a shutdown and restart. After this, the bad performance has disappear. My question is.... Why ?

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to general questions

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: