Hi folks I see strange thing. When I run simple delete statement, it shows it's blocked by spid -2. Does anybody know what it is?
Are you using SQL Server 2000? If so, maybe it is an orphaned DTC transaction? Nothing here that will fix it, but at least a brief explanation: http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx On 8/7/08 12:08 PM, in article 6BCF914C-FD9A-4A34-9B0A-9FD1E4C30113@microsoft.com, "Gene." wrote: > Hi folks > I see strange thing. When I run simple delete statement, it shows it's > blocked by spid -2. > Does anybody know what it is?
Hi Aaron This is 2005. When i run sp_lock, I see a bunch of resources locked by this process. "Aaron Bertrand [SQL Server MVP]" wrote: > Are you using SQL Server 2000? If so, maybe it is an orphaned DTC > transaction? Nothing here that will fix it, but at least a brief > explanation: > > http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx > > > On 8/7/08 12:08 PM, in article > 6BCF914C-FD9A-4A34-9B0A-9FD1E4C30113@microsoft.com, "Gene." > wrote: > > > Hi folks > > I see strange thing. When I run simple delete statement, it shows it's > > blocked by spid -2. > > Does anybody know what it is? > >
You have an orphaned DTC spid. Run this query and see what it shows you: - select distinct(req_transactionUOW) from sys.syslockinfo where req_spid = -2; If they are all ooo zeroes then you may need to stop/start DTC. What build are you on? Chris "Gene." wrote in message news:D5F679DF-3EAF-4802-9877-D8ECDA74ED17@microsoft.com... > Hi Aaron > > This is 2005. When i run sp_lock, I see a bunch of resources locked by > this > process. > > > "Aaron Bertrand [SQL Server MVP]" wrote: > >> Are you using SQL Server 2000? If so, maybe it is an orphaned DTC >> transaction? Nothing here that will fix it, but at least a brief >> explanation: >> >> http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx >> >> >> On 8/7/08 12:08 PM, in article >> 6BCF914C-FD9A-4A34-9B0A-9FD1E4C30113@microsoft.com, "Gene." >> wrote: >> >> > Hi folks >> > I see strange thing. When I run simple delete statement, it shows it's >> > blocked by spid -2. >> > Does anybody know what it is? >> >>
Thank you Chris. "Chris Wood" wrote: > You have an orphaned DTC spid. Run this query and see what it shows you: - > select distinct(req_transactionUOW) from sys.syslockinfo where req_spid > = -2; > > If they are all ooo zeroes then you may need to stop/start DTC. > > What build are you on? > > Chris > > "Gene." wrote in message > news:D5F679DF-3EAF-4802-9877-D8ECDA74ED17@microsoft.com... > > Hi Aaron > > > > This is 2005. When i run sp_lock, I see a bunch of resources locked by > > this > > process. > > > > > > "Aaron Bertrand [SQL Server MVP]" wrote: > > > >> Are you using SQL Server 2000? If so, maybe it is an orphaned DTC > >> transaction? Nothing here that will fix it, but at least a brief > >> explanation: > >> > >> http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx > >> > >> > >> On 8/7/08 12:08 PM, in article > >> 6BCF914C-FD9A-4A34-9B0A-9FD1E4C30113@microsoft.com, "Gene." > >> wrote: > >> > >> > Hi folks > >> > I see strange thing. When I run simple delete statement, it shows it's > >> > blocked by spid -2. > >> > Does anybody know what it is? > >> > >> > > >
What did the query return Gene? Chris "Gene." wrote in message news:D01C138E-7FC1-4761-8426-48340F1E27E3@microsoft.com... > Thank you Chris. > > > "Chris Wood" wrote: > >> You have an orphaned DTC spid. Run this query and see what it shows >> you: - >> select distinct(req_transactionUOW) from sys.syslockinfo where req_spid >> = -2; >> >> If they are all ooo zeroes then you may need to stop/start DTC. >> >> What build are you on? >> >> Chris >> >> "Gene." wrote in message >> news:D5F679DF-3EAF-4802-9877-D8ECDA74ED17@microsoft.com... >> > Hi Aaron >> > >> > This is 2005. When i run sp_lock, I see a bunch of resources locked by >> > this >> > process. >> > >> > >> > "Aaron Bertrand [SQL Server MVP]" wrote: >> > >> >> Are you using SQL Server 2000? If so, maybe it is an orphaned DTC >> >> transaction? Nothing here that will fix it, but at least a brief >> >> explanation: >> >> >> >> http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx >> >> >> >> >> >> On 8/7/08 12:08 PM, in article >> >> 6BCF914C-FD9A-4A34-9B0A-9FD1E4C30113@microsoft.com, "Gene." >> >> wrote: >> >> >> >> > Hi folks >> >> > I see strange thing. When I run simple delete statement, it shows >> >> > it's >> >> > blocked by spid -2. >> >> > Does anybody know what it is? >> >> >> >> >> >> >>
It did not find any. I think server was rebooted. I apprecuate your answer, save it in depository and use it in future. Thanks, again. "Chris Wood" wrote: > What did the query return Gene? > > Chris > > "Gene." wrote in message > news:D01C138E-7FC1-4761-8426-48340F1E27E3@microsoft.com... > > Thank you Chris. > > > > > > "Chris Wood" wrote: > > > >> You have an orphaned DTC spid. Run this query and see what it shows > >> you: - > >> select distinct(req_transactionUOW) from sys.syslockinfo where req_spid > >> = -2; > >> > >> If they are all ooo zeroes then you may need to stop/start DTC. > >> > >> What build are you on? > >> > >> Chris > >> > >> "Gene." wrote in message > >> news:D5F679DF-3EAF-4802-9877-D8ECDA74ED17@microsoft.com... > >> > Hi Aaron > >> > > >> > This is 2005. When i run sp_lock, I see a bunch of resources locked by > >> > this > >> > process. > >> > > >> > > >> > "Aaron Bertrand [SQL Server MVP]" wrote: > >> > > >> >> Are you using SQL Server 2000? If so, maybe it is an orphaned DTC > >> >> transaction? Nothing here that will fix it, but at least a brief > >> >> explanation: > >> >> > >> >> http://msdn.microsoft.com/en-us/library/aa260384(SQL.80).aspx > >> >> > >> >> > >> >> On 8/7/08 12:08 PM, in article > >> >> 6BCF914C-FD9A-4A34-9B0A-9FD1E4C30113@microsoft.com, "Gene." > >> >> wrote: > >> >> > >> >> > Hi folks > >> >> > I see strange thing. When I run simple delete statement, it shows > >> >> > it's > >> >> > blocked by spid -2. > >> >> > Does anybody know what it is? > >> >> > >> >> > >> > >> > >> > > >
