dixy top queries

gistfile1.sql

by cpu

(@P1 bigint,@P2 nvarchar(21),@P3 nvarchar(21),@P4 datetime,@P5 nvarchar(21),@P6 nvarchar(21),@P7 numeric(28, 12),@P8 numeric(28, 12),@P9 numeric(28, 12),@P10 nvarchar(21),@P11 nvarchar(21),@P12 int,@P13 int,@P14 nvarchar(21),@P15 nvarchar(21),@P16 nvarchar(21),@P17 nvarchar(21),@P18 nvarchar(21),@P19 nvarchar(21),@P20 nvarchar(21),@P21 nvarchar(21),@P22 nvarchar(21),@P23 nvarchar(21),@P24 nvarchar(21),@P25 nvarchar(21),@P26 nvarchar(21),@P27 nvarchar(21),@P28 nvarchar(21),@P29 nvarchar(21),@P30 nvarchar(21),@P31 nvarchar(21),@P32 int,@P33 int,@P34 nvarchar(21),@P35 int,@P36 int,@P37 nvarchar(21),@P38 nvarchar(21),@P39 nvarchar(21),@P40 nvarchar(21),@P41 nvarchar(21),@P42 nvarchar(5),@P43 int,@P44 bigint)INSERT INTO INVENTSETTLEMENT (TRANSRECID,INVENTTRANSID,ITEMID,TRANSDATE,VOUCHER,SETTLETRANSID,QTYSETTLED,COSTAMOUNTSETTLED,COSTAMOUNTADJUSTMENT,BALANCESHEETACCOUNT,OPERATIONSACCOUNT,CANCELLED,SETTLEMODEL,DIMENSION,DIMENSION2_,DIMENSION3_,DIMENSION4_,DIMENSION5_,DIMENSION6_,DIMENSION7_,DIMENSION8_,DIMENSION9_,DIMENSION10_,DIMENSION11_,DIMENSION12_,DIMENSION13_,DIMENSION14_,DIMENSION15_,DIMENSION16_,DIMENSION17_,DIMENSION18_,BALANCESHEETPOSTING,OPERATIONSPOSTING,ITEMGROUPID,POSTED,SETTLETYPE,MARKUPCODE_RU,VENDINVOICEIDMARKUP_RU,VENDACCOUNTMARKUP_RU,BALANCESHEETACCOUNT2,OPERATIONSACCOUNT2,DATAAREAID,RECVERSION,RECID) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19,@P20,@P21,@P22,@P23,@P24,@P25,@P26,@P27,@P28,@P29,@P30,@P31,@P32,@P33,@P34,@P35,@P36,@P37,@P38,@P39,@P40,@P41,@P42,@P43,@P44)
(@P1 bigint,@P2 int,@P3 int)SELECT A.BATCHTHREADID,A.BATCHJOBID,A.CALCLISTTABLEID,A.CALCLISTRECID,A.BATCHPRIORITY,A.RECVERSION,A.RECID FROM MRUNBASEBATCHTHREADTABLE A WHERE ((DATAAREAID=N'3r') AND (((BATCHJOBID=@P1) AND (BATCHTHREADID=@P2)) AND (BATCHPRIORITY=@P3)))
(@P1 numeric(28, 12),@P2 numeric(28, 12),@P3 int,@P4 datetime,@P5 int,@P6 datetime,@P7 nvarchar(5),@P8 bigint,@P9 int)UPDATE INVENTTRANS SET QTYSETTLED=@P1,COSTAMOUNTSETTLED=@P2,VALUEOPEN=@P3,DATECLOSED=@P4,RECVERSION=@P5,MODIFIEDDATETIME=@P6 WHERE (((DATAAREAID=@P7) AND (RECID=@P8)) AND (RECVERSION=@P9))
(@P1 nvarchar(21),@P2 datetime,@P3 nvarchar(11))SELECT TOP 1 A.REASONREFRECID,A.DEPRPROFILEID,A.SUBGROUPID,A.ACCOUNTNUM,A.CHANGEDATE,A.NEWLIFE,A.ASSETSTANDARDID,A.NEWFACTOR,A.NEWDEPRPROFILE,A.CHANGETIME,A.OLDDEPRPROFILE,A.USERID,A.DEPTYPE,A.ASSETSTANDARD,A.CREATEDDATETIME,A.DEL_CREATEDTIME,A.CREATEDBY,A.RECVERSION,A.RECID FROM RASSETLIFEHIST A WHERE ((DATAAREAID=N'3r') AND (((ACCOUNTNUM=@P1) AND (CHANGEDATE<=@P2)) AND (ASSETSTANDARDID=@P3))) ORDER BY A.DATAAREAID DESC,A.ACCOUNTNUM DESC,A.ASSETSTANDARDID DESC,A.CHANGEDATE DESC
(@P1 nvarchar(21),@P2 int,@P3 datetime,@P4 nvarchar(11))SELECT TOP 1 A.ITEMID,A.VERSIONID,A.PRICETYPE,A.INVENTDIMID,A.MARKUP,A.PRICEUNIT,A.PRICE,A.PRICECALCID,A.UNITID,A.PRICEALLOCATEMARKUP,A.PRICEQTY,A.STDCOSTTRANSDATE,A.STDCOSTVOUCHER,A.COSTINGTYPE,A.ACTIVATIONDATE,A.PRICEINCLTAX,A.MODULE,A.TRANSTYPE,A.TRANSREFID,A.CREATEDDATETIME,A.RECVERSION,A.RECID FROM INVENTITEMPRICE A,INVENTDIM B WHERE ((A.DATAAREAID=N'edat') AND (((A.ITEMID=@P1) AND (A.PRICETYPE=@P2)) AND (A.ACTIVATIONDATE<=@P3))) AND ((B.DATAAREAID=N'edat') AND ((B.INVENTDIMID=A.INVENTDIMID) AND (B.INVENTSITEID=@P4))) ORDER BY A.DATAAREAID DESC,A.ACTIVATIONDATE DESC,A.CREATEDDATETIME DESC

