Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
Топик располагается на нескольких страницах: [1] 2   вперед  Ctrl      все
 Резкое падение производительности  [new]
slz386
Member

Откуда:
Сообщений: 11
Добрый день! Помогите пожалуйста советом или ссылкой на статью, чтобы локализовать проблему.

После выходных наблюдается резкое падение производительности, а именно загрузка ЦП до 100%.
Т.е. до выходных всё работало в штатном режиме, а сразу после выходных с утра начались проблемы.
На выходных настройки СУБД ни кто не менял.

Есть сервер БД системы электронного документооборота который крутится на виртуалке VMware ESXi 5.5, на него выделены ресурсы:
ОЗУ 18ГБ (сейчас используется 69%)
ЦП Xeon E5-2640v2 4 ядра(8 потоков) (сейчас нагрузка в пике 30-50%)
select @@VERSION

Microsoft SQL Server 2014 - 12.0.2269.0 (X64)
Jun 10 2015 03:35:45
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Размер БД 2,3Гб.
Количество активных пользователей 30 человек.
Особого внимания БД не уделялось, раз в сутки обновление статистик, ребилд индексов и бэкапы Logs и Full. Иногда создавались новые индексы по рекомендации Tuning Advisor.

Как только начались проблемы, работать в СЭД стало невозможно совсем, запросы выполнялись по несколько минут.
Видя что идёт высокая нагрузка на ЦП было добавлено ещё 3 ядра(до выходных было 1 ядро в 2 потока) и перезагружен сервер БД.
Стало работать почти как до выходных, но всё-равно медленнее.

Запустил профайлер чтобы найти запросы от пользователей которые выполняются дольше 1 секунды.
Вот наиболее долгие из них:

Duration 8245, CPU 8110, Reads 1107814, Writes 0
+
declare @p1 int
set @p1=180150033
declare @p3 int
set @p3=8
declare @p4 int
set @p4=1
declare @p5 int
set @p5=1
exec sp_cursoropen @p1 output,N'select count(*) 
from ( select o1.ID from [LSDBO].[Attrib_Value_T_v] a 
inner join [LSDBO].[object_reference_view] o on o.ID = a.Object_ID 
inner join [LSDBO].[Attrib_Value_N_v] a1 on a1.Object_ID = o.id and a1.Attrib_ID = 100000004300041 /*Атрибуты - ID сопоставленного пользователя*/ 
left join [LSDBO].[Attrib_Value_T_v] a2 on a2.Object_ID = o.id and a2.Attrib_ID = 100000023313856 /*Атрибуты - Дата согласования*/
left join [LSDBO].[tree_link_view] t on t.link_id = o.id and t.link_type_id = 2130000003 /*Согласование*/ 
left join [LSDBO].[object_reference_view] o1 on o1.ID = t.parent_id 
inner join lsdbo.wf_attachments_view at on at.doc_id = cast(o1.ID as varchar) 
inner join lsdbo.wf_mail_docs_v md on md.attachment_id = at.id inner join lsdbo.wf_mail_v mail on md.mail_id = mail.id 
inner join lsdbo.wf_mail_to_v mt on mt.mail_id = mail.id 
inner join [LSDBO].[wf_mail_and_map_v] mm on mm.id = mail.id 
where a.Attrib_ID = 100000061000005 /*Атрибуты - Срок исполнения*/ 
and o.Type_ID = 100000023213856/*Типы объектов - Согласующий */ 
and a.Value <= CONVERT (datetime, GETDATE()+1, 104) 
and a2.Value is null and a1.Value =0 and mt.state in (''N'', ''R'', ''W'') 
and mt.user_to_id = a1.value and mm.map_nodes_userdata = 35 
and mm.task_end_date is null 
union 
select distinct o.ID 
from [LSDBO].[Attrib_Value_T_v] a 
inner join [LSDBO].[object_reference_view] o on o.ID = a.Object_ID 
inner join [LSDBO].[Attrib_Value_N_v] a1 on a1.Object_ID = o.id and a1.Attrib_ID = 100000012500005 /*Атрибуты - ID сопоставленного пользователя*/ 
inner join [LSDBO].[Attrib_Value_S_v] a3 on a3.Object_ID = o.id and a3.Attrib_ID = 100000000404016 /*Атрибуты - Статус*/ 
left join [LSDBO].[Attrib_Value_S_v] a4 on a4.Object_ID = o.id and a4.Attrib_ID = 100000014054997 /*Атрибуты - Статус поручения*/
left join [LSDBO].[Attrib_Value_T_v] a5 on a5.Object_ID = o.id and a5.Attrib_ID = 100000061200005 /*Атрибуты - Фактическая дата выполнения*/ 
where a.Attrib_ID = 100000061000005 /*Атрибуты - Срок исполнения*/ 
and o.Type_ID = 100000057000005 /*Типы объектов - Поручение*/ 
and a.Value <= CONVERT (date, GETDATE()) and a3.Value0 <>''Выполнено'' and a3.Value0 <>''Отменено'' 
and a3.Value0 is not null and (a4.Value0 <>''Выполнено'' or ( a4.Value0 is Null and a5.Value is Null)) 
and (select count(*) from [LSDBO].[wf_attachments_view] at 
inner join [LSDBO].[wf_map_doc_tree_view] md on md.ID = at.map_doc_tree_id 
inner join [LSDBO].[wf_mail_and_map_v] mm on mm.map_id = md.map_id 
where [doc_id] = cast( o.ID as varchar)) > 0 and a1.Value = 0)as q',@p3 output,@p4 output,@p5 output
select @p1, @p3, @p4, @p5

