madhuottapalam: We use ROWLOCK to try to minimize the lock escalation. What's your suggestion? use BEGIN TRAN...COMMIT TRAN? MohammedU: DELETE...
Hi, I have an appliction which run the following two SQLs in the order: 1.INSERT INTO tab1 WITH (ROWLOCK) 2.DELETE from tab1 WITH (ROWLOCK) This...
I have read the following articles but still don't know which way is the most efficicent way: http://support.microsoft.com/kb/323630...
Hi, I have a program which insert/update thousands of rows in a table (this table has millions of rows), some other programs are doing DML...
Hi, I have table which has an index on (col1, col2), if in my query the where clause is col2='a' and col1='b', does it matter?
"Where are you displaying all rows after joining." - Data will be feeded into other program I have asked and they said no filter can be added in...
Hi, I need to join two big tables and return all rows of the tables. The problem is the two tables are big so the performance of the query is very...
Hi, I try to tune a slow query: SELECT 1 FROM tab1 WHERE col1 = ? AND col2 = ? AND col3 = ? AND (SELECT COUNT(col1) FROM tab2 a...
I have found that reason why “Lock<img src='/community/emoticons/emotion-2.gif' alt=':D' />EADLOCK CHAIN†event is not captured, it is because...
I have told my manager that since the deadlock mentioned that it is "TABLE LOCK", the deadlock is a conversion deadlock and it is caused by SQL...
My manager wants me to find out the reason of the deadlock no later than the end of business day of today. Please help!!!
<img src='/community/emoticons/emotion-6.gif' alt=':(' /> Unfortunately we don't have dbcc traceon info for that deadlock, when I run the profiler, I...
Yes, I have went through them before and I have worked on quite a few deadlock issues before. This is the first time I saw a deadlock profile trace...
Thanks. Luis. I appreciate your quick response. I think the links Satya provides are for Blocking. My case is Deadlock. They are different. Thanks
All,<br /><br />Thanks in advance for your help. Any help is appreciated.<br /><br />I have a urgent production deadlock issue. Because of the...
Satya, sqlserver.locks is average index for all appliations. If I understand correctly, if 100 applications are using db, only 1 application lock a...
Hi, Thanks in advance for your help. I am working on a blocking issue of a production db. I try to implement something so SQL Server can send me an...
Then how to change it so that the data returned satisfy the original purpose? Thanks John
Hi, all: I issued a query on two tables: SELECT p.pcol1, ISNULL(COUNT(b.bcol1), 0) FROM p LEFT OUTER JOIN b ON p.pcol2 = b.bcol2 WHERE b.col3 >=...
I use performance monitor to monitor the normal lock request in the database (without run the job) Lock Name Average Min...
Separate names with a comma.
