|
|
SQL ordered by Executions DB/Inst: WBOEE/wboee Snaps: 13008-13009
-> Total Executions: 724,837
-> Captured SQL account for 74.7% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
84,097 84,097 1.0 0.00 0.00 am4v2zz7drutt
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA046'
36,267 36,267 1.0 0.00 0.00 9czxjvx7h7cky
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA032'
34,947 34,947 1.0 0.00 0.00 1h66zxm5p1mxj
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA030'
33,638 33,636 1.0 0.00 0.00 fvfpntmzfx03v
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA012'
32,528 32,527 1.0 0.00 0.00 0urz6v076pjm8
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA002'
21,877 21,877 1.0 0.00 0.00 768zyazrjum5c
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA047'
21,325 21,325 1.0 0.00 0.00 4sds332mqjpm8
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA004'
20,158 20,158 1.0 0.00 0.00 c040pnhc9k3u6
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA042'
14,533 14,533 1.0 0.00 0.00 87rpw03nv8f0y
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA036'
13,501 13,501 1.0 0.00 0.00 63v0j63cznv3c
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA034'
13,044 13,044 1.0 0.00 0.00 3htd96pffuggh
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA024'
12,897 12,897 1.0 0.00 0.00 7x295spnp4czg
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA040'
12,094 12,094 1.0 0.00 0.00 g90bg471qfpx2
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA015'
12,017 12,017 1.0 0.00 0.00 gaham044hzszh
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA031'
11,804 11,804 1.0 0.00 0.00 91wqdg08cyr6d
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA010'
SQL ordered by Executions DB/Inst: WBOEE/wboee Snaps: 13008-13009
-> Total Executions: 724,837
-> Captured SQL account for 74.7% of Total
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) SQL Id
------------ --------------- -------------- ---------- ----------- -------------
11,744 11,744 1.0 0.00 0.00 9207dfhsqpnat
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA003'
11,741 11,741 1.0 0.00 0.00 9gy7hsc77w5gx
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA021'
11,550 11,550 1.0 0.00 0.00 4y0y4xvuqp4s7
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA057'
11,550 11,550 1.0 0.00 0.00 agywsp61q2hth
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'DA304'
11,283 11,283 1.0 0.00 0.00 cv0ufrcytaqgw
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA027'
11,125 11,125 1.0 0.00 0.00 2rkmhw9jypdsh
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA033'
11,030 11,030 1.0 0.00 0.00 8bm2rpcbxsq1u
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA016'
10,544 10,544 1.0 0.00 0.00 9jx4w0d8nrkw8
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA020'
9,759 9,759 1.0 0.00 0.00 baywdrj65vtdj
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA028'
8,593 8,593 1.0 0.00 0.00 49z8s6tbuqxgd
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA029'
8,484 8,484 1.0 0.00 0.00 3xaytqagwc7qs
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA043'
8,127 8,127 1.0 0.00 0.00 5cd7tuqbzm4z9
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA045'
7,853 7,853 1.0 0.00 0.00 301qwraq33jp3
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA055'
7,842 7,842 1.0 0.00 0.00 9112hrj7d832p
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA007'
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: WBOEE/wboee Snaps: 13008-13009
-> Total Parse Calls: 622,829
-> Captured SQL account for 85.4% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
84,097 84,097 13.50 am4v2zz7drutt
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA046'
36,267 36,267 5.82 9czxjvx7h7cky
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA032'
34,947 34,947 5.61 1h66zxm5p1mxj
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA030'
33,638 33,638 5.40 fvfpntmzfx03v
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA012'
32,528 32,528 5.22 0urz6v076pjm8
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA002'
21,877 21,877 3.51 768zyazrjum5c
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA047'
21,325 21,325 3.42 4sds332mqjpm8
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA004'
20,158 20,158 3.24 c040pnhc9k3u6
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA042'
14,533 14,533 2.33 87rpw03nv8f0y
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA036'
13,501 13,501 2.17 63v0j63cznv3c
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA034'
13,044 13,044 2.09 3htd96pffuggh
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA024'
12,897 12,897 2.07 7x295spnp4czg
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA040'
12,094 12,094 1.94 g90bg471qfpx2
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA015'
12,017 12,017 1.93 gaham044hzszh
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA031'
11,804 11,804 1.90 91wqdg08cyr6d
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA010'
SQL ordered by Parse Calls DB/Inst: WBOEE/wboee Snaps: 13008-13009
-> Total Parse Calls: 622,829
-> Captured SQL account for 85.4% of Total
% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
11,744 11,744 1.89 9207dfhsqpnat
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA003'
11,741 11,741 1.89 9gy7hsc77w5gx
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA021'
11,550 11,550 1.85 4y0y4xvuqp4s7
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA057'
11,550 11,550 1.85 agywsp61q2hth
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'DA304'
11,283 11,283 1.81 cv0ufrcytaqgw
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA027'
11,125 11,125 1.79 2rkmhw9jypdsh
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA033'
11,030 11,030 1.77 8bm2rpcbxsq1u
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA016'
10,544 10,544 1.69 9jx4w0d8nrkw8
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA020'
9,759 9,759 1.57 baywdrj65vtdj
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA028'
8,593 8,593 1.38 49z8s6tbuqxgd
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA029'
8,484 8,484 1.36 3xaytqagwc7qs
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA043'
8,127 8,127 1.30 5cd7tuqbzm4z9
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA045'
7,853 7,853 1.26 301qwraq33jp3
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA055'
7,842 7,842 1.26 9112hrj7d832p
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA007'
7,054 7,054 1.13 dskmcy4j887ps
Module: GenericHost.exe
select DRIVER_MODEL from DARMS_EQUIP_INFO where EQUIP_ID = 'BDA050'
-------------------------------------------------------------
SQL ordered by Sharable Memory DB/Inst: WBOEE/wboee Snaps: 13008-13009
-> Only Statements with Sharable Memory greater than 1048576 are displayed
Sharable Mem (b) Executions % Total SQL Id
---------------- ------------ -------- -------------
1,452,015 8 0.21 gqh6pxz10tpnz
Module: w3wp.exe
INSERT INTO elog_opr_tbl (dept, machine_id, lotid, empid, elogsheet_type, groupi
d, pkg_type, pkg_body_size, cust_name, device_no, lead_count, lot_qty, da_cure,
plasma, strips_qty, shift, mcomp_part_no, mcomp_batch_lot, mcomp_exp_date, time_
checked, fol_cr_no, eol_mag_no, pcb_thickness, inspect_prod, inspect_air_vent, i
-------------------------------------------------------------
这样的语句会不会我这个ｃａｓｅ的主要原因？
大家看看啊。 |
|
楼主: seamanczg1984
IP卡
狗仔卡
楼主
显身卡