|
|
Posted by wreed on 07/13/06 15:43
Our SQL Server 200 box is getting perflib errors when we get a decent
amount of people using an application that I wrote, call queue system,
web based. To accomplish a queue type system on a button push I wrote
a query like this...
BEGIN TRANSACTION;
Select top 1...fields here...
FROM table with (xlock,readpast)
(2 joins)
WHERE numerous where clauses
ORDER BY 2 order bys.
Now our sql server starts timing out..then in the app log this shows
up....
Error: 1203, Severity: 20, State: 1
Process ID 62 attempting to unlock unowned resource PAG: 6:1:126407.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
The reason I am doing xlock is to make a record not viewable to 2
people if they click the button on the web form that runs the above
query within the same minute, they would get different records....
So to avoid this error which I assume is due to my xlock should I
rethink my query?
Navigation:
[Reply to this message]
|