Sometimes my users call me and tell me that the system is slow, then I
open IPM and I see a lot of users in WAIT state, then I have to
identify who is the responsable for the lock and I kill him. ;-)
(kill the session lol...).
Is there a way to identify this locks before my users call me ? One
shell script, something like that...
Hi,
I run this SQL against imadb to find blocking sessions:
SELECT s.server,
s.effective_user,
s.db_name,
s.session_terminal,
Gerhard,
I was wondering, I have to execute the sql for each DBMS ? I have 4.
--
Regards,
Thiago Zerbinato
Oracle/Ingres DBA
Ribeirao Preto/SP
Brazil
.
Re: Identify Lock ... Sometimes my users call me and tell me that the system is slow, then I open IPM and I see a lot of users in WAIT state, then I have to identify who is the responsable for the lock and I kill him. ... I run this SQL against imadb to find blocking sessions:... (comp.databases.ingres)
Re: Rowlock v. optimistic concurrency ... A report fetches a lot of rows using the "WITH " syntax (the ... Note that lock timeouts are by default off in SQL Server....NOLOCK has nothing to do with optimistic concurrency. ... (comp.databases.ms-sqlserver)
Re: controlling lock order in transactions ... > and the trigger issued a rollback your commit or rollback would error. ... > Andrew J. Kelly SQL MVP... >> taken) for the duration of the transaction.... >> find in the clients sp that could be causing the dead lock is the join on ... (microsoft.public.sqlserver.programming)
Re: Pass-Through Query w/o Record Locking ... > Found some documentation on the Progress web site that addresses an SQL... >> Can you setup a nightly job writes your needed data to a 'warehouse'(OLTP ... >>> looking for but am running into record lock problems.... >>> modifying.... (microsoft.public.access.queries)