by read 

(@P1 nvarchar(21),@P2 int,@P3 datetime,@P4 nvarchar(11))SELECT TOP 1 A.ITEMID,A.VERSIONID,A.PRICETYPE,A.INVENTDIMID,A.MARKUP,A.PRICEUNIT,A.PRICE,A.PRICECALCID,A.UNITID,A.PRICEALLOCATEMARKUP,A.PRICEQTY,A.STDCOSTTRANSDATE,A.STDCOSTVOUCHER,A.COSTINGTYPE,A.ACTIVATIONDATE,A.PRICEINCLTAX,A.MODULE,A.TRANSTYPE,A.TRANSREFID,A.CREATEDDATETIME,A.RECVERSION,A.RECID FROM INVENTITEMPRICE A,INVENTDIM B WHERE ((A.DATAAREAID=N'edat') AND (((A.ITEMID=@P1) AND (A.PRICETYPE=@P2)) AND (A.ACTIVATIONDATE<=@P3))) AND ((B.DATAAREAID=N'edat') AND ((B.INVENTDIMID=A.INVENTDIMID) AND (B.INVENTSITEID=@P4))) ORDER BY A.DATAAREAID DESC,A.ACTIVATIONDATE DESC,A.CREATEDDATETIME DESC
(@P1 bigint,@P2 nvarchar(21),@P3 nvarchar(21),@P4 datetime,@P5 nvarchar(21),@P6 nvarchar(21),@P7 numeric(28, 12),@P8 numeric(28, 12),@P9 numeric(28, 12),@P10 nvarchar(21),@P11 nvarchar(21),@P12 int,@P13 int,@P14 nvarchar(21),@P15 nvarchar(21),@P16 nvarchar(21),@P17 nvarchar(21),@P18 nvarchar(21),@P19 nvarchar(21),@P20 nvarchar(21),@P21 nvarchar(21),@P22 nvarchar(21),@P23 nvarchar(21),@P24 nvarchar(21),@P25 nvarchar(21),@P26 nvarchar(21),@P27 nvarchar(21),@P28 nvarchar(21),@P29 nvarchar(21),@P30 nvarchar(21),@P31 nvarchar(21),@P32 int,@P33 int,@P34 nvarchar(21),@P35 int,@P36 int,@P37 nvarchar(21),@P38 nvarchar(21),@P39 nvarchar(21),@P40 nvarchar(21),@P41 nvarchar(21),@P42 nvarchar(5),@P43 int,@P44 bigint)INSERT INTO INVENTSETTLEMENT (TRANSRECID,INVENTTRANSID,ITEMID,TRANSDATE,VOUCHER,SETTLETRANSID,QTYSETTLED,COSTAMOUNTSETTLED,COSTAMOUNTADJUSTMENT,BALANCESHEETACCOUNT,OPERATIONSACCOUNT,CANCELLED,SETTLEMODEL,DIMENSION,DIMENSION2_,DIMENSION3_,DIMENSION4_,DIMENSION5_,DIMENSION6_,DIMENSION7_,DIMENSION8_,DIMENSION9_,DIMENSION10_,DIMENSION11_,DIMENSION12_,DIMENSION13_,DIMENSION14_,DIMENSION15_,DIMENSION16_,DIMENSION17_,DIMENSION18_,BALANCESHEETPOSTING,OPERATIONSPOSTING,ITEMGROUPID,POSTED,SETTLETYPE,MARKUPCODE_RU,VENDINVOICEIDMARKUP_RU,VENDACCOUNTMARKUP_RU,BALANCESHEETACCOUNT2,OPERATIONSACCOUNT2,DATAAREAID,RECVERSION,RECID) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19,@P20,@P21,@P22,@P23,@P24,@P25,@P26,@P27,@P28,@P29,@P30,@P31,@P32,@P33,@P34,@P35,@P36,@P37,@P38,@P39,@P40,@P41,@P42,@P43,@P44)
(@P1 numeric(28, 12),@P2 numeric(28, 12),@P3 int,@P4 datetime,@P5 int,@P6 datetime,@P7 nvarchar(5),@P8 bigint,@P9 int)UPDATE INVENTTRANS SET QTYSETTLED=@P1,COSTAMOUNTSETTLED=@P2,VALUEOPEN=@P3,DATECLOSED=@P4,RECVERSION=@P5,MODIFIEDDATETIME=@P6 WHERE (((DATAAREAID=@P7) AND (RECID=@P8)) AND (RECVERSION=@P9))
(@P1 image,@P2 image,@P3 nvarchar(61),@P4 int,@P5 int,@P6 bigint,@P7 datetime,@P8 int,@P9 nvarchar(6),@P10 bigint,@P11 nvarchar(5),@P12 int,@P13 bigint)INSERT INTO SYSDATABASELOG (DATA,CALLSTACK,DESCRIPTION,LOGTYPE,TABLE_,LOGRECID,CREATEDDATETIME,DEL_CREATEDTIME,CREATEDBY,CREATEDTRANSACTIONID,DATAAREAID,RECVERSION,RECID) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13)
(@P1 nvarchar(21),@P2 datetime,@P3 nvarchar(11))SELECT SUM(A.AMOUNTMST),SUM(A.AMOUNTCUR),A.ASSETTRANSTYPE,A.POSTINGTYPE,A.CURRENCYCODE,A.TRANSDATE FROM RASSETTRANS A WHERE ((DATAAREAID=N'3r') AND (((ACCOUNTNUM=@P1) AND (TRANSDATE<=@P2)) AND (ASSETSTANDARDID=@P3))) GROUP BY A.ASSETTRANSTYPE,A.POSTINGTYPE,A.CURRENCYCODE,A.TRANSDATE ORDER BY A.ASSETTRANSTYPE,A.POSTINGTYPE,A.CURRENCYCODE,A.TRANSDATE OPTION(FAST 1)

