August 31, 2010 at 3:00 am
Hi
Hi
This is Jayapal reddy
i was read u r ans for blocking.it is good to understood about blocking
i need a small help.
am new to server 2005
plz give me wat is the processes to avoid blocking in realtime senarios
plz help me
Regards,
Jayapal
August 31, 2010 at 3:06 am
Hi,
I think a bit more information is required before we can help.
What sort of locks are you getting on your databases?
August 31, 2010 at 5:37 am
hi
thnx for u r reply
I dont know about that
could plz tell me how to resolve the blockings in real time senarios ,if u know
regards
Jayapal
August 31, 2010 at 6:17 am
Blocking by itself is not a problem. It's expected as part of a database system. Excessive (long-duration) blocking usually indicates poorly written queries or poor indexing. Look at optimising your queries or get someone in to do it for you.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply