InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 22:58:34 GMT20http://www.sqlservercentral.com/Forums/Topic1393356-146-1.aspxIf the process is coming from another server, such as a LinkedServer query it can be trickier to figure out.Fri, 07 Dec 2012 07:00:17 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic1393356-146-1.aspx[url]http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/[/url] Chapter 6.Fri, 07 Dec 2012 02:46:17 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1393356-146-1.aspxThe blocking occur intermittent i have also set sp_configure 'blocked process threshold', 10. .and when the blocking happened , i try to select other rows in the config table , it return the result . But when i try to select the row which condition where Getdate() > eff_start_dt and sys_key= 'LAST_USED_LOG_ID' , it will keep loading because these particular key was blocked by the update statement . But what have cause the blocked for these update statement ? I can see exclusive lock . but there are no other insert or update to the config table except the only one which blocked .Fri, 07 Dec 2012 02:40:48 GMTstanley_1982http://www.sqlservercentral.com/Forums/Topic1393356-146-1.aspxUnfortunately , the blocking happened again . and blocked process report capture nothing . I run the SOL SEVER report- activity -all blocking transaction during the blocking to show the blocking transaction . blocking statement key 59 --key 51 update M_SYSTEM_CONFIG set sys_value = sys_value +1 where Getdate() > eff_start_dt and sys_key= 'LAST_USED_LOG_ID'what kind of blocking is not able to trace by the profiler ? and why sql server showing -- in the blocking statement ?Fri, 07 Dec 2012 02:29:41 GMTstanley_1982http://www.sqlservercentral.com/Forums/Topic1393356-146-1.aspxSetup a server side trace to identity what is causing the blocking. There are groups available for blocking in SQLserver. Hope this helps you to identify the blocking. -- Babu Fri, 07 Dec 2012 01:52:26 GMTbaabhuhttp://www.sqlservercentral.com/Forums/Topic1393356-146-1.aspxI found a blocking issues using the DMV . [url=http://postimage.org/image/4eibr8uvn/][/url]from the captured result . I use DBCC IND('DBNAME', 'M_SYSTEM_CONFIG',-1), but i did not see the page number 1:1009316I use dbcc PAGE (DBNAME, 1 , 1009316 ,3) WITH TABLERESULTS , it show me that the page Metadata: IndexId 1 and Metadata: ObjectId 645577338 . number 645577338 is the object id for table m_system_config . DBCC CHEDKDB show zero consistency error .Is these normal to the database ? can someone explain how should i proceed to troubleshoot this blocking ? the only 2 statament that involve in table M_SYSTEM_CONFIG while blocking is update and select from a different rows . only 17 rows is in the table . i do not know select will trigger an exclusive lock . Thu, 06 Dec 2012 00:44:11 GMTstanley_1982