We did the following to improve the performance.
- Forced the index
- Changed All page locks to Data page locks
- Increased Stored procedure cache.
- Substituted IN keyword on where clause using multiple expression with or clause.
- Created additional indexes.
- Removed * (asterisks) on select statements with required column names.
1 comment:
It is really useful information you have given for Techies like me.
I will promise there will be a lots and lots of visitors in your blog soon. Your transformation of knowledge is opt for IT world.
Men makkal men makkale.Wishing you very very prospersous blog ....
Tuning tips are turning tips for many lives soon....
Post a Comment