Skip to Content

Hi everyone !

They are some commands to monitoring log suspend event in ASE 15 and up.

1. Shows how many and who process have “LOG SUSPEND” state:

    select spid,cmd,blocked,dbid from master..sysprocesses where cmd like “LOG SUSPEND”

     go

2. Shows what is the configuration for log segment in the current database ( you must use the comand “use database db_name” before).

     sp_helpsegment logsegment

     go

     In the end of result set you can see free_pages, used_pages y total_pages. you should be check the free_pages because this is the free space that ASE      can use to log, this value must be divided in 512 the result should be in MB units

3. Shows process with some time in CPU, most old transaction

     select * from master..syslogshold

     go

😎

➕ Español:

1. Monitorea que procesos se encuentran en log suspend:

    select spid,cmd,blocked,dbid from master..sysprocesses where cmd like “LOG SUSPEND”

2. Muestra la configuracion del segmento de log de la base de datos que se esta usando.

     sp_helpsegment logsegment

     Al final se muestran las lineas free_pages, used_pages y total_pages.

     Se debe revisar las free_pages y dividir este valor en 512, el resultado seran el tamaño en MB del espacio libre.

3. Muestra los procesos que se encuentran encolados en ASE, la transaccion mas vieja

     select * from master..syslogshold

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply