1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175
| text execution_count total_logical_reads last_logical_reads min_logical_reads max_logical_reads total_rows last_rows min_rows max_rows
(@Param000004 int,@Param000005 int,@Param000006 int,@Param000007 int,@Param000008 smalldatetime,@Param000009 smalldatetime,@Param000010 real,@Param000011 real,@Param000012 float,@Param000013 real,@Param000014 real,@Param000015 nvarchar(50),@Param000016 smalldatetime,@Param000017 bit,@Param000018 ntext,@Param000019 smalldatetime,@Param000020 nvarchar(30),@Param000021 bit,@Param000022 float,@Param000023 float,@Param000024 float,@Param000025 smalldatetime,@Param000026 bit)INSERT [cimproductimport].[dbo].[RJP]([IdRJP],[IdOFOpe],[IdOperateur],[IdRess],[DateDebut],[DateFin],[Reglage],[TempsDemontage],[Qte],[Avancement],[Duree],[NumLot],[DateStoppe],[Cloture],[Remarque],[DateExport],[CodeImport],[HorsPlanning],[QteImport],[NbOperateurs],[TpsOperateurs],[DateRemarque],[UpdateFlag]) VALUES(@Param000004,@Param000005,@Param000006,@Param000007,@Param000008,@Param000009,@Param000010,@Param000011,@Param000012,@Param000013,@Param000014,@Param000015,@Param000016,@Param000017,@Param000018,@Param000019,@Param000020,@Param000021,@Param000022,@Param000023,@Param000024,@Param000025,@Param000026) 54575695 60721343 1 1 27 54575695 1 1 1
(@Param000004 int,@Param000005 int,@Param000006 int,@Param000007 real,@Param000008 float,@Param000009 float,@Param000010 real,@Param000011 real,@Param000012 int,@Param000013 smallint,@Param000014 bit,@Param000015 nvarchar(30))INSERT [CimproductImport].[dbo].[PiecesOperationRess]([Id],[IdOperation],[IdRess],[TempsMontage],[CadenceH],[DureeU],[TempsDemontage],[DureeLot],[QteMini],[Preference],[DevisPrincipale],[CodeImport]) VALUES(@Param000004,@Param000005,@Param000006,@Param000007,@Param000008,@Param000009,@Param000010,@Param000011,@Param000012,@Param000013,@Param000014,@Param000015) 4435715 32342714 7 7 44 4435715 1 1 1
SELECT "IdTiers" FROM "dbo"."tiers" 608944 40837966 68 67 68 1025714061 1688 1682 1688
SELECT spinReports2Print.*, srsp_devicename FROM spinReports2Print
LEFT JOIN spinReportsServerPrinters ON spinReportsServerPrinters.srsp_id=spinReports2Print.srsp_id
WHERE spinReports2Print.sr2p_done=0
AND spinReports2Print.srsp_id in (select srsp_id from spinReportsServerPrinters where srs_id=8);
293664 41731399 143 0 293 1861 0 0 6
(@Param000004 datetime,@Param000005 int,@Param000006 int,@Param000007 nvarchar(12),@Param000008 nvarchar(50),@Param000009 int,@Param000010 nvarchar(50),@Param000011 nvarchar(4),@Param000012 nvarchar(50),@Param000013 nvarchar(255),@Param000014 float,@Param000015 money,@Param000016 money,@Param000017 float,@Param000018 money,@Param000019 money,@Param000020 money,@Param000021 money,@Param000022 money,@Param000023 bit,@Param000024 money,@Param000025 float,@Param000026 bit,@Param000027 nvarchar(4),@Param000028 float,@Param000029 nvarchar(20),@Param000030 int,@Param000031 nvarchar(12),@Param000032 nvarchar(50),@Param000033 nvarchar(20),@Param000034 nvarchar(12),@Param000035 nvarchar(10),@Param000036 int,@Param000037 int,@Param000038 bit,@Param000039 bit,@Param000040 int,@Param000041 nvarchar(4),@Param000042 int,@Param000043 bit,@Param000044 int,@Param000045 datetime,@Param000046 nvarchar(50),@Param000047 datetime,@Param000048 smallint,@Param000049 bit,@Param000050 bit,@Param000051 int,@Param000052 int,@Param000053 int,@Param000054 bit,@Param000055 datetime,@Param000056 int,@Param000057 datetime,@Param000058 smallint,@Param000059 nvarchar(50),@Param000060 nvarchar(50),@Param000061 nvarchar(50),@Param000062 nvarchar(50),@Param000063 nvarchar(50),@Param000064 nvarchar(50),@Param000065 nvarchar(50),@Param000066 nvarchar(50),@Param000067 nvarchar(50),@Param000068 nvarchar(28),@Param000069 nvarchar(28),@Param000070 nvarchar(28),@Param000071 nvarchar(28),@Param000072 nvarchar(21),@Param000073 nvarchar(35),@Param000074 nvarchar(30),@Param000075 nvarchar(30),@Param000076 nvarchar(30),@Param000077 nvarchar(30),@Param000078 nvarchar(30),@Param000079 nvarchar(30),@Param000080 nvarchar(30),@Param000081 nvarchar(30),@Param000082 nvarchar(30),@Param000083 int,@Param000084 smallint,@Param000085 datetime,@Param000086 datetime)INSERT [cptalignes]([LI_Date],[LI_JOCpt],[LI_Cpt],[LI_Journal],[LI_Tri],[LI_No],[LI_Numero],[LI_TypeJournal],[LI_NoCompte],[LI_Lib],[LI_Qte],[LI_MontantHT],[LI_MontantHTMB],[LI_CumulQte],[LI_CumulPO],[LI_CumulVal],[LI_CumulPOME],[LI_CumulValME],[LI_CumulRegr],[LI_PosteOuvert],[LI_CumulRegrME],[LI_SaisieTech],[LI_Previsionnelle],[LI_Monnaie],[LI_Taux],[LI_User],[LI_Secriture],[LI_NoPiece],[LI_NoCcpar],[LI_NoFact],[LI_NoAffaire],[LI_DateLettrage],[LI_NoEcrCG],[LI_NoLettrage],[LI_VentAnalytique],[LI_Analytique],[LI_SecrAna],[LI_TVA],[LI_TypeEcrCG],[LI_VentTVA],[LI_NoSoumisTVA],[LI_DateEcheance],[LI_NoFacture],[LI_DateRappel],[LI_NivRappel],[LI_ARolluper],[LI_Bloque],[LI_NoPmtAuto],[LI_NoPmtAutoDeb],[LI_NoBVR],[LI_Systeme],[LI_DateReeval],[LI_NoFACO],[LI_DateBouclement],[LI_TypePaiement],[LI_NoComptePostal],[LI_Clearing],[LI_Reference],[LI_NoCompteBancaire],[LI_Ben1],[LI_Ben2],[LI_Ben3],[LI_Ben4],[LI_Ben5],[LI_Motif1],[LI_Motif2],[LI_Motif3],[LI_Motif4],[LI_CodeSWIFT],[LI_CodeIBAN],[LI_BanqueBen1],[LI_BanqueBen2],[LI_BanqueBen3],[LI_BanqueBen4],[LI_BanqueBen5],[LI_InstrPart1],[LI_InstrPart2],[LI_InstrPart3],[LI_InstrPart4],[LI_DoCpt],[LI_Frais],[LI_Now],[LI_SYSCreate]) VALUES(@Param000004,@Param000005,@Param000006,@Param000007,@Param000008,@Param000009,@Param000010,@Param000011,@Param000012,@Param000013,@Param000014,@Param000015,@Param000016,@Param000017,@Param000018,@Param000019,@Param000020,@Param000021,@Param000022,@Param000023,@Param000024,@Param000025,@Param000026,@Param000027,@Param000028,@Param000029,@Param000030,@Param000031,@Param000032,@Param000033,@Param000034,@Param000035,@Param000036,@Param000037,@Param000038,@Param000039,@Param000040,@Param000041,@Param000042,@Param000043,@Param000044,@Param000045,@Param000046,@Param000047,@Param000048,@Param000049,@Param000050,@Param000051,@Param000052,@Param000053,@Param000054,@Param000055,@Param000056,@Param000057,@Param000058,@Param000059,@Param000060,@Param000061,@Param000062,@Param000063,@Param000064,@Param000065,@Param000066,@Param000067,@Param000068,@Param000069,@Param000070,@Param000071,@Param000072,@Param000073,@Param000074,@Param000075,@Param000076,@Param000077,@Param000078,@Param000079,@Param000080,@Param000081,@Param000082,@Param000083,@Param000084,@Param000085,@Param000086) 187753 488362 2 2 25 187753 1 1 1
declare @BatchID uniqueidentifier
set @BatchID = NEWID()
UPDATE [Event] WITH (TABLOCKX)
SET [BatchID] = @BatchID,
[ProcessStart] = GETUTCDATE(),
[ProcessHeartbeat] = GETUTCDATE()
FROM (
SELECT TOP 6 [EventID] FROM [Event] WITH (TABLOCKX) WHERE [ProcessStart] is NULL ORDER BY [TimeEntered]
) AS t1
WHERE [Event].[EventID] = t1.[EventID]
select top 6
E.[EventID],
E.[EventType],
E.[EventData]
from
[Event] E WITH (TABLOCKX)
where
[BatchID] = @BatchID
ORDER BY [TimeEntered]
145465 290948 2 2 20 0 0 0 0
declare @BatchID uniqueidentifier
set @BatchID = NEWID()
UPDATE [Event] WITH (TABLOCKX)
SET [BatchID] = @BatchID,
[ProcessStart] = GETUTCDATE(),
[ProcessHeartbeat] = GETUTCDATE()
FROM (
SELECT TOP 6 [EventID] FROM [Event] WITH (TABLOCKX) WHERE [ProcessStart] is NULL ORDER BY [TimeEntered]
) AS t1
WHERE [Event].[EventID] = t1.[EventID]
select top 6
E.[EventID],
E.[EventType],
E.[EventData]
from
[Event] E WITH (TABLOCKX)
where
[BatchID] = @BatchID
ORDER BY [TimeEntered]
145465 290930 2 2 2 0 0 0 0
declare @BatchID uniqueidentifier
set @BatchID = newid()
UPDATE [Notifications] WITH (TABLOCKX)
SET [BatchID] = @BatchID,
[ProcessStart] = GETUTCDATE(),
[ProcessHeartbeat] = GETUTCDATE()
FROM (
SELECT TOP 6 [NotificationID] FROM [Notifications] WITH (TABLOCKX) WHERE ProcessStart is NULL and
(ProcessAfter is NULL or ProcessAfter < GETUTCDATE()) ORDER BY [NotificationEntered]
) AS t1
WHERE [Notifications].[NotificationID] = t1.[NotificationID]
select top 6
-- Notification data
N.[NotificationID],
N.[SubscriptionID],
N.[ActivationID],
N.[ReportID],
N.[SnapShotDate],
N.[DeliveryExtension],
N.[ExtensionSettings],
N.[Locale],
N.[Parameters],
N.[SubscriptionLastRunTime],
N.[ProcessStart],
N.[NotificationEntered],
N.[Attempt],
N.[IsDataDriven],
SUSER_SNAME(Owner.[Sid]),
Owner.[UserName],
-- Report Data
O.[Path],
N.[ReportZone],
O.[Type],
SD.NtSecDescPrimary,
N.[Version],
Owner.[AuthType]
from
[Notifications] N with (TABLOCKX) inner join [Catalog] O on O.[ItemID] = N.[ReportID]
inner join [Users] Owner on N.SubscriptionOwnerID = Owner.UserID
left outer join [SecData] SD on O.[PolicyID] = SD.[PolicyID] AND SD.AuthType = Owner.AuthType
where
N.[BatchID] = @BatchID
ORDER BY [NotificationEntered]
145448 290940 2 2 46 0 0 0 0
declare @BatchID uniqueidentifier
set @BatchID = newid()
UPDATE [Notifications] WITH (TABLOCKX)
SET [BatchID] = @BatchID,
[ProcessStart] = GETUTCDATE(),
[ProcessHeartbeat] = GETUTCDATE()
FROM (
SELECT TOP 6 [NotificationID] FROM [Notifications] WITH (TABLOCKX) WHERE ProcessStart is NULL and
(ProcessAfter is NULL or ProcessAfter < GETUTCDATE()) ORDER BY [NotificationEntered]
) AS t1
WHERE [Notifications].[NotificationID] = t1.[NotificationID]
select top 6
-- Notification data
N.[NotificationID],
N.[SubscriptionID],
N.[ActivationID],
N.[ReportID],
N.[SnapShotDate],
N.[DeliveryExtension],
N.[ExtensionSettings],
N.[Locale],
N.[Parameters],
N.[SubscriptionLastRunTime],
N.[ProcessStart],
N.[NotificationEntered],
N.[Attempt],
N.[IsDataDriven],
SUSER_SNAME(Owner.[Sid]),
Owner.[UserName],
-- Report Data
O.[Path],
N.[ReportZone],
O.[Type],
SD.NtSecDescPrimary,
N.[Version],
Owner.[AuthType]
from
[Notifications] N with (TABLOCKX) inner join [Catalog] O on O.[ItemID] = N.[ReportID]
inner join [Users] Owner on N.SubscriptionOwnerID = Owner.UserID
left outer join [SecData] SD on O.[PolicyID] = SD.[PolicyID] AND SD.AuthType = Owner.AuthType
where
N.[BatchID] = @BatchID
ORDER BY [NotificationEntered]
145448 1163668 8 8 92 0 0 0 0
(@Param000004 int,@Param000005 int,@Param000006 nvarchar(50),@Param000007 nvarchar(69),@Param000008 nvarchar(24),@Param000009 nvarchar(30),@Param000010 float,@Param000011 nvarchar(50),@Param000012 int,@Param000013 int,@Param000014 float,@Param000015 int,@Param000016 nvarchar(30),@Param000017 nvarchar(16),@Param000018 bit,@Param000019 real,@Param000020 float,@Param000021 float,@Param000022 bit,@Param000023 float,@Param000024 float,@Param000025 float,@Param000026 float,@Param000027 int,@Param000028 float,@Param000029 nvarchar(20),@Param000030 nvarchar(20),@Param000031 nvarchar(30),@Param000032 ntext,@Param000033 bit,@Param000034 bit,@Param000035 real,@Param000036 float,@Param000037 smallint,@Param000038 smalldatetime,@Param000039 nvarchar(50),@Param000040 nvarchar(50),@Param000041 smallint,@Param000042 smallint,@Param000043 float,@Param000044 float,@Param000045 float,@Param000046 float,@Param000047 nvarchar(1),@Param000048 smallint,@Param000049 bit,@Param000050 nvarchar(15),@Param000051 smallint,@Param000052 int,@Param000053 real,@Param000054 nvarchar(100),@Param000055 float,@Param000056 float,@Param000057 float,@Param000058 float,@Param000059 nvarchar(30),@Param000060 bit,@Param000061 nvarchar(30))INSERT [cimproductimport].[dbo].[Piece]([IdPiece],[IdAtelier],[RefPiece],[NomPiece],[RefPieceCli],[CodeImport],[PxHT],[Plan],[IdClient],[FamOrdre],[Categorie],[IdMatiere],[NumDossier],[NoCarteControle],[Standart],[DureePreparation],[CoutMatiere],[CoutPreparation],[MatiereFournie],[TarifMontage],[TarifFacon],[PoidsNet],[PoidsBrut],[IdSerieLot],[LotMiniEco],[Nuance],[Forme],[Debit],[Remarque],[FActive],[Verifie],[NomenDecalJour],[NomenDecalRef],[FlEdition],[DateMaj],[NomFicLie],[NomEtat],[ANGHELICE],[ANGCOUPE],[D1],[L2],[D2],[L1],[GD],[Z],[JEU],[COLLET],[NbExDoc],[NbPieceParDoc],[QteConditionnement],[Image],[RAYON],[CHANFREIN],[ANGLE],[PLAT_POINTE],[SPECIFICITES],[WELDON],[ANGPOINTE]) VALUES(@Param000004,@Param000005,@Param000006,@Param000007,@Param000008,@Param000009,@Param000010,@Param000011,@Param000012,@Param000013,@Param000014,@Param000015,@Param000016,@Param000017,@Param000018,@Param000019,@Param000020,@Param000021,@Param000022,@Param000023,@Param000024,@Param000025,@Param000026,@Param000027,@Param000028,@Param000029,@Param000030,@Param000031,@Param000032,@Param000033,@Param000034,@Param000035,@Param000036,@Param000037,@Param000038,@Param000039,@Param000040,@Param000041,@Param000042,@Param000043,@Param000044,@Param000045,@Param000046,@Param000047,@Param000048,@Param000049,@Param000050,@Param000051,@Param000052,@Param000053,@Param000054,@Param000055,@Param000056,@Param000057,@Param000058,@Param000059,@Param000060,@Param000061) 129151 253667 1 1 7 129151 1 1 1
SELECT "IdRess" FROM "dbo"."ressources" 114156 228312 2 2 2 34703424 304 304 304
(@Param000004 int,@Param000005 int,@Param000006 nvarchar(50),@Param000007 nvarchar(69),@Param000008 nvarchar(24),@Param000009 nvarchar(30),@Param000010 float,@Param000011 nvarchar(50),@Param000012 int,@Param000013 int,@Param000014 float,@Param000015 int,@Param000016 nvarchar(30),@Param000017 nvarchar(16),@Param000018 bit,@Param000019 real,@Param000020 float,@Param000021 float,@Param000022 bit,@Param000023 float,@Param000024 float,@Param000025 float,@Param000026 float,@Param000027 int,@Param000028 float,@Param000029 nvarchar(20),@Param000030 nvarchar(20),@Param000031 nvarchar(30),@Param000032 bit,@Param000033 bit,@Param000034 real,@Param000035 float,@Param000036 smallint,@Param000037 smalldatetime,@Param000038 nvarchar(50),@Param000039 nvarchar(50),@Param000040 smallint,@Param000041 smallint,@Param000042 float,@Param000043 float,@Param000044 float,@Param000045 float,@Param000046 nvarchar(1),@Param000047 smallint,@Param000048 bit,@Param000049 nvarchar(15),@Param000050 smallint,@Param000051 int,@Param000052 real,@Param000053 nvarchar(100),@Param000054 float,@Param000055 float,@Param000056 float,@Param000057 float,@Param000058 nvarchar(30),@Param000059 bit,@Param000060 nvarchar(30),@Param000061 ntext)INSERT [cimproductimport].[dbo].[Piece]([IdPiece],[IdAtelier],[RefPiece],[NomPiece],[RefPieceCli],[CodeImport],[PxHT],[Plan],[IdClient],[FamOrdre],[Categorie],[IdMatiere],[NumDossier],[NoCarteControle],[Standart],[DureePreparation],[CoutMatiere],[CoutPreparation],[MatiereFournie],[TarifMontage],[TarifFacon],[PoidsNet],[PoidsBrut],[IdSerieLot],[LotMiniEco],[Nuance],[Forme],[Debit],[FActive],[Verifie],[NomenDecalJour],[NomenDecalRef],[FlEdition],[DateMaj],[NomFicLie],[NomEtat],[ANGHELICE],[ANGCOUPE],[D1],[L2],[D2],[L1],[GD],[Z],[JEU],[COLLET],[NbExDoc],[NbPieceParDoc],[QteConditionnement],[Image],[RAYON],[CHANFREIN],[ANGLE],[PLAT_POINTE],[SPECIFICITES],[WELDON],[ANGPOINTE],[Remarque]) VALUES(@Param000004,@Param000005,@Param000006,@Param000007,@Param000008,@Param000009,@Param000010,@Param000011,@Param000012,@Param000013,@Param000014,@Param000015,@Param000016,@Param000017,@Param000018,@Param000019,@Param000020,@Param000021,@Param000022,@Param000023,@Param000024,@Param000025,@Param000026,@Param000027,@Param000028,@Param000029,@Param000030,@Param000031,@Param000032,@Param000033,@Param000034,@Param000035,@Param000036,@Param000037,@Param000038,@Param000039,@Param000040,@Param000041,@Param000042,@Param000043,@Param000044,@Param000045,@Param000046,@Param000047,@Param000048,@Param000049,@Param000050,@Param000051,@Param000052,@Param000053,@Param000054,@Param000055,@Param000056,@Param000057,@Param000058,@Param000059,@Param000060,@Param000061) 104731 423623 2 2 16 104731 1 1 1
(@P1 nvarchar(12))SELECT "CL_Code" ,"dbo"."Clients"."CL_Code" FROM "dbo"."Clients" WHERE ("CL_Code" = @P1) 104030 208060 2 2 2 104030 1 1 1
(@1 tinyint,@2 varchar(8000))SELECT [srsp_id] FROM [dbo].[spinReportsServerPrinters] WHERE [srs_id]=@1 AND [srsp_devicename]=@2 88032 352128 4 4 4 88032 1 1 1
SELECT "dbo"."spinReports2Print"."sr2p_id","MS1"."srsp_id" FROM {oj "dbo"."spinReports2Print" LEFT OUTER JOIN "dbo"."spinReportsServerPrinters" "MS1" ON ("dbo"."spinReports2Print"."srsp_id" = "MS1"."srsp_id" ) } WHERE (("dbo"."spinReports2Print"."sr2p_done" = 0 ) AND (("dbo"."spinReports2Print"."srsp_id" )= ANY (SELECT "MS2"."srsp_id" FROM "dbo"."spinReportsServerPrinters" "MS2" WHERE ("MS2"."srs_id" = 8 ) ))) 85378 12145605 143 140 185 2305 0 0 6
()
select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid
from [SSISDB].[sys].[filetable_updates_2105058535] with (readpast) order by table_id 73404 0 0 0 0 0 0 0 0
()
select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid
from [ReportServer$XSSQL].[sys].[filetable_updates_2105058535] with (readpast) order by table_id 73404 0 0 0 0 0 0 0 0
()
select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid
from [cimproductimport].[sys].[filetable_updates_1410104064] with (readpast) order by table_id 73404 0 0 0 0 0 0 0 0
()
select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid
from [ReportServer$XSSQLTempDB].[sys].[filetable_updates_2105058535] with (readpast) order by table_id 73404 0 0 0 0 0 0 0 0
()
select table_id, item_guid, oplsn_fseqno, oplsn_bOffset, oplsn_slotid
from [tc_dms_lbsa].[sys].[filetable_updates_2021582240] with (readpast) order by table_id 73404 0 0 0 0 0 0 0 0 |
Partager