http://sqlserver.ro/forums/50/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/7248.aspxTue, 02 Jun 2009 20:24:59 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7248rremus0http://sqlserver.ro/forums/thread/7248.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=50&PostID=7248OK ca idee generala cind tu sau altcineva da peste o astfel de problema: primul lucru, masori. In SQL 2000 exista <a href="http://msdn.microsoft.com/en-us/library/aa260456%28SQL.80%29.aspx">sysprocesses</a>, in 2K5 exista <a href="http://msdn.microsoft.com/en-us/library/ms177648.aspx">sys.dm_exec_requests</a> . Te uiti si vezi de ce sint blocate query-urile. Te uiti in blocking_session_id, in wait_type si last_wait_type si la wait_resource. In 99% din cazuri te prinzi imediat care-i problema. In celelate 1% din cazuri te putem ajuta, dar trebuie sa ne spui ce anume blocheaza.<br>http://sqlserver.ro/forums/thread/7247.aspxTue, 02 Jun 2009 11:18:27 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7247ssandu0http://sqlserver.ro/forums/thread/7247.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=50&PostID=7247Dupa un backup totul a revenit la normal<br>http://sqlserver.ro/forums/thread/7246.aspxTue, 02 Jun 2009 10:29:50 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7246ssandu0http://sqlserver.ro/forums/thread/7246.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=50&PostID=7246De azi dimineata se intampla ceva foarte ciudat.<br>Toate query-urile dureaza la infinit (ne se mai termina).<br>Daca dau restart la serviciul SQLServer totul revine la normal dar dureaza doar 10 min.<br>Ceva idei ce pot sa verific ?<br>