----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: VinodK [TLabs, SCT] Message 2 in Discussion Hi , I would just run you through what blocking is ... The links below give you an exhaustive explanation on the same ... Look through these articles ... Blocking occurs when there are resources (index lock, table lock, Update lock) is not released by a connection ... Take for example connection 1 takes lock on Table A and then starts to proceed to Table 2 to take a lock ... But suring the same time if another connection takes a lock on Table 2 and proceeds to take a lock on Table 1 ... But unfortunately the connection 1 has locked table 1 ... hence the connection 2 waits for connection 1 to release the resource and vice-versa ... Hence both wait indefinitely and hence you encounter a typical blocking ... For your questions, >> Is this because of poorly designed database or poorly designed queries/procedures? This is one of the reasons .. But not the only reason ... A design I would also want to include Index stratergy and other normalization features ... Proper Isolation level can also be an attribute ... >> Blocking can be solved by increasing the RAM size? No this cannot be a solutions ... RAM can only increase the caching mechanism ... Hence the throughput ... But not a solution to blocking ofcourse ... Links for blocking Understanding: http://support.microsoft.com/default.aspx?scid=kb;en-us;308737 http://support.microsoft.com/default.aspx?scid=kb;en-us;271509 http://support.microsoft.com/default.aspx?scid=kb;en-us;224453 Also adding to that, See which are the processes that are blocking and the tables in contention ... Then try to put proper indexes on the table ... Try updating all the statistics ... Syntax: Update Statistics <<Tablename>> with full,scan for all the tables dependent ... Thanks, HTH, Vinod Kumar SCT Software Solutions Community Star ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
