.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Analyze Deadlock Graph

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server



I have captured a deadlock graph and would like to analyze the same. Could you please help me with some resources to find more information about analyzing deadlock (XML Format) graph.



 <deadlock victim="processd556a8">
   <process id="processa1b6a8" taskpriority="0" logused="84" waitresource="RID: 14:1:2241:6" waittime="2484" ownerId="261390849" transactionname="UPDATE" lasttranstarted="2010-10-18T09:36:09.070" XDES="0x61f426e0" lockMode="U" schedulerid="1" kpid="3704" status="suspended" spid="167" sbid="0" ecid="0" priority="0" transcount="2" lastbatchstarted="2010-10-18T09:36:09.070" lastbatchcompleted="2010-10-18T09:36:09.070" hostname="XX.XX.XX.XXXX" hostpid="0" loginname="xxxadmin" isolationlevel="read committed (2)" xactid="261390849" currentdb="14" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">

View Complete Post

More Related Resource Links

SQL Server 2005 Profiler Deadlock Graph


The Deadlock graph displays process nodes, but doesn't show resource nodes (and of course no edges).  How do I fix this?


Isolation Level set to Read Committed Snapshot, Deadlock Graph shows Read Committed


I must misunderstand something here. I have altered the DB to allow READ_COMMITTED_SNAPSHOT and some deadlock situations have been solved. Nevertheless, in a very similar situation, I'm getting deadlocks and the deadlock graph (XML) shows me the following:

isolationlevel="read committed (2)"

What do I miss here?



using reflection to emit properties to the top of the entity graph


I've got a class

  public class Criminal

public HouseholdMember[] LiedAboutFSHousehold { get; set; }

      public HouseholdMember[] FoodstampTrafficingHousehold { get; set; }
HouseholdMember inherits Person, as do many other classes.  

  public class HouseholdMember: Person


What I&#

Crash Course: Analyze Crashes to Find Security Vulnerabilities in Your Apps


Here the authors analyze program crashes to help you understand if you have the potential for read or write violations in your applications, and how they can lead to security vulnerabilities.

A. Abouchaev, D. Hasse, S. Lambert, and G. Wroblewski

MSDN Magazine November 2007

.NET Matters: Deadlock monitor


This month Stephen Toub discusses deadlocks that can occur when synchronizing threads.

Stephen Toub

MSDN Magazine October 2007

Toolbox: Analyze HTTP Traffic, Synchronize Databases, and More


Debugging Web applications can be a difficult process due to the logical, physical, and temporal differences between the mishmash of technologies that comprise such an application. For bugs that arise from the HTML and script received by the browser or in the transfer or request of a page's markup, developers often adopt archaic debugging techniques, such as using View Source and Notepad to scrutinize the contents received by the browser.

Scott Mitchell

MSDN Magazine April 2006

Giving Custom Colors for Graph values in SSRS2000


Hi All,

        I am stuck here with the color for the graph values i want to give custom colors for each values present in the graph, is it possible in SSRS2000.

 Problem Statement : Suppose if i want to display two data fields as bar graph

                                 Data Fields are : Vegetable Count and Fruits Count

                                          I want Vegetable count to be in Blue Colour and I want Fruits count to be in green colour.

Any help would be appreciated.

Thanks in advance.

Anish Shenoy

SSRS 2008 Graph Type?


Greetings -


I am required to plot the following graph in an SSRS report.


Sum of Total Credits to be shown on Positive side and total sum of Debits for a month on negative side. I have created a query which retrieves all the expenses for the month and sums them up before feeding the same to the graph for plotting. Both values returned are positive integers.


(Sorry for the diagram below, i tried to paste an image but it didn't work)

Can You Analyze the History of a Database? I Think Not

Is it possible or is there some "undocumented" means by which I can determine the history of a database, specifically with regards to each time the database was accessed (by any user or application)? The only thing I have to work with is the database itself. The database is given to me in a BAK format. I then "restore" the backup to my instance of SQL Server. So the only data I have is that which is included in the database itself. I do not have access to the host server that created the BAK, which means I do not have access to any of the system databases (master, msdb, etc.) or system logs on the host server. So having only a restored copy of the database, is there any way I can extract the history of activity out of the database, such as each time it was accessed by some user, oledb provider, odbc connector, etc? BTW, the developer of the database did not create any user-defined tables that track database activity. ThanksJohn

Error in Replication: connection was chosen as the victim in a deadlock

I'm using a merge replication with SQL 2008 at server and SQL Express 2008 on subscribers. We are using around 100 subscribers. I'm getting the following error once two subscribers replicate at the same time. The final number of transaction uploaded to the server is always arong 100 and a similar number in the downloads, so the amount of transaction is not an issue. I'he been playing with the merge profile with no luck. The merge process could not replicate one or more INSERT statements to the 'Publisher'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147200990) Get help: http://help/MSSQL_REPL-2147200990 A query executing on Publisher 'xxxxx' failed because the connection was chosen as the victim in a deadlock. Please rerun the merge process if you still see this error after internal retries by the merge process. (Source: MSSQLServer, Error number: 1205) Get help: http://help/1205 Any idea? This is getting to a critical point where transactions are not being uploaded to the server.  Additonally, there are a lot of blocks between the subscribers, and they are mainly associated with table MSmerge_partition_groups  

Graph messes up subreport?!?

Hello all, I'm using the built in graphs in SSRS 05. The report has a graph on top and a subreport below. The subreport contains the detail for the graph this way it displays like a Data Table in Excel. The report is 18 pages, displaying one page per department. The parameter for the subreport is the department number. For some reson I get "Error: Subreport could not be shown" on six of the pages. The graph on top displays correctly though?.. If I delete the graph and render the report with only the subreport I do not get any errors. Any ideas on what could cause this? Thank you in advance - Lee

Line graph in .rdlc

Hi ALL,             I have to desing line chart graph in .rdlc report, can you please help me, i have decimal values on Y-Axis and date time values on X-Axis , i have two series of product, according to product value during specific time i need to display line graph for each product.please do needfull to me.

SSMS 2008 & Activity Monitor's Processor Time graph is disabled

Hi,I just upgraded one of my SQL 2005 clusters to SQL 2008 with CU9.  Now, when I connect to it with SSMS, either from my workstation or directly on a cluster node, the % Processor Time graph in the Activity Monitor screen is disabled.  The other three graphs are fine.  If I connect to a different SQL 2008 server, the % Processor Graph is fine.  I don't see any errors in any app event log.  Has anyone else seen this behavior?Thanks!

Deadlock during CUBE Synchronization

When OLAP database synchornizes with other OLAP database, we get error saying ""Transaction errors: Aborting transaction on session %". what might be reason for this error when CUBE/database syncs with other database. As per understanding, sync should not hold any locks> any help here will be greatly appreciated.SugeshKumar

How to read and analyze a very large log file with high efficiency and performance?

It is a very large .txt file (more than 3M), and produced everyday, the content is user's system log like below: 2007-11-01 18:20:42,983 [4520] INFO GetXXX() SERVICE START2007-11-01 18:21:42,983 [4520] WARING USER ACCESS DENIED2007-11-01 18:22:42,983 [4520] ERROR INPUT PARAMETER IS NULL CAN NOT CONVERT TO INT322007-11-01 18:23:59,968 [4520] INFO USER LOGOUT   Any idea? Thanks.

Bar-graph style - how to keep columns in relative height of size of "graph"

Hi, I need some input for this and imagined that someone else had seen something like it: I have a box, let's say a grid, where there are some bars in it. These bars could be rectangles in a ItemsControl. The grid has a fixed height and width - but the rectangles' height (and width) are set a from a collection of numbers. These numbers go from 0 to 200 - but in periods the numbers only go from 1 to 10. If I use absolute numbers, the rectangles will be tiny in height or width if the numbers are between 1 and 10 and the Grid is 200 in height and width. How do I make the size of these rectangles relative to the tallest one? I guess I could do some calculations 'behind the scenes' in code, but is that really necessary? Is there no other way? Thanks! --Anders
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend