http://sqlserver.ro/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8007.aspxFri, 22 Jan 2010 10:20:26 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8007neo0http://sqlserver.ro/forums/thread/8007.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8007Multumesc mult.http://sqlserver.ro/forums/thread/8006.aspxFri, 22 Jan 2010 07:13:16 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8006Diana0http://sqlserver.ro/forums/thread/8006.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8006Vezi si <br />http://sqlserver.ro/forums/1/6479/ShowThread.aspxhttp://sqlserver.ro/forums/thread/8005.aspxFri, 22 Jan 2010 06:27:27 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8005neo0http://sqlserver.ro/forums/thread/8005.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8005Multumesc mult.http://sqlserver.ro/forums/thread/8003.aspxFri, 22 Jan 2010 00:08:28 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8003xmldeveloper0http://sqlserver.ro/forums/thread/8003.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=8003Ideal ar fi monitorizarea din timp - in cazul insa in care nu a trecut timp (depinde si de activitatea serverului) puteti incerca urmartoarea interogare:<br><table cellpadding="0" cellspacing="0"><tr style="vertical-align:top;line-height:normal;"><td style="width:40px;text-align:right;"><pre style="margin:0px;padding:2px;font-family:courier new;font-size:11px;color:gray;">1<br>2<br>3<br>4<br>5<br> </pre></td><td><pre style="margin:0px;padding:2px 2px 2px 8px;"><span style="color:Black;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;"><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">SELECT</span><br>*<br><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">FROM</span> sys.dm_os_ring_buffers<br><span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">WHERE</span> ring_buffer_type = <span style="color:Red;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">'RING_BUFFER_EXCEPTION'</span><br><span style="color:Silver;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">AND</span> <span style="color:Fuchsia;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">CAST</span>(record <span style="color:Blue;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">AS</span> XML).value(<span style="color:Red;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">'(/Record/Exception/Error)[1]'</span>,<span style="color:Red;background-color:Transparent;font-family:Courier New;font-size:11px;font-weight:normal;">'int'</span>) = 1205</span></pre></td></tr></table><br>Daca va intoarce rezultate sigur au avut loc deadlocks. Lipsa rezultatelor nu garanteaza ca nu s-au produs evenimente tip deadlock (rezultatele provin dintr-un ring-buffer de 64K).<br><br>Pe viitor va recomand sa utilizati urmatorul articol: <br><h4 class="BlogPostHeader"><a href="http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/05/617960.aspx">Troubleshooting deadlocks in SQL2005</a></h4>http://sqlserver.ro/forums/thread/7986.aspxTue, 19 Jan 2010 13:04:00 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7986neo0http://sqlserver.ro/forums/thread/7986.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=15&PostID=7986<P>salut,</P> <P>&nbsp;</P> <P>ppe o baza de date sql st ed. 2005 sp1&nbsp; SIMPLE RECOVERY&nbsp; poate fi facuta o analiza pentru a vedea daca la un anumit moment am avut un anumit incident de tip deadlock sau similar?</P> <P>&nbsp;</P> <P>multumesc.</P>