No DeadLocks ...Lock file locks

No DeadLocks ...Lock file locks

Post by Bucke » Sat, 15 Feb 2003 07:35:26



What would be the cause of the Management->Current Activity file being
locked,
yet when you run traces with 1204, 1205, 3605 you don't see any dead locks.
Just thousands of reads over a 15 min period?

Any thoughts on this.?

Plus one other question:
A developer in one transaction does the following

Insert record
read same record
update the record
commit

Isn't it better to Insert record commit, read record, update record commit?

Just wondering

Jim

 
 
 

No DeadLocks ...Lock file locks

Post by Kalen Delane » Sat, 15 Feb 2003 07:16:42


Please do  not post the same question to separate newsgroups. You can put
multiple newsgroups in one message, but do not post independent identical
messages. See my reply in .server.

--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


Quote:> What would be the cause of the Management->Current Activity file being
> locked,
> yet when you run traces with 1204, 1205, 3605 you don't see any dead
locks.
> Just thousands of reads over a 15 min period?

> Any thoughts on this.?

> Plus one other question:
> A developer in one transaction does the following

> Insert record
> read same record
> update the record
> commit

> Isn't it better to Insert record commit, read record, update record
commit?

> Just wondering

> Jim


 
 
 

1. No Deadlocks...Lock file locks

What would be the cause of the Management->Current Activity file being
locked,
yet when you run traces with 1204, 1205, 3605 you don't see any dead locks.
Just thousands of reads over a 15 min period?

Any thoughts on this.?

Plus one other question:
A developer in one transaction does the following

Insert record
read same record
update the record
commit

Isn't it better to Insert record commit, read record, update record commit?

Just wondering

Jim

2. Open transactions and three tier

3. Deadlock in Index (where index is B+ tree) Locking with Intention Locks

4. How do I...

5. Kernel locks or file locks?

6. Need Help: Active Directory Refresh Problem on SQL2k

7. Get Username or Computername after lock (or deadlock) errors from MS SQL server (7 or 6.5)

8. Processes out of control

9. defending against deadlock with upgradeable locks

10. Table locks/blocks and deadlocks

11. Key Locks in Deadlock output

12. Locks and deadlocks

13. row locks and updates causing deadlocks