Saturday, December 22, 2007

SQL Performance Tips

When you are writing serious SQL, TSQL or PLSQL one of the common error that you play around is the "Time Out" errors. There are number of reasons for these errors. You have to exactly pin point the problem to properly fix it. I thought of publishing some links that I found on this area which might helpful for you
The areas which you have to look for are :
1) Transaction Locking
2) Performance of your queries (In medium and high data volumes)
3) Transaction isolation levels
4) Clustered index and indexes of your tables
Browse the flowing for in-depth understanding.....

DBA’s Quick Guide to Timeouts
How to troubleshoot ODBC timeout errors

2 comments:

Hasith Yaggahavita said...

machan, don't let your writings die out. We are waiting for new post from you here :). Keep it up.

Cintai Kopiku said...


Inspirasi kopi hitam

Cerita kopi hitam

Gambar kopi hitam