August 3, 2009 at 9:16 am
Hi Every body,
In my transaction two locks occured IE(Inetent Lock, Exclusive)
How can we slove this prob could you plz help
really appriciate that guys,
Regards
Raj
August 3, 2009 at 9:59 am
What are you doing in the transaction? Queries are supposed to take locks to maintain consistency.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 3, 2009 at 10:15 am
Hi Jack,
See this scenario
In my organization one Main server is there this server is using 10 users
2 users are not some prob occured Intent lock, Exclusive lock occured how can we slove this prob
could you please give reply any body really appriciated those guys
Regards
Raj
August 3, 2009 at 2:06 pm
I think we are confused a bit. Could you explain what the problem you are have actually is? It would also help if you could provide the full text of any messages you may be receiving.
August 3, 2009 at 2:30 pm
shiv (8/3/2009)
Hi Every body,In my transaction two locks occured IE(Inetent Lock, Exclusive)
How can we slove this prob could you plz help
really appriciate that guys,
Regards
Raj
Those aren't problems. What is happening that makes you think they are? What symptom are you getting?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 3, 2009 at 7:12 pm
Exclusive locks are occuring because data is being manipulated, inserted, deleted or updated. Where's the issue?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 4, 2009 at 5:23 am
shiv (8/3/2009)
In my transaction two locks occured IE(Inetent Lock, Exclusive)
Intent-Exclusive locks normally show up as IX.
They are taken on higher levels of an object as an optimization.
Books Online explains it well, click on the link below to access the web version on MSDN:
http://msdn.microsoft.com/en-us/library/ms175519(SQL.90).aspx (Lock Modes)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply