adminbd

Записи по mssql,oracle,windows и linux

Have a Question?

If you have any question you can ask below or enter what you are looking for!

вычисляем какой процесс вызывает блокировку

-- вычисляем какой процесс вызывает блокировку
sp_whoisactive
@find_block_leaders = 1,
@output_column_list = '[dd%][session_id][sql_text][login_name][wait_info][cpu%][temp%][block%][reads%][writes%][context%][physical%][used_memory][status][open_tran_count][percent%][host_name][database_name][program_name][start_time][login_time][request_id][collection_time]', 
@destination_table = 'tsd1.dbo.[www_AxaptaInfoBoardWhoIsActive]'
-- конец

Задание запускать раз в минуту

SELECT *
  FROM [tsd1].[dbo].[www_AxaptaInfoBoardWhoIsActive]
  
  WHERE CONVERT(CHAR(8),COLLECTION_time,8) BETWEEN '07:00:00' AND '18:00:00' AND
       datepart(YEAR,start_time) BETWEEN 2015 AND 2015 and
       datepart(month,start_time) BETWEEN 08 AND 08 and
       datepart(day,start_time) BETWEEN 20 AND 21
ORDER BY start_time

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You can use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>