Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Carat
Yak Posting Veteran
92 Posts |
 Posted - 2007-08-10 : 05:34:30
|
| I'm investigating my production server because there appears a deadlock every day. So, in SQL Profiler, I use the the Deadlock graph to capture the trace in a file.When I click on the textdata to see the graph an error appears:- Failed to initialize deadlock control. Cannot find process victim in process list.I also get the following error from another deadlock:- Failed to initialize deadlock control. Object reference not set to an instance of an object.I stopped my trace, so this can not be the problem.Does anybody knows why I can't see the graph?I also captured the trace in a table and then used the following query to see it in xml:select convert(xml,textdata) from TableNameThis works fine. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-10 : 13:28:46
|
| Since you are getting that "object reference" error, I suspect you've got an issue with the tool and not with the actual trace. Try installing service pack 2 for SQL 2005 on the client machine to see if that resolves the error. SQL Service packs should be installed on the servers and clients since they contain bug fixes for both the server and client tools.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2007-08-20 : 09:11:14
|
| I installed Service Pack 2 on the client and now it works fine.Thanks!!!!! |
|
|
|
|
|
|
SQL Server Profiler: Deadlock graph