Подвисание MSSQL при нескольких одновременных проведениях
Добрый день.
На тестовом сервере поднята 1С:ERP поверх MSSQL 2008. Во время обучения сотрудников при одновременном сохранении/проведении документов
внутреннего потребления/перемещения товаров система полностью зависает на 3 минуты. На сервере в это время процесс sqlservr.exe потребляет 100% процессора. Проблема внезапно появилась при количестве пользователей 13 человек, при меньшем не было. Все пользователи работают под одной учетной
записью.
В чем может быть проблема?
На тестовом сервере поднята 1С:ERP поверх MSSQL 2008. Во время обучения сотрудников при одновременном сохранении/проведении документов
внутреннего потребления/перемещения товаров система полностью зависает на 3 минуты. На сервере в это время процесс sqlservr.exe потребляет 100% процессора. Проблема внезапно появилась при количестве пользователей 13 человек, при меньшем не было. Все пользователи работают под одной учетной
записью.
В чем может быть проблема?
Ответы
Подписаться на ответы
Инфостарт бот
Сортировка:
Древо развёрнутое
Свернуть все
(1) 8Гб оперативки, HDD, виртуалка...
Простите, а кто вам сказал что на вашем железе ERP будет работать? Почему Вы вообще решили запускать ERP на этом железе?
Вы БП3.0 на нем запускали? Ну хоть что-то из новых конфигураций 1С (управляемые формы)?
Кажется что вы работали-работали на УТ10.3 и тут раз!
Просто мой опыт таков: промышленные SSD, 190-200Гб оперативы, база 150-200Гб, пользователей 50-150. И... более-менее, не сильно медленнее чем УПП на 150 пользователей на HDD на 64-90Гб оперативки.
Простите, а кто вам сказал что на вашем железе ERP будет работать? Почему Вы вообще решили запускать ERP на этом железе?
Вы БП3.0 на нем запускали? Ну хоть что-то из новых конфигураций 1С (управляемые формы)?
Кажется что вы работали-работали на УТ10.3 и тут раз!
Просто мой опыт таков: промышленные SSD, 190-200Гб оперативы, база 150-200Гб, пользователей 50-150. И... более-менее, не сильно медленнее чем УПП на 150 пользователей на HDD на 64-90Гб оперативки.
(12)
Profiler не установлен, а в SSMS в мониторе километровые тяжелые запросы вида:
Profiler не установлен, а в SSMS в мониторе километровые тяжелые запросы вида:
текст запроса |
|---|
| SEL ECT TOP 30
T1._Fld70006_TYPE, T1._Fld70006_RTRef, T1._Fld70006_RRRef, T1._Fld70015, T1._Fld70005, T1._Fld70000RRef, T1._Fld70004RRef, T1._Fld70002RRef, T1._Fld70010RRef, T1._Fld69999RRef, T1._Fld70009_TYPE, T1._Fld70009_RTRef, T1._Fld70009_RRRef, T1._Fld70012, T1._Fld70013, CASE WHEN T1._Fld70014 = 0x01 THEN 0.0 WHEN T1._Fld70015 = 0x01 THEN 1.0 ELSE 2.0 END, T1._Fld69998RRef, T1._Fld70006_TYPE + T1._Fld70006_RTRef, T1._Fld70003RRef, T1._Fld70001RRef, T1._Fld70007, CASE WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000002AF THEN CASE WHEN T2.Fld61501_ IS NOT NULL THEN 0x03 END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000003CB THEN CASE WHEN T21.Fld71158_ IS NOT NULL THEN 0x03 END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000395 THEN CASE WHEN T32.Fld61492_ IS NOT NULL THEN 0x03 END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000003CD THEN CASE WHEN T43.Fld71159_ IS NOT NULL THEN 0x03 END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000353 THEN CASE WHEN T52.Fld61503_ IS NOT NULL THEN 0x03 END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000421 THEN CASE WHEN T63.Fld71167_ IS NOT NULL THEN 0x05 END ELSE CAST(NULL AS BINARY(1)) END, CASE WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000002AF THEN T2.Fld61501_ WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000003CB THEN T21.Fld71158_ WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000395 THEN T32.Fld61492_ WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000003CD THEN T43.Fld71159_ WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000353 THEN T52.Fld61503_ WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000421 THEN CASE WHEN T63.Fld71167_ IS NOT NULL THEN 0.0 END ELSE CAST(NULL AS NUMERIC(10, 0)) END, CASE WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000002AF THEN CASE WHEN T2.Fld61501_ IS NOT NULL THEN N'' END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000003CB THEN CASE WHEN T21.Fld71158_ IS NOT NULL THEN N'' END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000395 THEN CASE WHEN T32.Fld61492_ IS NOT NULL THEN N'' END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000003CD THEN CASE WHEN T43.Fld71159_ IS NOT NULL THEN N'' END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000353 THEN CASE WHEN T52.Fld61503_ IS NOT NULL THEN N'' END WHEN T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000421 THEN T63.Fld71167_ ELSE CAST(NULL AS NVARCHAR(50)) END, ISNULL(CAST(T71._Description AS NVARCHAR(100)),N''), T1._Fld70010RRef FR OM dbo._InfoRg69997 T1 LEFT OUTER JOIN (SEL ECT T3._Fld21433RRef AS Fld21433RRef, T3._Fld21436RRef AS Fld21436RRef, T3._Fld21434RRef AS Fld21434RRef, T3._IDRRef AS IDRRef, T3._Fld2050 AS Fld2050_, T3._Fld61501 AS Fld61501_ FR OM dbo._Document687 T3 WHERE ((EXISTS(SEL ECT 0x01 AS Q_001_F_000_ FR OM dbo._Reference204 T4 INNER JOIN dbo._Reference139 T5 ON (((T4._Fld7105 = @P1) AND EXISTS(SEL ECT 0x01 AS Q_006_F_000_ FR OM dbo._InfoRg55530 T6 WHERE ((T6._Fld2050 = @P2)) AND ((T6._Fld55531_TYPE = 0x08 AND T6._Fld55531_RTRef = 0x000000CC AND T6._Fld55531_RRRef = T4._IDRRef) AND (T6._Fld55532RRef = T5._IDRRef)))) AND 0x0000008B = 0x0000008B AND T5._IDRRef IN (SEL ECT T7._Reference139_IDRRef AS Q_007_F_000RRef FR OM dbo._Reference139_VT5212 T7 INNER JOIN dbo._InfoRg54854 T8 ON ((T8._Fld54856_TYPE = 0x08 AND T8._Fld54856_RTRef = 0x0000017F AND T8._Fld54856_RRRef = @P3) AND (T8._Fld54855_TYPE = T7._Fld5214_TYPE AND T8._Fld54855_RTRef = T7._Fld5214_RTRef AND T8._Fld54855_RRRef = T7._Fld5214_RRRef)) WHERE ((T7._Fld2050 = @P4)) AND (T8._Fld2050 = @P5))) WHERE ((T5._Fld2050 = @P6)) AND ((0x08 <> 0x01) AND (0x08 <> 0x01) AND (CASE WHEN EXISTS(SEL ECT 0x01 AS Q_002_F_000_ FR OM dbo._InfoRg50049 T9 WHERE ((T9._Fld2050 = @P7)) AND ((T9._Fld50050RRef = T5._IDRRef) AND (T9._Fld50051_TYPE = 0x08 AND T9._Fld50051_RTRef = 0x0000021C AND T9._Fld50051_RRRef = T3._Fld21436RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SEL ECT 0x01 AS Q_003_F_000_ FR OM dbo._InfoRg50056 T10 WHERE ((T10._Fld2050 = @P8)) AND ((T10._Fld50057RRef = T5._IDRRef) AND T10._Fld50058_TYPE = 0x08 AND T10._Fld50058_RTRef = 0x0000021C AND (T10._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END) AND (0x08 <> 0x01) AND (CASE WHEN EXISTS(SEL ECT 0x01 AS Q_004_F_000_ FR OM dbo._InfoRg50049 T11 WHERE ((T11._Fld2050 = @P9)) AND ((T11._Fld50050RRef = T5._IDRRef) AND (T11._Fld50051_TYPE = 0x08 AND T11._Fld50051_RTRef = 0x000001EC AND T11._Fld50051_RRRef = T3._Fld21434RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SEL ECT 0x01 AS Q_005_F_000_ FR OM dbo._InfoRg50056 T12 WHERE ((T12._Fld2050 = @P10)) AND ((T12._Fld50057RRef = T5._IDRRef) AND T12._Fld50058_TYPE = 0x08 AND T12._Fld50058_RTRef = 0x000001EC AND (T12._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END))) OR EXISTS(SEL ECT 0x01 AS Q_001_F_000_ FR OM dbo._Reference204 T13 INNER JOIN dbo._InfoRg55530 T14 ON (((T13._Fld7105 = @P11) AND (T14._Fld55531_TYPE = 0x08 AND T14._Fld55531_RTRef = 0x000000CC AND T14._Fld55531_RRRef = T13._IDRRef)) AND 0x0000008B = 0x0000008B AND T14._Fld55532RRef IN (SEL ECT T15._Reference139_IDRRef AS Q_006_F_000RRef FR OM dbo._Reference139_VT5212 T15 INNER JOIN dbo._InfoRg54854 T16 ON ((T16._Fld54856_TYPE = 0x08 AND T16._Fld54856_RTRef = 0x0000017F AND T16._Fld54856_RRRef = @P12) AND (T16._Fld54855_TYPE = T15._Fld5214_TYPE AND T16._Fld54855_RTRef = T15._Fld5214_RTRef AND T16._Fld54855_RRRef = T15._Fld5214_RRRef)) WHERE ((T15._Fld2050 = @P13)) AND (T16._Fld2050 = @P14))) WHERE ((T14._Fld2050 = @P15)) AND ((0x08 <> 0x01) AND (CASE WHEN EXISTS(SEL ECT 0x01 AS Q_002_F_000_ FR OM dbo._InfoRg50049 T17 WHERE ((T17._Fld2050 = @P16)) AND ((T17._Fld50050RRef = T14._Fld55532RRef) AND (T17._Fld50051_TYPE = 0x08 AND T17._Fld50051_RTRef = 0x0000021C AND T17._Fld50051_RRRef = T3._Fld21436RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SEL ECT 0x01 AS Q_003_F_000_ FR OM dbo._InfoRg50056 T18 WHERE ((T18._Fld2050 = @P17)) AND ((T18._Fld50057RRef = T14._Fld55532RRef) AND T18._Fld50058_TYPE = 0x08 AND T18._Fld50058_RTRef = 0x0000021C AND (T18._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END) AND (0x08 <> 0x01) AND (CASE WHEN EXISTS(SEL ECT 0x01 AS Q_004_F_000_ FR OM dbo._InfoRg50049 T19 WHERE ((T19._Fld2050 = @P18)) AND ((T19._Fld50050RRef = T14._Fld55532RRef) AND (T19._Fld50051_TYPE = 0x08 AND T19._Fld50051_RTRef = 0x000001EC AND T19._Fld50051_RRRef = T3._Fld21434RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SEL ECT 0x01 AS Q_005_F_000_ FR OM dbo._InfoRg50056 T20 WHERE ((T20._Fld2050 = @P19)) AND ((T20._Fld50057RRef = T14._Fld55532RRef) AND T20._Fld50058_TYPE = 0x08 AND T20._Fld50058_RTRef = 0x000001EC AND (T20._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END))))) AND (T3._Fld2050 = @P20)) T2 ON T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000002AF AND T1._Fld70006_RRRef = T2.IDRRef LEFT OUTER JOIN (SEL ECT T22._Fld38216RRef AS Fld38216RRef, T22._Fld38218RRef AS Fld38218RRef, T22._IDRRef AS IDRRef, T22._Fld38219RRef AS Fld38219RRef, T22._Fld2050 AS Fld2050_, T22._Fld71158 AS Fld71158_, T22._Fld38277RRef AS Fld38277RRef FR OM dbo._Document971 T22 WHERE ((EXISTS(SEL ECT 0x01 AS Q_001_F_000_ FR OM dbo._Reference204 T23 INNER JOIN dbo._Reference139 T24 ON (((T23._Fld7105 = @P21) AND EXISTS(SEL ECT 0x01 AS Q_006_F_000_ FR OM dbo._InfoRg55530 T25 WHERE ((T25._Fld2050 = @P22)) AND ((T25._Fld55531_TYPE = 0x08 AND T25._Fld55531_RTRef = 0x000000CC AND T25._Fld55531_RRRef = T23._IDRRef) AND (T25._Fld55532RRef = T24._IDRRef)))) AND 0x0000008B = 0x0000008B AND T24._IDRRef IN (SEL ECT T26._Reference139_IDRRef AS Q_007_F_000RRef FR OM dbo._Reference139_VT5212 T26 INNER JOIN dbo._InfoRg54854 T27 ON ((T27._Fld54856_TYPE = 0x08 AND T27._Fld54856_RTRef = 0x0000017F AND T27._Fld54856_RRRef = @P23) AND (T27._Fld54855_TYPE = T26._Fld5214_TYPE AND T27._Fld54855_RTRef = T26._Fld5214_RTRef AND T27._Fld54855_RRRef = T26._Fld5214_RRRef)) WHERE ((T26._Fld2050 = @P24)) AND (T27._Fld2050 = @P25))) WHERE ((T24._Fld2050 = @P26)) AND ((0x08 <> 0x01) AND (0x08 <> 0x01) AND (CASE WHEN EXISTS(SEL ECT 0x01 AS Q_002_F_000_ FR OM dbo._InfoRg50049 T28 WHERE ((T28._Fld2050 = @P27)) AND ((T28._Fld50050RRef = T24._IDRRef) AND (T28._Fld50051_TYPE = 0x08 AND T28._Fld50051_RTRef = 0x000001EC AND T28._Fld50051_RRRef = T22._Fld38219RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SEL ECT 0x01 AS Q_003_F_000_ FR OM dbo._InfoRg50056 T29 WHERE ((T29._Fld2050 = @P28)) AND ((T29._Fld50057RRef = T24._IDRRef) AND T29._Fld50058_TYPE = 0x08 AND T29._Fld50058_RTRef = 0x000001EC AND (T29._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END) AND (0x08 <> 0x01) AND (0x08 <> 0x01) AND (CASE WHEN EXISTS(SEL ECT 0x01 AS Q_004_F_000_ FR OM dbo._InfoRg50049 T30 WHERE ((T30._Fld2050 = @P29)) AND ((T30._Fld50050RRef = T24._IDRRef) AND (T30._Fld50051_TYPE = 0x08 AND T30._Fld50051_RTRef = 0x0000021C AND T30._Fld50051_RRRef = T22._Fld38218RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SEL ECT 0x01 AS Q_005_F_000_ FR OM dbo._InfoRg50056 T31 WHERE ((T31._Fld2050 = @P30)) AND ((T31._Fld50057RRef = T24._IDRRef) AND T31._Fld50058_TYPE = 0x08 AND T31._Fld50058_RTRef = 0x0000021C AND (T31._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END))))) AND (T22._Fld2050 = @P31)) T21 ON T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000003CB AND T1._Fld70006_RRRef = T21.IDRRef LEFT OUTER JOIN (SEL ECT T33._IDRRef AS IDRRef, T33._Fld35232RRef AS Fld35232RRef, T33._Fld35239RRef AS Fld35239RRef, T33._Fld2050 AS Fld2050_, T33._Fld35238RRef AS Fld35238RRef, T33._Fld61492 AS Fld61492_ FR OM dbo._Document917 T33 WHERE ((EXISTS(SEL ECT 0x01 AS Q_001_F_000_ FR OM dbo._Reference204 T34 INNER JOIN dbo._Reference139 T35 ON (((T34._Fld7105 = @P32) AND EXISTS(SEL ECT 0x01 AS Q_006_F_000_ FR OM dbo._InfoRg55530 T36 WHERE ((T36._Fld2050 = @P33)) AND ((T36._Fld55531_TYPE = 0x08 AND T36._Fld55531_RTRef = 0x000000CC AND T36._Fld55531_RRRef = T34._IDRRef) AND (T36._Fld55532RRef = T35._IDRRef)))) AND 0x0000008B = 0x0000008B AND T35._IDRRef IN (SEL ECT T37._Reference139_IDRRef AS Q_007_F_000RRef FR OM dbo._Reference139_VT5212 T37 INNER JOIN dbo._InfoRg54854 T38 ON ((T38._Fld54856_TYPE = 0x08 AND T38._Fld54856_RTRef = 0x0000017F AND T38._Fld54856_RRRef = @P34) AND (T38._Fld54855_TYPE = T37._Fld5214_TYPE AND T38._Fld54855_RTRef = T37._Fld5214_RTRef AND T38._Fld54855_RRRef = T37._Fld5214_RRRef)) WHERE ((T37._Fld2050 = @P35)) AND (T38._Fld2050 = @P36))) WHERE ((T35._Fld2050 = @P37)) AND ((0x08 <> 0x01) AND (((0x08 <> 0x01) AND (CASE WHEN EXISTS(SEL ECT 0x01 AS Q_002_F_000_ FR OM dbo._InfoRg50049 T39 WHERE ((T39._Fld2050 = @P38)) AND ((T39._Fld50050RRef = T35._IDRRef) AND (T39._Fld50051_TYPE = 0x08 AND T39._Fld50051_RTRef = 0x000001EC AND T39._Fld50051_RRRef = T33._Fld35238RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SEL ECT 0x01 AS Q_003_F_000_ FR OM dbo._InfoRg50056 T40 WHERE ((T40._Fld2050 = @P39)) AND ((T40._Fld50057RRef = T35._IDRRef) AND T40._Fld50058_TYPE = 0x08 AND T40._Fld50058_RTRef = 0x000001EC AND (T40._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END)) OR ((0x08 <> 0x01) AND (CASE WHEN EXISTS(SELECT 0x01 AS Q_004_F_000_ FR OM dbo._InfoRg50049 T41 WHERE ((T41._Fld2050 = @P40)) AND ((T41._Fld50050RRef = T35._IDRRef) AND (T41._Fld50051_TYPE = 0x08 AND T41._Fld50051_RTRef = 0x000001EC AND T41._Fld50051_RRRef = T33._Fld35239RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT 0x01 AS Q_005_F_000_ FR OM dbo._InfoRg50056 T42 WHERE ((T42._Fld2050 = @P41)) AND ((T42._Fld50057RRef = T35._IDRRef) AND T42._Fld50058_TYPE = 0x08 AND T42._Fld50058_RTRef = 0x000001EC AND (T42._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END))))))) AND (T33._Fld2050 = @P42)) T32 ON T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000395 AND T1._Fld70006_RRRef = T32.IDRRef LEFT OUTER JOIN (SELECT T44._IDRRef AS IDRRef, T44._Fld38410RRef AS Fld38410RRef, T44._Fld71159 AS Fld71159_, T44._Fld38412RRef AS Fld38412RRef, T44._Fld38414RRef AS Fld38414RRef, T44._Fld2050 AS Fld2050_ FR OM dbo._Document973 T44 WHERE ((EXISTS(SELECT 0x01 AS Q_001_F_000_ FR OM dbo._Reference204 T45 INNER JOIN dbo._Reference139 T46 ON (((T45._Fld7105 = @P43) AND EXISTS(SELECT 0x01 AS Q_004_F_000_ FR OM dbo._InfoRg55530 T47 WH ERE ((T47._Fld2050 = @P44)) AND ((T47._Fld55531_TYPE = 0x08 AND T47._Fld55531_RTRef = 0x000000CC AND T47._Fld55531_RRRef = T45._IDRRef) AND (T47._Fld55532RRef = T46._IDRRef)))) AND 0x0000008B = 0x0000008B AND T46._IDRRef IN (SELECT T48._Reference139_IDRRef AS Q_005_F_000RRef FR OM dbo._Reference139_VT5212 T48 INNER JOIN dbo._InfoRg54854 T49 ON ((T49._Fld54856_TYPE = 0x08 AND T49._Fld54856_RTRef = 0x0000017F AND T49._Fld54856_RRRef = @P45) AND (T49._Fld54855_TYPE = T48._Fld5214_TYPE AND T49._Fld54855_RTRef = T48._Fld5214_RTRef AND T49._Fld54855_RRRef = T48._Fld5214_RRRef)) WH ERE ((T48._Fld2050 = @P46)) AND (T49._Fld2050 = @P47))) WH ERE ((T46._Fld2050 = @P48)) AND ((0x08 <> 0x01) AND (0x08 <> 0x01) AND (0x08 <> 0x01) AND (CASE WHEN EXISTS(SELECT 0x01 AS Q_002_F_000_ FR OM dbo._InfoRg50049 T50 WH ERE ((T50._Fld2050 = @P49)) AND ((T50._Fld50050RRef = T46._IDRRef) AND (T50._Fld50051_TYPE = 0x08 AND T50._Fld50051_RTRef = 0x0000021C AND T50._Fld50051_RRRef = T44._Fld38414RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT 0x01 AS Q_003_F_000_ FR OM dbo._InfoRg50056 T51 WH ERE ((T51._Fld2050 = @P50)) AND ((T51._Fld50057RRef = T46._IDRRef) AND T51._Fld50058_TYPE = 0x08 AND T51._Fld50058_RTRef = 0x0000021C AND (T51._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END))))) AND (T44._Fld2050 = @P51)) T43 ON T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x000003CD AND T1._Fld70006_RRRef = T43.IDRRef LEFT OUTER JOIN (SELECT T53._Fld31255RRef AS Fld31255RRef, T53._Fld31252RRef AS Fld31252RRef, T53._Fld61503 AS Fld61503_, T53._IDRRef AS IDRRef, T53._Fld31254RRef AS Fld31254RRef, T53._Fld2050 AS Fld2050_ FR OM dbo._Document851 T53 WH ERE ((EXISTS(SELECT 0x01 AS Q_001_F_000_ FR OM dbo._Reference204 T54 INNER JOIN dbo._Reference139 T55 ON (((T54._Fld7105 = @P52) AND EXISTS(SELECT 0x01 AS Q_006_F_000_ FR OM dbo._InfoRg55530 T56 WH ERE ((T56._Fld2050 = @P53)) AND ((T56._Fld55531_TYPE = 0x08 AND T56._Fld55531_RTRef = 0x000000CC AND T56._Fld55531_RRRef = T54._IDRRef) AND (T56._Fld55532RRef = T55._IDRRef)))) AND 0x0000008B = 0x0000008B AND T55._IDRRef IN (SELECT T57._Reference139_IDRRef AS Q_007_F_000RRef FR OM dbo._Reference139_VT5212 T57 INNER JOIN dbo._InfoRg54854 T58 ON ((T58._Fld54856_TYPE = 0x08 AND T58._Fld54856_RTRef = 0x0000017F AND T58._Fld54856_RRRef = @P54) AND (T58._Fld54855_TYPE = T57._Fld5214_TYPE AND T58._Fld54855_RTRef = T57._Fld5214_RTRef AND T58._Fld54855_RRRef = T57._Fld5214_RRRef)) WH ERE ((T57._Fld2050 = @P55)) AND (T58._Fld2050 = @P56))) WH ERE ((T55._Fld2050 = @P57)) AND ((0x08 <> 0x01) AND (0x08 <> 0x01) AND (CASE WHEN EXISTS(SELECT 0x01 AS Q_002_F_000_ FR OM dbo._InfoRg50049 T59 WH ERE ((T59._Fld2050 = @P58)) AND ((T59._Fld50050RRef = T55._IDRRef) AND (T59._Fld50051_TYPE = 0x08 AND T59._Fld50051_RTRef = 0x000001EC AND T59._Fld50051_RRRef = T53._Fld31255RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT 0x01 AS Q_003_F_000_ FR OM dbo._InfoRg50056 T60 WH ERE ((T60._Fld2050 = @P59)) AND ((T60._Fld50057RRef = T55._IDRRef) AND T60._Fld50058_TYPE = 0x08 AND T60._Fld50058_RTRef = 0x000001EC AND (T60._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END) AND (0x08 <> 0x01) AND (CASE WHEN EXISTS(SELECT 0x01 AS Q_004_F_000_ FR OM dbo._InfoRg50049 T61 WH ERE ((T61._Fld2050 = @P60)) AND ((T61._Fld50050RRef = T55._IDRRef) AND (T61._Fld50051_TYPE = 0x08 AND T61._Fld50051_RTRef = 0x0000021C AND T61._Fld50051_RRRef = T53._Fld31254RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT 0x01 AS Q_005_F_000_ FR OM dbo._InfoRg50056 T62 WH ERE ((T62._Fld2050 = @P61)) AND ((T62._Fld50057RRef = T55._IDRRef) AND T62._Fld50058_TYPE = 0x08 AND T62._Fld50058_RTRef = 0x0000021C AND (T62._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END))))) AND (T53._Fld2050 = @P62)) T52 ON T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000353 AND T1._Fld70006_RRRef = T52.IDRRef LEFT OUTER JOIN (SELECT T64._Fld71167 AS Fld71167_, T64._Fld42790RRef AS Fld42790RRef, T64._Fld42799_TYPE AS Fld42799_TYPE, T64._Fld42799_RTRef AS Fld42799_RTRef, T64._Fld42799_RRRef AS Fld42799_RRRef, T64._IDRRef AS IDRRef, T64._Fld2050 AS Fld2050_ FR OM dbo._Document1057 T64 WH ERE ((EXISTS(SEL ECT 1 FR OM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL LEFT OUTER JOIN dbo._Reference243 T65 ON (T64._Fld42799_TYPE = 0x08 AND T64._Fld42799_RTRef = 0x000000F3 AND T64._Fld42799_RRRef = T65._IDRRef) AND (T65._Fld2050 = @P63) WH ERE EXISTS(SELECT 0x01 AS Q_001_F_000_ FR OM dbo._Reference204 T66 INNER JOIN dbo._Reference139 T67 ON (((T66._Fld7105 = @P64) AND EXISTS(SELECT 0x01 AS Q_002_F_000_ FR OM dbo._InfoRg55530 T68 WH ERE ((T68._Fld2050 = @P65)) AND ((T68._Fld55531_TYPE = 0x08 AND T68._Fld55531_RTRef = 0x000000CC AND T68._Fld55531_RRRef = T66._IDRRef) AND (T68._Fld55532RRef = T67._IDRRef)))) AND 0x0000008B = 0x0000008B AND T67._IDRRef IN (SELECT T69._Reference139_IDRRef AS Q_003_F_000RRef FR OM dbo._Reference139_VT5212 T69 INNER JOIN dbo._InfoRg54854 T70 ON ((T70._Fld54856_TYPE = 0x08 AND T70._Fld54856_RTRef = 0x0000017F AND T70._Fld54856_RRRef = @P66) AND (T70._Fld54855_TYPE = T69._Fld5214_TYPE AND T70._Fld54855_RTRef = T69._Fld5214_RTRef AND T70._Fld54855_RRRef = T69._Fld5214_RRRef)) WH ERE ((T69._Fld2050 = @P67)) AND (T70._Fld2050 = @P68))) WH ERE ((T67._Fld2050 = @P69)) AND ((0x08 <> 0x01) AND (CASE WHEN CASE WHEN T64._Fld42799_TYPE = 0x08 AND T64._Fld42799_RTRef = 0x000000F3 THEN T65._Fld7922RRef ELSE CAST(NULL AS BINARY(16)) END IS NULL THEN 0x01 ELSE CASE WHEN CASE WHEN T64._Fld42799_TYPE = 0x08 AND T64._Fld42799_RTRef = 0x000000F3 THEN T65._Fld7922RRef ELSE CAST(NULL AS BINARY(16)) END IS NOT NULL THEN 0x08 END END <> 0x01)))))) AND (T64._Fld2050 = @P70)) T63 ON T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000421 AND T1._Fld70006_RRRef = T63.IDRRef LEFT OUTER JOIN dbo._Reference383 T71 ON (T1._Fld70010RRef = T71._IDRRef) AND (T71._Fld2050 = @P71) WH ERE (((T1._Fld2050 = @P72)) AND (EXISTS(SEL ECT 1 FR OM (SELECT 1 AS SDBL_DUMMY) SDBL_DUAL LEFT OUTER JOIN dbo._Reference69163 T72 ON (T1._Fld70002RRef = T72._IDRRef) AND (T72._Fld2050 = @P73) WH ERE EXISTS(SELECT 0x01 AS Q_001_F_000_ FR OM dbo._Reference204 T73 INNER JOIN dbo._Reference139 T74 ON (((T73._Fld7105 = @P74) AND EXISTS(SELECT 0x01 AS Q_007_F_000_ FR OM dbo._InfoRg55530 T75 WH ERE ((T75._Fld2050 = @P75)) AND ((T75._Fld55531_TYPE = 0x08 AND T75._Fld55531_RTRef = 0x000000CC AND T75._Fld55531_RRRef = T73._IDRRef) AND (T75._Fld55532RRef = T74._IDRRef)))) AND 0x0000008B = 0x0000008B AND T74._IDRRef IN (SELECT T76._Reference139_IDRRef AS Q_008_F_000RRef FR OM dbo._Reference139_VT5212 T76 INNER JOIN dbo._InfoRg54854 T77 ON ((T77._Fld54856_TYPE = 0x08 AND T77._Fld54856_RTRef = 0x0000017F AND T77._Fld54856_RRRef = @P76) AND (T77._Fld54855_TYPE = T76._Fld5214_TYPE AND T77._Fld54855_RTRef = T76._Fld5214_RTRef AND T77._Fld54855_RRRef = T76._Fld5214_RRRef)) WH ERE ((T76._Fld2050 = @P77)) AND (T77._Fld2050 = @P78))) WH ERE ((T74._Fld2050 = @P79)) AND ((0x08 <> 0x01) AND ((0x08 <> 0x01) OR (T1._Fld70001RRef = @P80)) AND (((0x08 <> 0x01) AND (CASE WHEN EXISTS(SELECT 0x01 AS Q_002_F_000_ FR OM dbo._InfoRg50049 T78 WH ERE ((T78._Fld2050 = @P81)) AND ((T78._Fld50050RRef = T74._IDRRef) AND (T78._Fld50051_TYPE = 0x08 AND T78._Fld50051_RTRef = 0x0000021C AND T78._Fld50051_RRRef = T1._Fld70004RRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT 0x01 AS Q_003_F_000_ FR OM dbo._InfoRg50056 T79 WH ERE ((T79._Fld2050 = @P82)) AND ((T79._Fld50057RRef = T74._IDRRef) AND T79._Fld50058_TYPE = 0x08 AND T79._Fld50058_RTRef = 0x0000021C AND (T79._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END)) OR (T1._Fld70004RRef = @P83)) AND (((CASE WHEN T72._Fld70452_TYPE IS NULL THEN 0x01 ELSE T72._Fld70452_TYPE END <> 0x01) AND (CASE WHEN EXISTS(SELECT 0x01 AS Q_004_F_000_ FR OM dbo._InfoRg50049 T80 WH ERE ((T80._Fld2050 = @P84)) AND ((T80._Fld50050RRef = T74._IDRRef) AND (T80._Fld50051_TYPE = T72._Fld70452_TYPE AND T80._Fld50051_RTRef = T72._Fld70452_RTRef AND T80._Fld50051_RRRef = T72._Fld70452_RRRef))) THEN 0x01 ELSE 0x00 END = CASE WHEN EXISTS(SELECT 0x01 AS Q_005_F_000_ FR OM dbo._InfoRg50056 T81 WH ERE ((T81._Fld2050 = @P85)) AND ((T81._Fld50057RRef = T74._IDRRef) AND T81._Fld50058_TYPE = T72._Fld70452_TYPE AND T81._Fld50058_RTRef = T72._Fld70452_RTRef AND (T81._Fld50059 = 0x00))) THEN 0x01 ELSE 0x00 END)) OR ((T72._Fld70452_TYPE = 0x01 AND T72._Fld70452_RTRef = 0x00000000 AND T72._Fld70452_RRRef = @P86) OR T72._Fld70452_TYPE IS NULL AND T72._Fld70452_RTRef IS NULL AND T72._Fld70452_RRRef IS NULL)) AND EXISTS(SELECT 0x01 AS Q_006_F_000_ FR OM dbo._InfoRg55530 T82 WH ERE ((T82._Fld2050 = @P87)) AND ((T82._Fld55532RRef = T74._IDRRef) AND (T82._Fld55531_TYPE = 0x08 AND T82._Fld55531_RTRef = 0x000000CC AND T82._Fld55531_RRRef = T1._Fld69998RRef)))))))) AND (((T1._Fld70005 >= @P88) OR (@P89 = @P90)) AND ((T1._Fld70005 <= @P91) OR (@P92 = @P93)) AND (T1._Fld70009_TYPE = 0x08 AND T1._Fld70009_RTRef = 0x000006E4 AND T1._Fld70009_RRRef = @P94) AND (T1._Fld69999RRef IN (@P95, @P96, @P97, @P98, @P99, @P100, @P101, @P102, @P103, @P104, @P105, @P106, @P107)) AND (T1._Fld69998RRef IN (@P108, @P109, @P110, @P111, @P112, @P113)) AND ((ISNULL(CAST(T71._Description AS NVARCHAR(100)),@P114) < @P115) OR ((ISNULL(CAST(T71._Description AS NVARCHAR(100)),@P116) = @P117) AND ((T1._Fld70010RRef < @P118) OR ((T1._Fld70010RRef = @P119) AND ((T1._Fld69998RRef < @P120) OR ((T1._Fld69998RRef = @P121) AND ((T1._Fld69999RRef < @P122) OR ((T1._Fld69999RRef = @P123) AND ((T1._Fld70000RRef < @P124) OR ((T1._Fld70000RRef = @P125) AND ((T1._Fld70001RRef < @P126) OR ((T1._Fld70001RRef = @P127) AND ((T1._Fld70002RRef < @P128) OR ((T1._Fld70002RRef = @P129) AND ((T1._Fld70003RRef < @P130) OR ((T1._Fld70003RRef = @P131) AND ((T1._Fld70004RRef < @P132) OR ((T1._Fld70004RRef = @P133) AND ((T1._Fld70005 < @P134) OR ((T1._Fld70005 = @P135) AND ((((T1._Fld70006_TYPE < 0x08 OR T1._Fld70006_TYPE = 0x08 AND ((T1._Fld70006_RTRef < 0x00000395 OR T1._Fld70006_RTRef = 0x00000395 AND T1._Fld70006_RRRef < @P136))))) OR ((T1._Fld70006_TYPE = 0x08 AND T1._Fld70006_RTRef = 0x00000395 AND T1._Fld70006_RRRef = @P137) AND (T1._Fld70007 < @P138)))))))))))))))))))))))) ORDER BY (ISNULL(CAST(T71._Description AS NVARCHAR(100)),N'')) DESC, (T1._Fld70010RRef) DESC, (T1._Fld69998RRef) DESC, (T1._Fld69999RRef) DESC, (T1._Fld70000RRef) DESC, (T1._Fld70001RRef) DESC, (T1._Fld70002RRef) DESC, (T1._Fld70003RRef) DESC, (T1._Fld70004RRef) DESC, (T1._Fld70005) DESC, (T1._Fld70006_TYPE) DESC, (T1._Fld70006_RTRef) DESC, (T1._Fld70006_RRRef) DESC, (T1._Fld70007) DESC |
(30) Profiler идёт в комплекте с сервером MS SQL, его нет необходимости отдельно устанавливать. Хотя можно у себя на компе установить бесплатную "MS SQL Studio Light" или что-то вроде того и с ней профайлер тоже идёт, вроде ... не помню точно. Можно погуглить :-)
вообщем настройки для sql, 2-4 гига выделяете памяти для Sql, для процессора ставите максимальное число рабочих потоков 2048, жесткий диски ставь ssd, скорость запись/чтение выше 500 мб/с. Желательно пару штук. И раскидать mdf и ldf на разные жест.диск. Если rphost, будет расти выше 4 гига. То в 1С кластере выделите максимальную память для перезапуска службы. Писал в спешке извините за ошибки)
32 гига оперативы на серваке, ссд под базами, sql, 8 баз рабочих (8.3) , 2-3 для разработок, одновременно 50-70 пользователей.
полет нормальный.
у автора - нормально проадминить настройки кластера серверов, sql, пользователей развести по своим учеткам надоть, регламентные задания посмотреть чтобы в рпхост не срали, порно перестать на сервере смотреть через тот же хром - тож ресурсов до... много жреть... в общем админить, админить и еще раз админить :))))))))
как вариант моя настройка кластера
полет нормальный.
у автора - нормально проадминить настройки кластера серверов, sql, пользователей развести по своим учеткам надоть, регламентные задания посмотреть чтобы в рпхост не срали, порно перестать на сервере смотреть через тот же хром - тож ресурсов до... много жреть... в общем админить, админить и еще раз админить :))))))))
как вариант моя настройка кластера
Прикрепленные файлы:
(37) Бух корп головное +6 филиалов, Зупы.
Кстати недавно rphost сваливался - нагружал проц до 100, оказалось регламентное задание вылетело с ошибкой и срало 3 раза каждые 10 секунд - это было на поверхности, а искали неделю проблему - что только не перепробовали.
Кстати недавно rphost сваливался - нагружал проц до 100, оказалось регламентное задание вылетело с ошибкой и срало 3 раза каждые 10 секунд - это было на поверхности, а искали неделю проблему - что только не перепробовали.
Для получения уведомлений об ответах подключите телеграм бот:
Инфостарт бот