/*
Missing Index Details from ExecutionPlan1.sqlplan
The Query Processor estimates that implementing the following index could improve the query cost by 91.5458%.
*/

/*
USE [dixyprodnewdb]
GO
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[RASSETTRANS] ([ACCOUNTNUM],[ASSETSTANDARDID],[DATAAREAID],[TRANSDATE])
INCLUDE ([POSTINGTYPE],[ASSETTRANSTYPE],[AMOUNTCUR],[CURRENCYCODE],[AMOUNTMST])
GO
*/

by write

(@P1 numeric(28, 12),@P2 numeric(28, 12),@P3 int,@P4 datetime,@P5 int,@P6 datetime,@P7 nvarchar(5),@P8 bigint,@P9 int)UPDATE INVENTTRANS SET QTYSETTLED=@P1,COSTAMOUNTSETTLED=@P2,VALUEOPEN=@P3,DATECLOSED=@P4,RECVERSION=@P5,MODIFIEDDATETIME=@P6 WHERE (((DATAAREAID=@P7) AND (RECID=@P8)) AND (RECVERSION=@P9))
(@P1 bigint,@P2 nvarchar(21),@P3 nvarchar(21),@P4 datetime,@P5 nvarchar(21),@P6 nvarchar(21),@P7 numeric(28, 12),@P8 numeric(28, 12),@P9 numeric(28, 12),@P10 nvarchar(21),@P11 nvarchar(21),@P12 int,@P13 int,@P14 nvarchar(21),@P15 nvarchar(21),@P16 nvarchar(21),@P17 nvarchar(21),@P18 nvarchar(21),@P19 nvarchar(21),@P20 nvarchar(21),@P21 nvarchar(21),@P22 nvarchar(21),@P23 nvarchar(21),@P24 nvarchar(21),@P25 nvarchar(21),@P26 nvarchar(21),@P27 nvarchar(21),@P28 nvarchar(21),@P29 nvarchar(21),@P30 nvarchar(21),@P31 nvarchar(21),@P32 int,@P33 int,@P34 nvarchar(21),@P35 int,@P36 int,@P37 nvarchar(21),@P38 nvarchar(21),@P39 nvarchar(21),@P40 nvarchar(21),@P41 nvarchar(21),@P42 nvarchar(5),@P43 int,@P44 bigint)INSERT INTO INVENTSETTLEMENT (TRANSRECID,INVENTTRANSID,ITEMID,TRANSDATE,VOUCHER,SETTLETRANSID,QTYSETTLED,COSTAMOUNTSETTLED,COSTAMOUNTADJUSTMENT,BALANCESHEETACCOUNT,OPERATIONSACCOUNT,CANCELLED,SETTLEMODEL,DIMENSION,DIMENSION2_,DIMENSION3_,DIMENSION4_,DIMENSION5_,DIMENSION6_,DIMENSION7_,DIMENSION8_,DIMENSION9_,DIMENSION10_,DIMENSION11_,DIMENSION12_,DIMENSION13_,DIMENSION14_,DIMENSION15_,DIMENSION16_,DIMENSION17_,DIMENSION18_,BALANCESHEETPOSTING,OPERATIONSPOSTING,ITEMGROUPID,POSTED,SETTLETYPE,MARKUPCODE_RU,VENDINVOICEIDMARKUP_RU,VENDACCOUNTMARKUP_RU,BALANCESHEETACCOUNT2,OPERATIONSACCOUNT2,DATAAREAID,RECVERSION,RECID) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19,@P20,@P21,@P22,@P23,@P24,@P25,@P26,@P27,@P28,@P29,@P30,@P31,@P32,@P33,@P34,@P35,@P36,@P37,@P38,@P39,@P40,@P41,@P42,@P43,@P44)
(@P1 numeric(28, 12),@P2 numeric(28, 12),@P3 numeric(28, 12),@P4 int,@P5 datetime,@P6 int,@P7 datetime,@P8 nvarchar(5),@P9 bigint,@P10 int)UPDATE INVENTTRANS SET COSTAMOUNTADJUSTMENT=@P1,QTYSETTLED=@P2,COSTAMOUNTSETTLED=@P3,VALUEOPEN=@P4,DATECLOSED=@P5,RECVERSION=@P6,MODIFIEDDATETIME=@P7 WHERE (((DATAAREAID=@P8) AND (RECID=@P9)) AND (RECVERSION=@P10))
(@P1 numeric(28, 12),@P2 numeric(28, 12),@P3 int,@P4 datetime,@P5 nvarchar(5),@P6 bigint,@P7 int)UPDATE INVENTTRANS SET COSTAMOUNTADJUSTMENT=@P1,COSTAMOUNTSETTLED=@P2,RECVERSION=@P3,MODIFIEDDATETIME=@P4 WHERE (((DATAAREAID=@P5) AND (RECID=@P6)) AND (RECVERSION=@P7))
(@P1 nvarchar(21),@P2 int,@P3 datetime,@P4 numeric(28, 12),@P5 numeric(28, 12),@P6 nvarchar(4),@P7 int,@P8 nvarchar(21),@P9 nvarchar(21),@P10 nvarchar(21),@P11 nvarchar(21),@P12 datetime,@P13 datetime,@P14 numeric(28, 12),@P15 nvarchar(21),@P16 int,@P17 int,@P18 int,@P19 nvarchar(21),@P20 nvarchar(21),@P21 numeric(28, 12),@P22 datetime,@P23 datetime,@P24 numeric(28, 12),@P25 numeric(28, 12),@P26 int,@P27 int,@P28 datetime,@P29 numeric(28, 12),@P30 datetime,@P31 nvarchar(11),@P32 nvarchar(21),@P33 numeric(28, 12),@P34 nvarchar(21),@P35 nvarchar(21),@P36 nvarchar(11),@P37 nvarchar(21),@P38 int,@P39 datetime,@P40 nvarchar(21),@P41 nvarchar(21),@P42 int,@P43 numeric(28, 12),@P44 numeric(28, 12),@P45 nvarchar(21),@P46 bigint,@P47 int,@P48 int,@P49 nvarchar(21),@P50 nvarchar(21),@P51 nvarchar(21),@P52 nvarchar(21),@P53 int,@P54 nvarchar(21),@P55 numeric(28, 12),@P56 numeric(28, 12),@P57 int,@P58 nvarchar(21),@P59 int,@P60 datetime,@P61 datetime,@P62 nvarchar(6),@P63 nvarchar(5),@P64 int,@P65 bigint)INSERT INTO INVENTTRANS (ITEMID,STATUSISSUE,DATEPHYSICAL,QTY,COSTAMOUNTPOSTED,CURRENCYCODE,TRANSTYPE,TRANSREFID,INVOICEID,VOUCHER,INVENTTRANSIDTRANSFER,DATEEXPECTED,DATEFINANCIAL,COSTAMOUNTPHYSICAL,INVENTTRANSID,STATUSRECEIPT,PACKINGSLIPRETURNED,INVOICERETURNED,PACKINGSLIPID,VOUCHERPHYSICAL,COSTAMOUNTADJUSTMENT,SHIPPINGDATEREQUESTED,SHIPPINGDATECONFIRMED,QTYSETTLED,COSTAMOUNTSETTLED,VALUEOPEN,DIRECTION,DATESTATUS,COSTAMOUNTSTD,DATECLOSED,PICKINGROUTEID,INVENTTRANSIDFATHER,COSTAMOUNTOPERATIONS,ITEMBOMID,INVENTTRANSIDRETURN,PROJID,INVENTDIMID,INVENTDIMFIXED,DATEINVENT,CUSTVENDAC,TRANSCHILDREFID,TRANSCHILDTYPE,REVENUEAMOUNTPHYSICAL,TAXAMOUNTPHYSICAL,INVENTREFTRANSID,NONFINANCIALTRANSFERINVENTCL73,STORNO_RU,STORNOPHYSICAL_RU,INVENTDIMIDSALES_RU,INVENTTRANSIDSALES_RU,INVENTTRANSIDTRANSIT_RU,INVENTTRANSIDDELIVERY_RU,GROUPREFTYPE_RU,GROUPREFID_RU,INVOICEAMOUNTTAX,INVOICEAMOUNT,INVENTSTATETYPE,INVENTSTATEID,INVENTREFTRANSLOCKTYPE,MODIFIEDDATETIME,CREATEDDATETIME,CREATEDBY,DATAAREAID,RECVERSION,RECID) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18,@P19,@P20,@P21,@P22,@P23,@P24,@P25,@P26,@P27,@P28,@P29,@P30,@P31,@P32,@P33,@P34,@P35,@P36,@P37,@P38,@P39,@P40,@P41,@P42,@P43,@P44,@P45,@P46,@P47,@P48,@P49,@P50,@P51,@P52,@P53,@P54,@P55,@P56,@P57,@P58,@P59,@P60,@P61,@P62,@P63,@P64,@P65)