Deadlocks And Use Of Nolock
I am getting lot of deadlocks in my application. As it is very complex
ti avoid deadlocks at this stage of application we have done few steps
to lessen the impact.
We have added retries after deadlock is capturted.
We have added select * from TABLE with (nolock) wherever possible.
But interestingly second step is not working. I have few simple select
statements where i am using nolock criteria still I am getting
deadlock victim error. Any idead why it happening. I thought as soon
as I put nolock in the query it will ignore all the locks.
My sp is
CREATE procedure sp_Check_denomination
@supply_till_idint,
@product_codechar(4),
@iso_currency_codechar(3),
@denominationmoney
as
declare @product_id numeric(5)
select @product_id = product_id from product with (nolock) where
product_code = @product_code
if exists (select *
from transaction_inventory TI with (nolock),
product_ccy_denom PCD with (nolock)
where TI.supply_till_id = @supply_till_id
and TI.product_id = @product_id
and TI.iso_currency_code= @iso_currency_code
and TI.denomination = @denomination
and TI.product_id = PCD.product_id
and TI.iso_currency_code = PCD.iso_currency_code
and TI.denomination = PCD.denomination
and PCD.product_id=@product_id
and PCD.denomination = @denomination
and PCD.iso_currency_code=@iso_currency_code
and PCD.tradeable = 1)
begin
return(1)
end
else
begin
return(0)
end
GO
View Complete Forum Thread with Replies
Related Forum Messages:
NOLOCK Or Not To NOLOCK
I need some help to under stand when the right time is for NOLOCK. I work in a small dev group and NOLOCK seams to be a buzz word and others are throwing it in all over for no apparent reason. I read the thing from http://www.sql-server-performance.com/ and I am sure that our web and SQL servers are about 100x over sized for the application. While are ASP.Net (VB) app may demonstrate some hesitation from time to time I am more inclined to blame poor VB.Net coding techniques before slow SQL. The point being the NOLOCK is being added to SELECTS that are not part of a transaction and were using the SQL data adapter to return datasets or single column values. Also I am not even sure it’s being used correctly. The OLM has the example: SELECT au_lname FROM authors WITH (NOLOCK) However I am seeing it formatted like this: SELECT au_lname FROM authors (NOLOCK) I am by no mean an expert, I follow what I read in books or from examples from others. And I have never read in a book go crazy with NOLOCK because it’s the bomb! Any thoughts? I am trying to learn as much as I can before I raise my hand and say this might be a bad idea. Thanks
View Replies !
Db2, Nolock
Hi guys, I am a new user for DB2. In DB2 V8, i have a table with some no of columns. table test col1 col2 col3 col4 Now i want to issue a query like this. select col1 from test with(NOLOCK) where col1 = <some value> when i am executing this query on that time i am getting a error message like this... SQL0158N The number of columns specified for "MT.TEST" is not the same as the number of columns in the result table. SQLSTATE=42811 Anyone can help me??? i tried to find out. I did the same thing with SQL server 2000. I am not facing any problem there. Thanks & Regards, Muthu
View Replies !
NOLOCk
Other than "dirty" reads, what are the cons of using NOLOCK throughout a query?
View Replies !
NOLOCK
We have a report that is querying data from SQL Server and it is locking up the system. Would adding a NOLOCK help in this situation? TIA!
View Replies !
DTS- WITH (NOLOCK)
Hi, I have a job that runs 3 seperate DTS packages. The first step imports a file and runs successfully. The second step which is the 2nd DTS package is hanging in the execute mode until I manually stop the job. Apparently,We discovered a bulk insert that is blocking a select statement--both proccesses are within this second DTS package. I tried using the WITH (UNLOCK) on the tables but this DTS package is still failing. Does anyone have any suggestion? It would be greatly appreciated.
View Replies !
With (nolock)
is really helpful use "with (nolock)" sentence in selects?? 100% useful?? disadvantages? best regards Joseph
View Replies !
NOLOCK Help
Paul Randal, There has been a discussion/debate going on this thread about the benefits and drawbacks of using the NOLOCK hint: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67294 It occurred to me that you might know more about this than any of us, or at least be able to point us to a white paper or knowledge base article that explains the subject in more detail. Any light you can shed on the subject would be a big help. CODO ERGO SUM
View Replies !
With Nolock Problem
Hi,Is there a way to catch every select comming to sql and change it toselect with nolock?or how to make database READ UNCOMMITTED permanent?any ideas?Richard
View Replies !
When To Use The NOLOCK Hint.
Background:I am currently working on a mission critical web based applicationthat is accessed 24 hours a day by users from just about every timezone. We use MS SQL Server as our database and we have lots ofproblems with time-outs. We used to have lots of problems with locksuntil my management decided that we would use the WITH (NOLOCK) hinton EVERY select statement and WITH (ROWLOCK) on EVERY updatestatement. I have argued since the beginning that the NOLOCK hintshould be the exception and not the rule. Meanwhile we continue tohave problems related to time-outs.Problem:I'm the one that they call when there are time-out errors.I am a programmer first and a DBA when I have to be. I'd really liketo hear from some of you who are the opposite. I realize that thereare many factors that contribute to slow response from a databaseserver (indexes, RAM, disk speed, etc.), but what I really need tohear from an expert is whether or not using NOLOCK on **EVERY** queryin a 30GB database that has 344 tables is a bad idea.Thanks in advance,Stephen McMahonJoin Bytes!
View Replies !
NOLOCK Sentence
Hello !! I'm using the sentence NOLOCK for selects, but I have many sentences, Is there any way to set a parameter in the DBMS, to use NOLOCK parameter by default ???? I mean, I don't like to lock any table for selects. Is It possible ???? How to do It (step by step) ? Thanks !!
View Replies !
NOLOCK On Views
Hey guys, I came across a SQL statement, thought up by a developer, in which two views were joined with the NOLOCK hint: SELECT v1.xxx, v2.yyy FROM dbo.vw_SomeView v1 WITH (NOLOCK) INNER JOIN dbo.vw_SomeOtherView WITH (NOLOCK) ON v1.id = v2.id The views are not created the NOLOCK hint. So my question is: has the NOLOCK hint any effect here? I've looked in the BOL and searched on the net but can't find anything on this particular topic. Lex PS. Personally I don't like to use views in JOINs. I've seen too many cases in which tables are joined twice just because they are part of both views. Further more I don't like the "random" use of NOLOCK because most people don't seem to understand the implications of it. But this is besides the point of my question ;)
View Replies !
NOLOCK On Views
Hello, Does anyone know if you place NOLOCK after a view in a select statement, if the effects trickle down to the tables in the view? Or does one have to add NOLOCK to each table within the view? Thanks
View Replies !
NOLOCK Usage
I understand that using the NOLOCK in a select statement will help with table locking in SQLServer 7, but when I try to use it the server reports that it isn't in the right spot -- I checked the BOL and I believe I'm using it correctly. Can nolock be applied to updates and inserts too? And what's the best way to use it? My usage: SELECT * FROM myTable(NOLOCK) ... Thanks from a newbie, John
View Replies !
NoLock Vs ReadPast
I have been experiencing deadlock errors with two stored procs that I am using. SP1 is a read query that gets all unprocessed orders (status = 0) SP2 is an insert query that inserts new orders (Status = 0) uses a transaction. I have a multithreaded application and once in a while the read query (SP1) will try to read a new row that has just been inserted but not committed yet hence the deadlock arises. If i use a hint "With(NoLocks)" this will be a dirty read and still read the uncommitted insert from SP2 - is this correct? Where as if I use hint "With(ReadPast)" this will now only read committed rows and hence the deadlock should not arise - it will not read any uncommitted rows - Correct? So I think that it is better to use READPAST than NOLOCK. Any orders that have status = 0 not picked up will get picked up on the next round when SP1 is executed again. Any thougths or suggestions are always appreciated. Jawahar
View Replies !
NOLOCK Deprecated?
Is the NOLOCK optimizer hint being deprecated? Or does this apply only to use of NOLOCK in UPDATE and DELETE statements or what exactly? I can see that in this article that there are circumstances in which the hint is deprecated; however, I have developers that are acting like NOLOCK is about to be dropped entirely. As far as I know, that is not the case but I would definitely like some feedback on this.
View Replies !
Nolock Problem
Hi! select * from rubberstock_tbl_shoppingcarttemp It dosent take datas from the table but select * from rubberstock_tbl_shoppingcarttemp (nolock) This querey takes the data from the table what can i do to retrieve records through first query.I dont know what is happening please explain and also dont know about nolock Thanks in advance!
View Replies !
NOLOCK Option ?
Hi, I was sreading about NOLOCK that it could prevent deadlocks but could return data which is not committed yet. 1) Should we use NOLOCK with select statements 2) If the transaction isolation level is set appropriately (e.g. Serializable)in the component (for e.g COM+ component) but NOLOCK is specified in the select then would it return uncommitted data. I mean if the transaction is controlled at hihger level then what will be the Pros and Cons of using NOLOCK. Thanks
View Replies !
Question About NOLOCK
Hi, I have never used NOLOCK, or ROWLOCK, or anything of that sort. It's something I thought was over my head when I first encountered it and as I am gaining a better grip on SQL I have decided I want to try and tackle it. Also, because I think its causing me some problems :) I recently implemented a new query into my application. The query below gets the COUNT(*) of certain tables. Some of these tables are tall (5 million plus rows) The counts returned are not absolutely critical information, and we are not joining or doing any other transactions based on this data. I believe running these counts on these pretty active tables (selects,inserts) are possibly causing slowdowns ? Would using NOLOCK be an appropriate situation for something like this ? I am looking for a performance increase hopefully, and hoping there isnt much of a downside? I'm also not sure what type of reliability to expect from NOLOCK. Any help much appreciated !! Thanks once again mike123 create PROCEDURE [dbo].[select_UserStats_Admin_TEST] ( @userID int ) AS SET NOCOUNT ON DECLARE @Mail_Sent INT, @Mail_Received INT, @Comments_Sent INT, @Comments_Received INT, @friendsListCount INT SELECT @Mail_Sent = count(*) FROM tblMessage WHERE messageFrom = @userID SELECT @Mail_Received = count(*) FROM tblMessage WHERE messageTo = @userID SELECT @Comments_Sent = count(*) FROM tblComment WHERE CommentFromID = @userID SELECT @Comments_Received = count(*) FROM tblComment WHERE CommentTo = @userID SELECT @friendsListCount = count(*) FROM tblFriends WHERE userID = @userID SELECT @Mail_Sent as Mail_Sent, @Mail_Received as Mail_Received, @Comments_Sent as Comments_Sent, @Comments_Received as Comments_Received, @friendsListCount as friendsListCount
View Replies !
Select (nolock)
Hi, I get an error when select * from a table with nolock....please help. Cannot specify an index or locking hint for a remote data source
View Replies !
NOLOCK Clarifications
When the NOLOCK hint is included in a SELECT statement, no locks are taken when data is read. This gives a Dirty Read in a result set. The data retrieved in the select statement may not be correct since some other process might have updated the data while it was taken in the select statement. Now, Can I know what is the use of NOLOCK? In which way we can make efficient use of NOLOCK ???
View Replies !
NOLOCK Hint On Views?
Hi all If i have a view: CREATE VIEW vw_Users AS SELECT * FROM Users WITH(NOLOCK) Is it suggested to use nolock in views? And if i needed to use this view in stored procs is it then suggested to apply the nolock hint? CREATE PROC [dbo] .[usp_GetCompanyUsers] AS SELECT * FROM Companies WITH(NOLOCK) JOIN vw_Users WITH(NOLOCK) --<< ---is this suggested?
View Replies !
Wrong Result Set When Using NoLock
I have a Store Procedure on a Sql Server 2000 Where I use the Table Hint"NoLock" on all selects.One of my clients (OleDbConnection from C#) doesn't get the same Result Setas the others. The result Set should have 31 rows but this client only gets5!When I remove all the "NoLocks" everything works fine. How can that be?
View Replies !
Use Of Nolock In Select Statement
Hi , My application involves a hell lot of select statements please do suggest me whether i can use the nolock option with all the select statements please tell me what is the impact of nolock option whether it is increasing the performance or not please do indicate its usage Regards Ramesh g
View Replies !
Lookup Task With NOLOCK
I have an SSIS package that unpivots data - each row from the source becomes 20-24 rows in the destination db. In the dataflow it looks up some type-data IDs before inserting into the destination table. The whole process flies through the data at an incredible rate, however I find that the final commit on data insertion takes a very long time, and two of the lookup tasks remain yellow throughout. It appears that there may be a contention issue because the final table has FKs to those lookup tables. In T-SQL it is possible to do SELECT..... WITH (NOLOCK), but when I modified the SQL statement of the lookup task by adding this clause, it caused an error "Incorrect syntax near the keywork 'with'." Is there any way around this problem? THNX! PhilSky
View Replies !
Extensive Use Of NOLOCK, Any Issues?
I'm currently working on a system that makes a number of read queries whilst updates are taking place. Assuming that these reads don't need to be 100% accurate (i.e. they may incorrectly reflect partial updates) is there any other problem/danger from using WITH (NOLOCK)? I'm aware of one specific NOLOCK bug but I wanted to see what the community thought.
View Replies !
Connection Level NOLOCK
Hi! when WITH (NOLOCK) statement is used in a select statement, it allows to retrieved data from a set of data locked by another transaction. Is it possible to enforce this at connection level? I mean to open a connection using sqlclient and enforce NOLOCK so that all select statements post to database using that connection are not locked by other transactions. thanks in advance
View Replies !
With Nolock In Sql Server Please Advice
I have read lots of article about with nolock, and have seen many projects using with nolock option. Please advice me if i am right. 1.Normal select queries can use with no lock 2. Batch jobs should not use with no lock. please guide me, am i right. Thanks
View Replies !
Installation Error - 'NOLOCK'
I get the following error when installing SQL Server Express SP2 on Windows XP SP2 with all current updates. The only other thing installed is .NET 2.0. Does anyone know how to resolve the issue. [Microsoft][SQL Native Client][SQL Server]Could not continue scan with NOLOCK due to data movement Thanks,
View Replies !
NOLOCK Query Waits Forever
Back in the days of SQL 7.0 I used a lot of ODBC SELECT querying form VB applications, in which I implemented NOLOCK in order to prevent the primary business applications from being locked out of tables once the queries were run. Now, quite a few years later, I'm busying myself converting a lot of old Access based forms and queries to TSQL on SQL-Server 2000, and wonder aimlessly why NOLOCK queries (simple select ones) are imensely slower than a standars select clause. SELECT * FROM employees This would be much much faster than the code below, but users would get "The current record could not be accessed, as it is being used by another user", evidently because I'm locking the record while producing the output. SELECT * FROM employees (nolock) So this could should - as I remember it - do a dirty read on table, not obstructing other users and give me a snapshot of date as they are, although they might be locked for edit. Could anyone explain to me why the nOLOCK query fials to give me any output? It is as if the nolock request is waiting for the table/records to free? In which case I'll never be able to run a query. Cheers in advance, Trin
View Replies !
Isolation Level VS With(nolock|rowlock)
Hello all. I'm a litle confused about what's best to use, either isolation levels or locking per table. Cause there are some queries in the stored procedures where I don't need locking i.e. when I check the status of client, but other queries where I do need locking like when I check the existence of a product. What's best to use, can I combine both? Could you explain it thecnically? lots of thanks in advance
View Replies !
NOLOCK Optimizer Hint On Iterator
An interesting discussion yesterday. One of the programmers asked about the use of the NOLOCK optimizer hint with an iterator table aka table of numbers. His comment was that this optimizer hint was not efficient. Rather than give a knee-jerk response I thought it would be better to ask. The main circumstance is that the iterator table is completely static with a fill factor of 100%. My purpose is to eliminate lock contention if I can. Are there reasons to not use the NOLOCK hint in this case to potentially improve performance? Dave
View Replies !
WITH(NOLOCK) No Allowed In SqlDependency Queries?
Hello, I have a WCF Windows Service which caches some query results. I am using the SqlDependency class to watch for any data changes in the backend SQL table, and then if so, update the loca caches. Everything works great, except under concurrent use. If a client of the service runs a job, and at the same exact time, a user using the web application front end updates one of the SQL lookup tables, I get the following SqlClientException from the WCF Service: {"Transaction (Process ID 72) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction."}. I could be wrong on the scenario that causes it, however I believe this is the case. I'm not sure why this is happening to be honest.. however I have seen this issue in the past and we have solved it by using the 'WITH(NOLOCK)' clause on the query that is causing the error... I tried simply adding WITH(NOLOCK) to the query that is being watched from inside the WCF Service - however then in my OnChanged event I got errors about the query not being correct. I have gone over the dtails on what invalidates a query for Service Broker (http://msdn2.microsoft.com/en-us/library/aewzkxxh.aspx) and I do not see NOLOCK on the list... Is there something obvious I'm missing here? More importantly, since it appears this is invalid... what should I do to handle this situation? Can I just handle the SqlException on the client side and then re-try loading the dataset and hooking to OnChanged?? Thanks
View Replies !
NOLOCK/ROWLOCK (good Or Bad Guys?)
Reading about avoiding deadlocks in SQL, I have found different opnions about whether using or not NOLOCK/ROWLOCK hints on SELECT/UPDATE/DELETE statements. I have several applications executing transactions on the same databases and tables, including inserts, updates and deletes. I wonder if by using NOLOCK/ROWLOCK I could decrease the chances of having deadlocks. At least using ROWLOCK on my update statements?. I just need some advice here. Regards.
View Replies !
Select With Nolock Has Calculation Risk??
Hi all, I just read this article. The kind of select is called dirty read. So select with nolock might have inaccurate result...? PLEASE COMMENT ON THIS. I am using it to count some huge tables, and has problem on the result.. http://www.4guysfromrolla.com/webtech/101100-1.2.shtml NOLOCK Using NOLOCK politely asks SQL Server to ignore locks and read directly from the tables. This means you completely circumvent the lock system, which is a major performance and scalability improvement. However, you also completely circumvent the lock system, which means your code is living dangerously. You might read the not-necessarily-valid uncommitted modifications of a running transaction. This is a calculated risk. For financial code and denormalized aggregates (those little counters of related data that you stash away and try desperately to keep accurate), you should play it safe and not use this technique.
View Replies !
Error On Backup Scan With Nolock
Hi Guys, Every time backup job backup the database or I manually backup the database I receive error message [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 601: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not continue scan with NOLOCK due to data movement. This is sql 2000 maintainance job or manual backup does same though actually backup of database does happen and I do have successfull backup but error also and older files are not getting deleted and job shows as failed in enterprise manager. Any idea guys
View Replies !
Deadlocks
Our system is reasonably complex with a lot of non-trivial stored procedures. As the load on our DB increased we're now getting more and more deadlocks (10 per day or so from about a million stored proc executions). We try to avoid transactions where we can, and we do attempt to optimse stored procs to steer clear of deadlock conditions, but with the sheer number of stored procedures we can't possibly avoid all deadlock conditions. One solution I'm considering is to re-run stored procs that failed because of a deadlock. In the .net code we'll run the stored proc, check for a deadlock error and if one happened, wait 100ms and try again. What do you guys think?
View Replies !
Deadlocks
Hi EverybodyI am new to sqlserver 2000.I know basics of locks.but i dont know how toresolve deadlock issues.I am cofusing by reading articles with 90%information and remaining 10% missing.Can any one help me which is the goodsite to learn and resolve deadlocks.Note: I create deadlock. when i try to trace deadlock using dbcc traceon(1205,3604,-1).In error log showing nothing about the deadlock.showing created traceon.........Any help would be appreciated.--Message posted via http://www.sqlmonster.com
View Replies !
Deadlocks, Why?
We have a problem with a table giving us deadlock issues and we can'tfigure out why.It's a table we write to fairly often perhaps 50 times a minute. Andalso do a select of 200 rows at a time from 4 servers every 5 minutes or so.We are only keeping 48 hours worth of rows in the table which averagesat 30000 a day on a busy day.This table has 1 PK and 2 FKs plus one TEXT column which does notparticipate in the WHERE clause.We are using binded variables.We have applied the latest patch to SQL2003 server running onWindows2003. The patch is supposed to resolve deadlock issues.Anyone have any advice on how to alleviate this problem.Thanks
View Replies !
Deadlocks
If an instance of SQL 2005 was in use and was using row versioning,under what circumstances would the below error occur?Transaction (Process ID 56) was deadlocked on lock resources withanother process and has been chosen as the deadlock victim. Rerun thetransactionWe used to get this sort of thing when a large copy process was runningunder a transaction, but all it was doing was reading the records andcreating brand new records yet would still lock the entire table. Oncewe enabled the row versioning, we stopped having this issue, but itseems that there are some circumstances in which it still happens, i.e.the above error.Any ideas how that might occur?
View Replies !
Too Many Deadlocks
Hi, I've got a deadlock problem. The log below has been generated. The problem is that during one day, I have more than 300 deadlocks like it. Before, the were not so many deadlocks. During past year, the number of users has grow (from 100 before to 500 or 700 now) *** Deadlock Detected *** - Requested by: SPID 360 ECID 0 Mode "S" - Held by: SPID 113 ECID 0 Mode "S" Index: aaaaa_PK Table: TABLE_1 Database: MYDB == Lock: KEY: 22:325576198:1 (ff009ae5078d) - Requested by: SPID 113 ECID 0 Mode "S" - Held by: SPID 374 ECID 0 Mode "X" Index: aaaaa_PK Table: TABLE_1 Database: MYDB == Lock: KEY: 22:325576198:1 (ff009ae5078d) - Requested by: SPID 374 ECID 0 Mode "IX" - Held by: SPID 360 ECID 0 Mode "S" Table: TABLE_2 Database: MYDB == Lock: PAG: 22:1:2428 == Deadlock Lock participant information: Input Buf: S E L E C T the_rest_of_the_query SPID: 360 ECID: 0 Statement Type: UNKNOWN TOKEN Line #: 1 Input Buf: s p _ e x e c u t e 8 Input Buf: s p _ c u r s o r 8À B 8 8f ç @ Table I Input Buf: S E L E C T the_rest_of_the_query SPID: 360 ECID: 0 Statement Type: SELECT Line #: 1 == Session participant information: == Deadlock Detected at: ==> Process 360 chosen as deadlock victim I have done : - rebuild indexes on all tables (fillfactor 90) - analysed memory activity Could a lack of memory be at the origin of the problem ? Which counters in perfmon are significant for memory lack ? Could the index fill factor could be at the origin of the problem ? At time, it is at 90 percent. Config : Winnt4 Server, MS-SQL 7 SP4 , 2 GB of RAM , 2 x Xeon 700 Thanks for any help.
View Replies !
Deadlocks (I Think)
Hi folks, I have an application built on top of a questionable DB design which requires overcomplicated selects. The application is experiencing deadlocks regularly, in some cases with only one concurrent user. I set the trace flag 1204 but am not seeing anything in the Error.log and I initiated a trace in profiler which does not seem to show any deadlock. Despite having recreated the problem which show my browser hanging indefinitely. When I run the following queries: SELECT spid, waittime, lastwaittype, waitresource FROM master..sysprocesses WHERE waittime > 10000 AND spid > 50 SELECT spid, cmd, status, loginame, open_tran, datediff(s, last_batch, getdate ()) AS [WaitTime(s)] FROM master..sysprocesses p WHERE open_tran > 0 AND spid > 50 AND datediff (s, last_batch, getdate ()) > 30 ANd EXISTS (SELECT * FROM master..syslockinfo l WHERE req_spid = p.spid AND rsc_type <> 2) I get: 55860978LCK_M_XPAG: 13:1:2573 54AWAITING COMMANDsleeping sa 11499 55UPDATE sleeping sa 21499 respectively. Any help would be welcome. Thanks in advance, Don
View Replies !
Deadlocks
This is probably a stupid question, but... Is there any way to totally avoid deadlocks. In some critical applications we have removed transactions entirely, counting on other means to maintain database consistency. We still get deadlocks in this area. These are mainly inserts, and the only thing I can think is that updates to the indexes are causing multiple page locks which result in deadlocks. Is this true? Will deadlocks be eliminated in 7.0 with row level locking for this situation? Or will index page splits still cause a possibility of deadlock contention? ben
View Replies !
Deadlocks
Hi guys, Does SQL Server 6.5 log deadlock errors automatically into the errorlog, or do I need to use traceflags ?? TIA Ju.DBA
View Replies !
DeadLocks
I am getting the following dead lock error message writtent to the Error Log. How do i interpret this...? 2002-07-10 11:49:52.88 spid3 Node:1 2002-07-10 11:49:52.88 spid3 KEY: 6:1531868524:1 (1e0040209980) CleanCnt:1 Mode: X Flags: 0x0 2002-07-10 11:49:52.88 spid3 Grant List:: 2002-07-10 11:49:52.88 spid3 Owner:0x26429de0 Mode: X Flg:0x0 Ref:2 Life:02000000 SPID:62 ECID:0 2002-07-10 11:49:52.88 spid3 SPID: 62 ECID: 0 Statement Type: INSERT Line #: 67 2002-07-10 11:49:52.88 spid3 Input Buf: RPC Event: sp_Save;1 2002-07-10 11:49:52.88 spid3 Requested By: 2002-07-10 11:49:52.88 spid3 ResType:LockOwner Stype:'OR' Mode: Range-S-S SPID:58 ECID:0 Ec:(0x29f534f8) Value:0x2649f0c0 Cost:(0/0) 2002-07-10 11:49:52.88 spid3 2002-07-10 11:49:52.88 spid3 Node:2 2002-07-10 11:49:52.88 spid3 KEY: 6:1695345104:1 (ffffffffffff) CleanCnt:1 Mode: Range-S-U Flags: 0x0 2002-07-10 11:49:52.88 spid3 Grant List:: 2002-07-10 11:49:52.88 spid3 Owner:0x26450f20 Mode: Range-S-U Flg:0x0 Ref:1 Life:02000000 SPID:58 ECID:0 2002-07-10 11:49:52.88 spid3 SPID: 58 ECID: 0 Statement Type: INSERT Line #: 250 2002-07-10 11:49:52.88 spid3 Input Buf: RPC Event: sp_IPAQManagerFetchFilterDetail;1 2002-07-10 11:49:52.88 spid3 Requested By: 2002-07-10 11:49:52.88 spid3 ResType:LockOwner Stype:'OR' Mode: Range-Insert-Null SPID:62 ECID:0 Ec:(0x3bb5f4f8) Value:0x2649e040 Cost:(0/2340) 2002-07-10 11:49:52.88 spid3 Victim Resource Owner: 2002-07-10 11:49:52.88 spid3 ResType:LockOwner Stype:'OR' Mode: Range-S-S SPID:58 ECID:0 Ec:(0x29f534f8) Value:0x2649f0c0 Cost:(0/0)
View Replies !
|
TRACKER