Duration 6322, CPU 4172, Reads 666331, Writes 0
+
declare @p1 int
set @p1=180150009
declare @p3 int
set @p3=8
declare @p4 int
set @p4=1
declare @p5 int
set @p5=1
exec sp_cursoropen @p1 output,N'select atrFam.Value0 +'' ''+atrName.Value0 + '' ''+atrOtch.Value0 
from LSDBO.object_reference_view as sotr 
inner join LSDBO.Attrib_Value_N_v atr on atr.object_id = sotr.id 
inner join LSDBO.Attrib_Value_S_v atrFam on atrFam.object_id = sotr.id 
inner join LSDBO.Attrib_Value_S_v atrName on atrName.object_id = sotr.id 
inner join LSDBO.Attrib_Value_S_v atrOtch on atrOtch.object_id = sotr.id 
where sotr.Type_ID = 100000010200005 and atrFam.attrib_id = 100000011800005 
and atrName.attrib_id = 100000011900005 and atrOtch.attrib_id = 100000012000005 
and atr.attrib_id = 100000012500005 and atr.Value = convert(float, 770000038 )',@p3 output,@p4 output,@p5 output
select @p1, @p3, @p4, @p5

Duration 2066, CPU 2031, Reads 352348, Writes 0
+
declare @p1 int
set @p1=180150041
declare @p3 int
set @p3=8
declare @p4 int
set @p4=1
declare @p5 int
set @p5=1
exec sp_cursoropen @p1 output,N'SELECT COUNT(*) 
FROM LSDBO.object_reference_view obj 
INNER JOIN LSDBO.tree_link_view trl ON trl.parent_id = obj.ID 
INNER JOIN LSDBO.Attrib_Value_S_v statusAtr ON statusAtr.Object_ID = trl.link_id 
INNER JOIN LSDBO.Attrib_Value_N_v userAtr ON userAtr.Object_ID = statusAtr.Object_ID 
WHERE (obj.Type_ID IN (100000056300005 /*Входящий документ*/, 
100000056400005 /*Исходящий документ*/, 
100000057000005 /*Примечание*/, 
100000056700005 /*Служебная записка*/, 
100000057000005 /*Типы объектов - Поручение*/, 
100000055900005 /*Типы объектов - Распоряжение*/, 
100000055200005 /*Типы объектов - Приказ*/ )) 
AND trl.link_type_id = 30000003 /*Ознакомление*/ 
AND statusAtr.Attrib_ID = 100000505403000 /*Статус документа*/ 
AND userAtr.Attrib_ID = 100000012500005 /*ID сопоставленного пользователя*/ 
AND statusAtr.Value0 = N''Не ознакомлен'' AND userAtr.Value =770000093',@p3 output,@p4 output,@p5 output
select @p1, @p3, @p4, @p5

Duration 1055, CPU 437, Reads 86060, Writes 2
+
declare @p1 int
set @p1=180150387
declare @p3 int
set @p3=8
declare @p4 int
set @p4=1
declare @p5 int
set @p5=1
exec sp_cursoropen @p1 output,N'select folder.id 
from LSDBO.object_reference_view folder, LSDBO.tree_link_view pfolder 
where folder.ID = pfolder.link_id and folder.Type_ID = 100000056000005 and pfolder.parent_id=100001418077004 
and folder.Description= ''18''',@p3 output,@p4 output,@p5 output
select @p1, @p3, @p4, @p5

Если посмотреть на фактический план выполнения первого запроса, то SSMS говорит:
Преобразование типов в выражении (CONVERT(varchar(30),[obj].[id],0)) может повлиять на "CardinalityEstimate" в выборе плана запроса;
Преобразование типов в выражении (CONVERT(varchar(30),[obj].[id],0)) может повлиять на "CardinalityEstimate" в выборе плана запроса

При чём эти запросы могут выполняться так долго только в первый раз или если прошло более двух часов.
На что стоит посмотреть? И что можно сделать в такой ситуации?
Разработчики СЭД говорят что все проблемы от виртуальной инфраструктуры и что БД там размещать нельзя, перенесите на железо и всё будет хорошо, т.к. на виртуалке поведение MS SQL не предсказуемо. Но может можно сделать что-то в рамках текущей инфраструктуры?
18 май 16, 12:40    [19188128]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
WarAnt
Member

Откуда: Питер
Сообщений: 2423
slz386,

вы ни те запросы выложили, тут одни открытые курсоры, они могут и сутками висеть, никакого отношения к загрузке проца они не имеют, смотрите ожидания и вообще что происходит с сервером когда загрузка 100%, какие запросы в этот момент выполняются.
18 май 16, 12:51    [19188190]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
slz386
Member

Откуда:
Сообщений: 11
WarAnt,

Запросы выше и есть то, что выполняется когда пиковые нагрузки(когда много активных пользователей).
Идёт много таких запросов от разных пользователей(только для каждого со своими параметрами).
Т.е. к примеру пользователь заходит в СЭД, выполняются вышеприведённые запросы, и он ждёт всё это время пока прогрузится информация в окошке его клиентского приложения.
18 май 16, 13:05    [19188241]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
TaPaK
Member

Откуда: Kiev
Сообщений: 6801
slz386,
автор
При чём эти запросы могут выполняться так долго только в первый раз или если прошло более двух часов.

судя по всему нагрузка связана с построением кеша планов, и на выходных вы или перегружаете или чистите кеш... Может кто сообразительнее подтвердит/опровергнет
18 май 16, 13:11    [19188264]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
AlanDenton
Member [скрыт]

Откуда:
Сообщений: 1004
slz386, выложите результаты запроса: https://habrahabr.ru/post/216309/
18 май 16, 13:23    [19188341]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
WarAnt
Member

Откуда: Питер
Сообщений: 2423
slz386,

что вернет этот запрос?
use master 
select top 20 
	convert(varchar(20), last_execution_time, 120) last_exec_time,
	total_worker_time/execution_count CPUTime, 
	case when left (st.text, 30) like '%create%'
then left(ltrim(replace(replace(replace(replace(replace(
		left(st.text, 60),char(13),''),char(10),''),char(9),''),'create',''),'  ', ' ')),
		charindex(' ', ltrim(replace(replace(replace(replace(replace(
		left(st.text, 60),char(13),''),char(10),''),char(9),''),'create',''),'  ', ' ')), 15))
	else '' end object,
	SUBSTRING(st.text, (qs.statement_start_offset/2)+1,
	((CASE qs.statement_end_offset
	WHEN -1 THEN DATALENGTH(st.text)
	ELSE qs.statement_end_offset
	END - qs.statement_start_offset)/2) + 1) AS statement_text
	from sys.dm_exec_query_stats AS qs
		CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st 
where last_execution_time > getdate()-2
	order by total_worker_time/execution_count desc
18 май 16, 13:29    [19188380]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
Владислав Колосов
Member

Откуда:
Сообщений: 8316
slz386,

У вас же виртуальные ядра, убедитесь, что никто не "отжимает" физические у ВМ. Такое сплошь и рядом.
18 май 16, 13:37    [19188417]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
slz386
Member

Откуда:
Сообщений: 11
AlanDenton,

+
WaitTypeWait_SResource_SSignal_SWaitCountPercentageAvgWait_SAvgRes_SAvgSig_S
TRACEWRITE115980.58115967.3513.2339079295.200.29680.29670.0000
SOS_SCHEDULER_YIELD1554.469.031545.4365042951.280.00020.00000.0002
SOS_SCHEDULER_YIELD1554.469.031545.4365042981.280.00020.00000.0002
ASYNC_NETWORK_IO243.53241.651.88187500.200.01300.01290.0001
PAGEIOLATCH_SH147.25146.960.29474300.120.00310.00310.0000
BACKUPTHREAD118.91118.780.1323480.100.05060.05060.0001
WRITELOG58.7154.933.79385420.050.00150.00140.0001
BACKUPBUFFER56.5554.701.84264980.050.00210.00210.0001
ASYNC_IO_COMPLETION51.1951.180.011540.040.33240.33230.0001
ASYNC_IO_COMPLETION51.1951.180.011540.040.33240.33230.0001
PAGEIOLATCH_EX40.4140.350.0685020.030.00480.00470.0000
PAGEIOLATCH_EX40.4140.350.0685020.030.00480.00470.0000
LCK_M_X40.2740.270.00240.031.67781.67770.0000
LCK_M_X40.2740.270.00240.031.67781.67770.0000
LCK_M_S28.3928.380.021010.020.28110.28090.0002
LCK_M_S28.3928.380.021010.020.28110.28090.0002
IO_COMPLETION28.2828.150.13249720.020.00110.00110.0000
IO_COMPLETION28.2828.150.13249750.020.00110.00110.0000
LATCH_EX15.0511.293.76117320.010.00130.00100.0003
LATCH_EX15.0511.293.76117320.010.00130.00100.0003
LATCH_EX15.0511.293.76117320.010.00130.00100.0003
PREEMPTIVE_OS_DELETESECURITYCONTEXT12.1812.180.00771820.010.00020.00020.0000
PREEMPTIVE_OS_DELETESECURITYCONTEXT12.1812.180.00771820.010.00020.00020.0000
PREEMPTIVE_OS_DELETESECURITYCONTEXT12.1812.180.00771820.010.00020.00020.0000
PAGEIOLATCH_UP7.687.660.0113570.010.00570.00560.0000
PAGEIOLATCH_UP7.687.660.0113570.010.00570.00560.0000
PAGEIOLATCH_UP7.687.660.0113570.010.00570.00560.0000
LCK_M_IS6.706.690.011310.010.05110.05100.0001
LCK_M_IS6.706.690.011310.010.05110.05100.0001
LCK_M_IS6.706.690.011310.010.05110.05100.0001
PREEMPTIVE_OS_WRITEFILEGATHER6.376.370.00150.010.42470.42470.0000
PREEMPTIVE_OS_WRITEFILEGATHER6.376.370.00150.010.42470.42470.0000
PREEMPTIVE_OS_WRITEFILEGATHER6.376.370.00150.010.42470.42470.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS5.895.890.00775300.000.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS5.895.890.00775300.000.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS5.895.890.00775300.000.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS5.895.890.00775300.000.00010.00010.0000
PAGELATCH_EX5.621.024.60711090.000.00010.00000.0001
PAGELATCH_EX5.621.024.60711090.000.00010.00000.0001
PAGELATCH_EX5.621.024.60711090.000.00010.00000.0001
PAGELATCH_EX5.621.024.60711090.000.00010.00000.0001
PREEMPTIVE_OS_LIBRARYOPS5.055.050.0010.005.04905.04900.0000
PREEMPTIVE_OS_LIBRARYOPS5.055.050.0010.005.04905.04900.0000
PREEMPTIVE_OS_LIBRARYOPS5.055.050.0010.005.04905.04900.0000
PREEMPTIVE_OS_LIBRARYOPS5.055.050.0010.005.04905.04900.0000
PREEMPTIVE_OS_GENERICOPS4.814.810.00220.000.21850.21850.0000
PREEMPTIVE_OS_GENERICOPS4.814.810.00220.000.21850.21850.0000
PREEMPTIVE_OS_GENERICOPS4.814.810.00220.000.21850.21850.0000
PREEMPTIVE_OS_GENERICOPS4.814.810.00220.000.21850.21850.0000
PREEMPTIVE_OS_PIPEOPS4.364.360.0010.004.35904.35900.0000
PREEMPTIVE_OS_PIPEOPS4.364.360.0010.004.35904.35900.0000
PREEMPTIVE_OS_PIPEOPS4.364.360.0010.004.35904.35900.0000
PREEMPTIVE_OS_PIPEOPS4.364.360.0010.004.35904.35900.0000
PREEMPTIVE_OS_REVERTTOSELF4.184.180.00760590.000.00010.00010.0000
PREEMPTIVE_OS_REVERTTOSELF4.184.180.00760590.000.00010.00010.0000
PREEMPTIVE_OS_REVERTTOSELF4.184.180.00760590.000.00010.00010.0000
PREEMPTIVE_OS_REVERTTOSELF4.184.180.00760590.000.00010.00010.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES3.823.820.00758790.000.00010.00010.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES3.823.820.00758790.000.00010.00010.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES3.823.820.00758790.000.00010.00010.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES3.823.820.00758790.000.00010.00010.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES3.823.820.00758790.000.00010.00010.0000
MSQL_XP3.543.540.009750.000.00360.00360.0000
MSQL_XP3.543.540.009750.000.00360.00360.0000
MSQL_XP3.543.540.009750.000.00360.00360.0000
MSQL_XP3.543.540.009750.000.00360.00360.0000
MSQL_XP3.543.540.009750.000.00360.00360.0000
PREEMPTIVE_OS_WRITEFILE3.453.450.0014880.000.00230.00230.0000
PREEMPTIVE_OS_WRITEFILE3.453.450.0014880.000.00230.00230.0000
PREEMPTIVE_OS_WRITEFILE3.453.450.0014880.000.00230.00230.0000
PREEMPTIVE_OS_WRITEFILE3.453.450.0014880.000.00230.00230.0000
PREEMPTIVE_OS_WRITEFILE3.453.450.0014880.000.00230.00230.0000
CMEMTHREAD3.450.063.39160480.000.00020.00000.0002
CMEMTHREAD3.450.063.39160480.000.00020.00000.0002
CMEMTHREAD3.450.063.39160480.000.00020.00000.0002
CMEMTHREAD3.450.063.39160480.000.00020.00000.0002
CMEMTHREAD3.450.063.39160480.000.00020.00000.0002
WRITE_COMPLETION2.342.300.043410.000.00690.00670.0001
WRITE_COMPLETION2.342.300.043410.000.00690.00670.0001
WRITE_COMPLETION2.342.300.043410.000.00690.00670.0001
WRITE_COMPLETION2.342.300.043410.000.00690.00670.0001
WRITE_COMPLETION2.342.300.043410.000.00690.00670.0001
FFT_RECOVERY1.861.850.01110.000.16930.16830.0010
FFT_RECOVERY1.861.850.01110.000.16930.16830.0010
FFT_RECOVERY1.861.850.01110.000.16930.16830.0010
FFT_RECOVERY1.861.850.01110.000.16930.16830.0010
FFT_RECOVERY1.861.850.01110.000.16930.16830.0010
FFT_RECOVERY1.861.850.01110.000.16930.16830.0010
PREEMPTIVE_OS_DECRYPTMESSAGE1.551.550.00772450.000.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE1.551.550.00772450.000.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE1.551.550.00772450.000.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE1.551.550.00772450.000.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE1.551.550.00772450.000.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE1.551.550.00772450.000.00000.00000.0000
PREEMPTIVE_OS_REPORTEVENT1.441.440.0015740.000.00090.00090.0000
PREEMPTIVE_OS_REPORTEVENT1.441.440.0015740.000.00090.00090.0000
PREEMPTIVE_OS_REPORTEVENT1.441.440.0015740.000.00090.00090.0000
PREEMPTIVE_OS_REPORTEVENT1.441.440.0015740.000.00090.00090.0000
PREEMPTIVE_OS_REPORTEVENT1.441.440.0015740.000.00090.00090.0000
PREEMPTIVE_OS_REPORTEVENT1.441.440.0015740.000.00090.00090.0000
LCK_M_SCH_M1.441.360.081280.000.01130.01060.0007
LCK_M_SCH_M1.441.360.081280.000.01130.01060.0007
LCK_M_SCH_M1.441.360.081280.000.01130.01060.0007
LCK_M_SCH_M1.441.360.081280.000.01130.01060.0007
LCK_M_SCH_M1.441.360.081280.000.01130.01060.0007
LCK_M_SCH_M1.441.360.081280.000.01130.01060.0007
PREEMPTIVE_OS_FILEOPS1.351.350.0016480.000.00080.00080.0000
PREEMPTIVE_OS_FILEOPS1.351.350.0016480.000.00080.00080.0000
PREEMPTIVE_OS_FILEOPS1.351.350.0016480.000.00080.00080.0000
PREEMPTIVE_OS_FILEOPS1.351.350.0016480.000.00080.00080.0000
PREEMPTIVE_OS_FILEOPS1.351.350.0016480.000.00080.00080.0000
PREEMPTIVE_OS_FILEOPS1.351.350.0016480.000.00080.00080.0000
PAGELATCH_UP1.190.540.65290390.000.00000.00000.0000
PAGELATCH_UP1.190.540.65290390.000.00000.00000.0000
PAGELATCH_UP1.190.540.65290390.000.00000.00000.0000
PAGELATCH_UP1.190.540.65290390.000.00000.00000.0000
PAGELATCH_UP1.190.540.65290390.000.00000.00000.0000
PAGELATCH_UP1.190.540.65290390.000.00000.00000.0000
PAGELATCH_UP1.190.540.65290390.000.00000.00000.0000
PAGELATCH_SH1.170.210.95286500.000.00000.00000.0000
PAGELATCH_SH1.170.210.95286500.000.00000.00000.0000
PAGELATCH_SH1.170.210.95286500.000.00000.00000.0000
PAGELATCH_SH1.170.210.95286500.000.00000.00000.0000
PAGELATCH_SH1.170.210.95286500.000.00000.00000.0000
PAGELATCH_SH1.170.210.95286500.000.00000.00000.0000
PAGELATCH_SH1.170.210.95286500.000.00000.00000.0000
SQLTRACE_FILE_BUFFER1.041.040.00170.000.06130.06130.0000
SQLTRACE_FILE_BUFFER1.041.040.00170.000.06130.06130.0000
SQLTRACE_FILE_BUFFER1.041.040.00170.000.06130.06130.0000
SQLTRACE_FILE_BUFFER1.041.040.00170.000.06130.06130.0000
SQLTRACE_FILE_BUFFER1.041.040.00170.000.06130.06130.0000
SQLTRACE_FILE_BUFFER1.041.040.00170.000.06130.06130.0000
SQLTRACE_FILE_BUFFER1.041.040.00170.000.06130.06130.0000
LCK_M_SCH_S0.930.930.00160.000.05800.05790.0001
LCK_M_SCH_S0.930.930.00160.000.05800.05790.0001
LCK_M_SCH_S0.930.930.00160.000.05800.05790.0001
LCK_M_SCH_S0.930.930.00160.000.05800.05790.0001
LCK_M_SCH_S0.930.930.00160.000.05800.05790.0001
LCK_M_SCH_S0.930.930.00160.000.05800.05790.0001
LCK_M_SCH_S0.930.930.00160.000.05800.05790.0001
LATCH_SH0.670.500.1739440.000.00020.00010.0000
LATCH_SH0.670.500.1739440.000.00020.00010.0000
LATCH_SH0.670.500.1739440.000.00020.00010.0000
LATCH_SH0.670.500.1739440.000.00020.00010.0000
LATCH_SH0.670.500.1739440.000.00020.00010.0000
LATCH_SH0.670.500.1739440.000.00020.00010.0000
LATCH_SH0.670.500.1739440.000.00020.00010.0000
LCK_M_U0.660.650.0180.000.08230.08160.0006
LCK_M_U0.660.650.0180.000.08230.08160.0006
LCK_M_U0.660.650.0180.000.08230.08160.0006
LCK_M_U0.660.650.0180.000.08230.08160.0006
LCK_M_U0.660.650.0180.000.08230.08160.0006
LCK_M_U0.660.650.0180.000.08230.08160.0006
LCK_M_U0.660.650.0180.000.08230.08160.0006
PREEMPTIVE_OS_CRYPTOPS0.560.560.0031870.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTOPS0.560.560.0031870.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTOPS0.560.560.0031870.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTOPS0.560.560.0031870.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTOPS0.560.560.0031870.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTOPS0.560.560.0031870.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTOPS0.560.560.0031870.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTOPS0.560.560.0031870.000.00020.00020.0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0.280.280.0050.000.05560.05560.0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0.280.280.0050.000.05560.05560.0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0.280.280.0050.000.05560.05560.0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0.280.280.0050.000.05560.05560.0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0.280.280.0050.000.05560.05560.0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0.280.280.0050.000.05560.05560.0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0.280.280.0050.000.05560.05560.0000
PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID0.280.280.0050.000.05560.05560.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.260.260.007950.000.00030.00030.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.260.260.007950.000.00030.00030.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.260.260.007950.000.00030.00030.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.260.260.007950.000.00030.00030.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.260.260.007950.000.00030.00030.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.260.260.007950.000.00030.00030.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.260.260.007950.000.00030.00030.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.260.260.007950.000.00030.00030.0000
PREEMPTIVE_OS_QUERYREGISTRY0.240.240.0069310.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.240.240.0069310.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.240.240.0069310.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.240.240.0069310.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.240.240.0069310.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.240.240.0069310.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.240.240.0069310.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.240.240.0069310.000.00000.00000.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.240.240.0010420.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.240.240.0010420.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.240.240.0010420.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.240.240.0010420.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.240.240.0010420.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.240.240.0010420.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.240.240.0010420.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.240.240.0010420.000.00020.00020.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_COMOPS0.230.230.0010.000.22900.22900.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.200.200.0020630.000.00010.00010.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_DOMAINSERVICESOPS0.170.170.0010.000.17100.17100.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_CREATEFILE0.130.130.005800.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
PREEMPTIVE_OS_GETVOLUMEPATHNAME0.120.120.002540.000.00050.00050.0000
LOGBUFFER0.120.060.052200.000.00050.00030.0002
LOGBUFFER0.120.060.052200.000.00050.00030.0002
LOGBUFFER0.120.060.052200.000.00050.00030.0002
LOGBUFFER0.120.060.052200.000.00050.00030.0002
LOGBUFFER0.120.060.052200.000.00050.00030.0002
LOGBUFFER0.120.060.052200.000.00050.00030.0002
LOGBUFFER0.120.060.052200.000.00050.00030.0002
LOGBUFFER0.120.060.052200.000.00050.00030.0002
LOGBUFFER0.120.060.052200.000.00050.00030.0002
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_FLUSHFILEBUFFERS0.120.120.001580.000.00070.00070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_LOADLIBRARY0.090.090.0030.000.03070.03070.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
PREEMPTIVE_OS_GETFILEATTRIBUTES0.090.090.003900.000.00020.00020.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
SQLTRACE_FILE_READ_IO_COMPLETION0.080.080.00240.000.00350.00350.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.070.070.009430.000.00010.00010.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_OS_DEVICEIOCONTROL0.070.070.002200.000.00030.00030.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
PREEMPTIVE_FILESIZEGET0.060.060.001220.000.00050.00050.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
CXROWSET_SYNC0.040.030.014290.000.00010.00010.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE0.040.040.007950.000.00000.00000.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.030.030.00760.000.00040.00040.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.020.020.002020.000.00010.00010.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PREEMPTIVE_XE_TARGETINIT0.020.020.0030.000.00630.00630.0000
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PERFORMANCE_COUNTERS_RWLOCK0.020.010.00140.000.00110.00090.0003
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_OLEDBOPS0.020.020.002500.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PREEMPTIVE_COM_COCREATEINSTANCE0.010.010.001100.000.00010.00010.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PARALLEL_BACKUP_QUEUE0.010.010.0020.000.00600.00600.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
PREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINT0.010.010.00620.000.00020.00020.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
LCK_M_IX0.010.010.0010.000.00900.00900.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
THREADPOOL0.010.010.0060.000.00130.00130.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
DAC_INIT0.010.010.0010.000.00600.00600.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
PREEMPTIVE_OS_CLOSEHANDLE0.010.010.001560.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
IO_AUDIT_MUTEX0.000.000.001970.000.00000.00000.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_ENCRYPTMESSAGE0.000.000.00750.000.00010.00010.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETPROCADDRESS0.000.000.009750.000.00000.00000.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
PREEMPTIVE_OS_GETDISKFREESPACE0.000.000.00440.000.00010.00010.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
QDS_TASK_START0.000.000.0020.000.00100.00100.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.00832120.000.00000.00000.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_XE_SESSIONCOMMIT0.000.000.0080.000.00010.00010.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
PREEMPTIVE_CLOSEBACKUPVDIDEVICE0.000.000.001100.000.00000.00000.0000
18 май 16, 13:55    [19188528]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
LSV
Member [заблокирован]

Откуда: Киев
Сообщений: 30817
Перезапускать скл-сервер пробовали ?
Нередко помогает.
18 май 16, 13:58    [19188553]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
TaPaK
Member

Откуда: Kiev
Сообщений: 6801
LSV
Перезапускать скл-сервер пробовали ?
Нередко помогает.

сервера с планом 24/7 вздрогнули от вашего решения
18 май 16, 13:59    [19188574]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
slz386
Member

Откуда:
Сообщений: 11
WarAnt,

не разобрался как нормально вставить его в виде таблицы, поэтому приложил файл

К сообщению приложен файл (Результат запроса.xlsx - 18Kb) cкачать
18 май 16, 14:00    [19188582]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
TaPaK
Member

Откуда: Kiev
Сообщений: 6801
slz386,
попробуйте
http://blog.sqlauthority.com/2011/10/20/sql-server-tracewrite-wait-type-wait-related-to-buffer-and-resolution/
18 май 16, 14:00    [19188583]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
LSV
Member [заблокирован]

Откуда: Киев
Сообщений: 30817
TaPaK
LSV
Перезапускать скл-сервер пробовали ?
Нередко помогает.
сервера с планом 24/7 вздрогнули от вашего решения
Оно то так, но это самое простое, что можно сделать, особенно если ситуация уже критическая. :)
18 май 16, 14:30    [19188810]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
slz386
Member

Откуда:
Сообщений: 11
TaPaK,

Нет, ни чего кроме каждодневных процедур(статистики, индексы, бэкапы) на выходных не производилось
18 май 16, 14:36    [19188861]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
slz386
Member

Откуда:
Сообщений: 11
TaPaK,

Попробовал, но ни чего не поменялось
18 май 16, 14:37    [19188874]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
slz386
Member

Откуда:
Сообщений: 11
LSV,

Сервер БД перезагружался когда ядра ему были добавлены.
18 май 16, 14:38    [19188881]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
flexgen
Member

Откуда: Город на песке
Сообщений: 830
slz386
TaPaK,

Нет, ни чего кроме каждодневных процедур(статистики, индексы, бэкапы) на выходных не производилось


А планы проблемных запросов смотрел?
18 май 16, 22:32    [19191129]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
flexgen
Member

Откуда: Город на песке
Сообщений: 830
slz386,

Посмотри вот этот блог - SOS_SCHEDULER_YIELD, мне кажется WaitCount для этого эвента высоковат.
18 май 16, 22:43    [19191163]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
o-o
Guest
офигеть просто, какой процент у TRACEWRITE.
вы там что, умониторили сервер со всех сторон?
кошмар.
в sys.traces что?
18 май 16, 23:00    [19191226]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
misha333
Guest
я не по теме но очень нужна помощь если кто знает

есть таблица должников столбцы "кто" "сумма" "в долларах"
создал форму и в форму добавил поле...в поле указал выражение =Sum([сумма])
то есть понятно что в это поле будет общая сумма столбца

вопрос? как сделать чтобы суммировалось только выбранное
например

таблица

кто ................сумма............в долларах.................статус флажок расплатился
1фирма ............ 6000..............1 ...................................да
2фирма ............. 6000 .............1 ..................................нет
3фирма ..............6000 .............1 ................................. нет

видно что 1фирма рассчиталась...и надо сделать так чтобы в форме это сума не учитывалась
а в поле складывалась только общая сума тех должников кто не рассчитался
19 май 16, 00:39    [19191418]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
Mind
Member

Откуда: Лучший город на Земле
Сообщений: 2322
misha333
я не по теме но очень нужна помощь если кто знает
А не пойти бы вам лесом со своим Аксесом!
19 май 16, 02:14    [19191505]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
misha333
Guest
Mind,
Я так же сказал когда взялся за него легче на c++ сделать
но нужно именно в access
19 май 16, 09:56    [19192046]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
Владислав Колосов
Member

Откуда:
Сообщений: 8316
misha333,

К.О. говорит: найдите все суммы и исключите те, которые соответствуют критерию исключения. Как это реализовать средствами аксеса - спрашивайте на форуме по аксесу или , еще, лучше, читайте справку по запросам.
19 май 16, 10:57    [19192437]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
Agapov_stas
Member

Откуда:
Сообщений: 402
misha333, вопрос явно задан не в том разделе.
Однако, по сабжу:
Или использовать выражение =DSum("сумма";"[таблица должников]";"[статус флажок расплатился]=false").
Или в качестве источника для формы использовать запрос, в котором, опять таки, или использовать DSum() или запрос типа:
SELECT кто, сумма, [в долларах], [статус флажок расплатился], (SELECT Sum(сумма) FROM [таблица должников] WHERE [статус флажок расплатился]=false) as Summ
19 май 16, 11:59    [19192820]     Ответить | Цитировать Сообщить модератору
 Re: Резкое падение производительности  [new]
slz386
Member

Откуда:
Сообщений: 11
flexgen,

flexgen
slz386
TaPaK,

Нет, ни чего кроме каждодневных процедур(статистики, индексы, бэкапы) на выходных не производилось


А планы проблемных запросов смотрел?


Да, они километровые(какие и были), за счёт того что обращаются к не индексированным вьюшкам...

+ Самый тяжелый запрос
select count(*) 
from ( select o1.ID from [LSDBO].[Attrib_Value_T_v] a 
inner join [LSDBO].[object_reference_view] o on o.ID = a.Object_ID 
inner join [LSDBO].[Attrib_Value_N_v] a1 on a1.Object_ID = o.id and a1.Attrib_ID = 100000004300041 /*Атрибуты - ID сопоставленного пользователя*/ 
left join [LSDBO].[Attrib_Value_T_v] a2 on a2.Object_ID = o.id and a2.Attrib_ID = 100000023313856 /*Атрибуты - Дата согласования*/
left join [LSDBO].[tree_link_view] t on t.link_id = o.id and t.link_type_id = 2130000003 /*Согласование*/ 
left join [LSDBO].[object_reference_view] o1 on o1.ID = t.parent_id 
inner join lsdbo.wf_attachments_view at on at.doc_id = cast(o1.ID as varchar) 
inner join lsdbo.wf_mail_docs_v md on md.attachment_id = at.id inner join lsdbo.wf_mail_v mail on md.mail_id = mail.id 
inner join lsdbo.wf_mail_to_v mt on mt.mail_id = mail.id 
inner join [LSDBO].[wf_mail_and_map_v] mm on mm.id = mail.id 
where a.Attrib_ID = 100000061000005 /*Атрибуты - Срок исполнения*/ 
and o.Type_ID = 100000023213856/*Типы объектов - Согласующий */ 
and a.Value <= CONVERT (datetime, GETDATE()+1, 104) 
and a2.Value is null and a1.Value =0 and mt.state in ('N', 'R', 'W') 
and mt.user_to_id = a1.value and mm.map_nodes_userdata = 35 
and mm.task_end_date is null 
union
select distinct o.ID 
from [LSDBO].[Attrib_Value_T_v] a 
inner join [LSDBO].[object_reference_view] o on o.ID = a.Object_ID 
inner join [LSDBO].[Attrib_Value_N_v] a1 on a1.Object_ID = o.id and a1.Attrib_ID = 100000012500005 /*Атрибуты - ID сопоставленного пользователя*/ 
inner join [LSDBO].[Attrib_Value_S_v] a3 on a3.Object_ID = o.id and a3.Attrib_ID = 100000000404016 /*Атрибуты - Статус*/ 
left join [LSDBO].[Attrib_Value_S_v] a4 on a4.Object_ID = o.id and a4.Attrib_ID = 100000014054997 /*Атрибуты - Статус поручения*/
left join [LSDBO].[Attrib_Value_T_v] a5 on a5.Object_ID = o.id and a5.Attrib_ID = 100000061200005 /*Атрибуты - Фактическая дата выполнения*/ 
where a.Attrib_ID = 100000061000005 /*Атрибуты - Срок исполнения*/ 
and o.Type_ID = 100000057000005 /*Типы объектов - Поручение*/ 
and a.Value <= CONVERT (date, GETDATE()) and a3.Value0 <>'Выполнено' and a3.Value0 <>'Отменено' 
and a3.Value0 is not null and (a4.Value0 <>'Выполнено' or ( a4.Value0 is Null and a5.Value is Null)) 
and (select count(*) from [LSDBO].[wf_attachments_view] at 
inner join [LSDBO].[wf_map_doc_tree_view] md on md.ID = at.map_doc_tree_id 
inner join [LSDBO].[wf_mail_and_map_v] mm on mm.map_id = md.map_id 
where [doc_id] = cast( o.ID as varchar)) > 0 and a1.Value = 0)as q

план в приложении.
Но вся суть в том, что до этого эти запросы выполнялись в разы быстрее...

По SOS_SCHEDULER_YIELD пытался разобраться что всё это значит, но что-то пока не вкурил
+
SELECT scheduler_id, current_tasks_count, runnable_tasks_count, work_queue_count, pending_disk_io_count
FROM sys.dm_os_schedulers
WHERE scheduler_id < 255
GO

scheduler_idcurrent_tasks_countrunnable_tasks_countwork_queue_countpending_disk_io_count
03000
16000
22000
34000
43000
53000
64000
75000


Т.е. вроде всё в порядке я так понимаю...

На всякий случай утром сбросил статистику ожиданий и снова запустил тот запрос
+
WaitTypeWait_SResource_SSignal_SWaitCountPercentageAvgWait_SAvgRes_SAvgSig_S
SOS_SCHEDULER_YIELD392.712.36390.35160752153.410.00020.00000.0002
PREEMPTIVE_OS_AUTHENTICATIONOPS109.25109.250.0010276414.860.00110.00110.0000
PREEMPTIVE_OS_AUTHENTICATIONOPS109.25109.250.0010276414.860.00110.00110.0000
TRACEWRITE103.37103.370.005214.061.98791.98790.0000
TRACEWRITE103.37103.370.005214.061.98791.98790.0000
TRACEWRITE103.37103.370.005214.061.98791.98790.0000
ASYNC_NETWORK_IO98.7390.548.1911110513.430.00090.00080.0001
ASYNC_NETWORK_IO98.7390.548.1911110513.430.00090.00080.0001
ASYNC_NETWORK_IO98.7390.548.1911110513.430.00090.00080.0001
PAGEIOLATCH_EX6.126.120.008860.830.00690.00690.0000
PAGEIOLATCH_EX6.126.120.008860.830.00690.00690.0000
PAGEIOLATCH_EX6.126.120.008860.830.00690.00690.0000
PAGEIOLATCH_EX6.126.120.008860.830.00690.00690.0000
WRITELOG5.995.490.5047440.810.00130.00120.0001
WRITELOG5.995.490.5047440.810.00130.00120.0001
WRITELOG5.995.490.5047440.810.00130.00120.0001
WRITELOG5.995.490.5047440.810.00130.00120.0001
IO_COMPLETION3.172.610.5649820.430.00060.00050.0001
IO_COMPLETION3.172.610.5649820.430.00060.00050.0001
IO_COMPLETION3.172.610.5649820.430.00060.00050.0001
IO_COMPLETION3.172.610.5649820.430.00060.00050.0001
IO_COMPLETION3.172.610.5649850.430.00060.00050.0001
LCK_M_SCH_M2.932.930.0010.402.93102.93100.0000
LCK_M_SCH_M2.932.930.0010.402.93102.93100.0000
LCK_M_SCH_M2.932.930.0010.402.93102.93100.0000
LCK_M_SCH_M2.932.930.0010.402.93102.93100.0000
LCK_M_SCH_M2.932.930.0010.402.93102.93100.0000
LCK_M_SCH_M2.932.930.0010.402.93102.93100.0000
PREEMPTIVE_OS_DELETESECURITYCONTEXT2.602.600.00173390.350.00010.00010.0000
PREEMPTIVE_OS_DELETESECURITYCONTEXT2.602.600.00173390.350.00010.00010.0000
PREEMPTIVE_OS_DELETESECURITYCONTEXT2.602.600.00173390.350.00010.00010.0000
PREEMPTIVE_OS_DELETESECURITYCONTEXT2.602.600.00173390.350.00010.00010.0000
PREEMPTIVE_OS_DELETESECURITYCONTEXT2.602.600.00173390.350.00010.00010.0000
PREEMPTIVE_OS_DELETESECURITYCONTEXT2.602.600.00173390.350.00010.00010.0000
LCK_M_IS2.392.390.0010.322.38702.38700.0000
LCK_M_IS2.392.390.0010.322.38702.38700.0000
LCK_M_IS2.392.390.0010.322.38702.38700.0000
LCK_M_IS2.392.390.0010.322.38702.38700.0000
LCK_M_IS2.392.390.0010.322.38702.38700.0000
LCK_M_IS2.392.390.0010.322.38702.38700.0000
LCK_M_IS2.392.390.0010.322.38702.38700.0000
LCK_M_S1.941.940.00210.260.09260.09240.0001
LCK_M_S1.941.940.00210.260.09260.09240.0001
LCK_M_S1.941.940.00210.260.09260.09240.0001
LCK_M_S1.941.940.00210.260.09260.09240.0001
LCK_M_S1.941.940.00210.260.09260.09240.0001
LCK_M_S1.941.940.00210.260.09260.09240.0001
LCK_M_S1.941.940.00210.260.09260.09240.0001
PREEMPTIVE_OS_AUTHORIZATIONOPS1.131.130.00170220.150.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS1.131.130.00170220.150.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS1.131.130.00170220.150.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS1.131.130.00170220.150.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS1.131.130.00170220.150.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS1.131.130.00170220.150.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS1.131.130.00170220.150.00010.00010.0000
PREEMPTIVE_OS_AUTHORIZATIONOPS1.131.130.00170220.150.00010.00010.0000
PAGELATCH_EX0.920.030.8998070.120.00010.00000.0001
PAGELATCH_EX0.920.030.8998070.120.00010.00000.0001
PAGELATCH_EX0.920.030.8998070.120.00010.00000.0001
PAGELATCH_EX0.920.030.8998070.120.00010.00000.0001
PAGELATCH_EX0.920.030.8998070.120.00010.00000.0001
PAGELATCH_EX0.920.030.8998070.120.00010.00000.0001
PAGELATCH_EX0.920.030.8998070.120.00010.00000.0001
PAGELATCH_EX0.920.030.8998070.120.00010.00000.0001
PREEMPTIVE_OS_REVERTTOSELF0.790.790.00169960.110.00000.00000.0000
PREEMPTIVE_OS_REVERTTOSELF0.790.790.00169960.110.00000.00000.0000
PREEMPTIVE_OS_REVERTTOSELF0.790.790.00169960.110.00000.00000.0000
PREEMPTIVE_OS_REVERTTOSELF0.790.790.00169960.110.00000.00000.0000
PREEMPTIVE_OS_REVERTTOSELF0.790.790.00169960.110.00000.00000.0000
PREEMPTIVE_OS_REVERTTOSELF0.790.790.00169960.110.00000.00000.0000
PREEMPTIVE_OS_REVERTTOSELF0.790.790.00169960.110.00000.00000.0000
PREEMPTIVE_OS_REVERTTOSELF0.790.790.00169960.110.00000.00000.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES0.780.780.00169960.110.00000.00000.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES0.780.780.00169960.110.00000.00000.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES0.780.780.00169960.110.00000.00000.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES0.780.780.00169960.110.00000.00000.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES0.780.780.00169960.110.00000.00000.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES0.780.780.00169960.110.00000.00000.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES0.780.780.00169960.110.00000.00000.0000
PREEMPTIVE_OS_QUERYCONTEXTATTRIBUTES0.780.780.00169960.110.00000.00000.0000
PAGEIOLATCH_SH0.580.580.00930.080.00620.00620.0000
PAGEIOLATCH_SH0.580.580.00930.080.00620.00620.0000
PAGEIOLATCH_SH0.580.580.00930.080.00620.00620.0000
PAGEIOLATCH_SH0.580.580.00930.080.00620.00620.0000
PAGEIOLATCH_SH0.580.580.00930.080.00620.00620.0000
PAGEIOLATCH_SH0.580.580.00930.080.00620.00620.0000
PAGEIOLATCH_SH0.580.580.00930.080.00620.00620.0000
PAGEIOLATCH_SH0.580.580.00930.080.00620.00620.0000
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
CMEMTHREAD0.570.000.5710000.080.00060.00000.0006
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
PREEMPTIVE_OS_DECRYPTMESSAGE0.330.330.00170220.050.00000.00000.0000
CXPACKET0.330.280.055510.040.00060.00050.0001
CXPACKET0.330.280.055510.040.00060.00050.0001
CXPACKET0.330.280.055510.040.00060.00050.0001
CXPACKET0.330.280.055510.040.00060.00050.0001
CXPACKET0.330.280.055510.040.00060.00050.0001
CXPACKET0.330.280.055510.040.00060.00050.0001
CXPACKET0.330.280.055510.040.00060.00050.0001
CXPACKET0.330.280.055510.040.00060.00050.0001
CXPACKET0.330.280.055510.040.00060.00050.0001
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE0.130.130.0016520.020.00010.00010.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LCK_M_U0.130.130.0020.020.06550.06550.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
LATCH_SH0.090.060.038540.010.00010.00010.0000
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
PAGELATCH_SH0.060.010.066510.010.00010.00000.0001
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
LCK_M_X0.050.050.00120.010.00380.00380.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
PAGEIOLATCH_UP0.040.040.00360.010.00100.00100.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
MSQL_XP0.020.020.00260.000.00080.00080.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
LATCH_EX0.020.020.011900.000.00010.00010.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_LOOKUPACCOUNTSID0.020.020.0020.000.00900.00900.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_REPORTEVENT0.010.010.00400.000.00030.00030.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_QUERYREGISTRY0.010.010.004400.000.00000.00000.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY0.000.000.0080.000.00050.00050.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_WAITFORSINGLEOBJECT0.000.000.00210.000.00020.00020.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT0.000.000.00270.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_OS_CRYPTIMPORTKEY0.000.000.00170.000.00010.00010.0000
PREEMPTIVE_XE_CALLBACKEXECUTE0.000.000.0052870.000.00000.00000.0000

Ещё, на этом же сервере в другом инстансе работает oracle primavera(тоже на MS SQL 2014), но с ней таких проблем нет.
Попробовал восстановить БД из бэкапа к себе на локальную машину, и как ни странно эти запросы заработали быстрее...
19 май 16, 14:37    [19193848]     Ответить | Цитировать Сообщить модератору
Топик располагается на нескольких страницах: [1] 2   вперед  Ctrl      все
Все форумы / Microsoft SQL Server Ответить