Very Computer

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

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

Very Computer

No DeadLocks ...Lock file locks

No DeadLocks ...Lock file locks

No DeadLocks ...Lock file locks