avoid Blocking?

[parsql]

hi all,

I just wonat to find out that how can i avoid having block on system?

I tried alert but would like to avoid better way and also want to reduce the blocking on the DB at least?

suggestion please..

thanks

 

[mrdenny]

Alerting won't stop your blocking, it will simply tell you that you are having the problem.

Blocking is caused by to many users trying to access the same record or page at the same time. This is a normal database function in order to keep the database clean and safe.

Blocking however can be reduced by the proper use of indexes and using the correct isolation level (or the nolock index hint). If you aren't up on indexes you may want to check out the index advisor in Query Analyzer (or SQL Server Managment Studio if SQL 2005).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com