[20220421]为什么说华为监控是垃圾.txt

[20220421]为什么说华为监控是垃圾.txt --//前一阵子跟别人聊天提到的情况，我可不是乱讲。 > @ ver1 PORT_STRING                    VERSION        BANNER ------------------------------ -------------- -------------------------------------------------------------------------------- x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production > @ ashtop sql_id,machine,client_id 1=1 &day   Total                                                                                                            Distinct Distinct Seconds  AAS %This   SQL_ID        MACHINE               CLIENT_ID       FIRST_SEEN          LAST_SEEN           Execs Seen  Tstamps ------- ---- ------- ------------- --------------------- --------------- ------------------- ------------------- ---------- --------    5490   .1    7% |               fyhis2                127.0.0.1       2022-04-20 19:30:08 2022-04-21 01:32:28          1     1035    4606   .1    6% | 0sd3pynbkmuhv localhost.localdomain 192.168.xxx.zzz 2022-04-20 08:39:18 2022-04-21 08:37:05        288     4592    3519   .0    5% |               fyhis1                                2022-04-20 08:37:47 2022-04-21 08:37:34          1     3411    2758   .0    4% |               fyhis2                                2022-04-20 08:37:56 2022-04-21 08:36:34          1     2668    2141   .0    3% | 8ss7js42xzp05 H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:39 2022-04-21 08:34:58        288     2141    1944   .0    3% | 8ss7js42xzp05 H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:22 2022-04-21 08:33:27        288     1944     980   .0    1% | 8fm0xfacp0b0g H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:30 2022-04-21 08:34:46        288      980     949   .0    1% | 8fm0xfacp0b0g H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:14 2022-04-21 08:33:16        288      949     910   .0    1% | f454ryjfx6syf H3C-APM               192.168.xxx.AAA 2022-04-20 08:39:10 2022-04-21 08:35:25        288      910     866   .0    1% | 6mnrdrgdys4uc localhost.localdomain 192.168.101.127 2022-04-20 08:37:43 2022-04-21 08:36:54        772      866     833   .0    1% | f454ryjfx6syf H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:49 2022-04-21 08:33:51        288      833     681   .0    1% | 3x6svwrf53974 WORKGROUP\PC--GYWA    192.168.AA.BB   2022-04-20 10:16:47 2022-04-20 17:51:24        681      681     604   .0    1% | c3jafyjuwt13b H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:18 2022-04-21 08:34:33        288      604     577   .0    1% | 6wcywxctbbvs8 localhost.localdomain 192.168.xxx.zzz 2022-04-20 08:39:15 2022-04-21 08:36:57        288      577     547   .0    1% | czkw1ncpthxy4 H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:24 2022-04-21 08:34:38        288      547     543   .0    1% | c3jafyjuwt13b H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:02 2022-04-21 08:33:03        288      543     541   .0    1% | 0zrwxj39q7u3w H3C-APM               192.168.xxx.AAA 2022-04-20 08:39:03 2022-04-21 08:35:17        288      541     540   .0    1% | d946h5sr5gt69 H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:54 2022-04-21 08:35:08        288      540     536   .0    1% | 0tha0zcyf9maq H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:34 2022-04-21 08:34:48        288      536     536   .0    1% | 8sxz1p1238fyh H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:10 2022-04-21 08:33:10        288      536     535   .0    1% | f6d0fpgm1w2sw H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:47 2022-04-21 08:35:01        288      535     519   .0    1% | 18q3m92yk5zg5 H3C-APM               192.168.xxx.AAA 2022-04-20 08:39:05 2022-04-21 08:35:19        288      519     519   .0    1% | 30a5bma58q1w7 H3C-APM               192.168.xxx.AAA 2022-04-20 08:39:07 2022-04-21 08:35:21        288      519     518   .0    1% | 0zrwxj39q7u3w H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:43 2022-04-21 08:33:43        288      518     518   .0    1% | czkw1ncpthxy4 H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:07 2022-04-21 08:33:07        288      518     518   .0    1% | d946h5sr5gt69 H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:35 2022-04-21 08:33:35        288      518     513   .0    1% | 5mwanf0c830mj H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:52 2022-04-21 08:35:06        288      513     513   .0    1% | 6sbq34x7ckff7 H3C-APM               192.168.xxx.AAA 2022-04-20 08:38:28 2022-04-21 08:34:42        288      513     513   .0    1% | f6d0fpgm1w2sw H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:28 2022-04-21 08:33:29        288      513     504   .0    1% | 0tha0zcyf9maq H3C-Ucenter           192.168.xxx.BBB 2022-04-20 08:38:17 2022-04-21 08:33:17        288      504 30 rows selected. --//你可以发现通过ashtop看到基本都是华为监控，而且居然使用两台设备，实际上localhost.localdomain是另外一台厂家的监控。 --//你可以讲服务器基本没有什么负载，我查看的是一天的情况。仅仅1条语句需要注意的sql_id=3x6svwrf53974。 --//可以讲服务器超级强劲,简直就是大马拉小车.ashtop排名靠前的语句全部是监控语句. --//可以如果看看监控执行的语句对于问题诊断一点意义都没有，不是垃圾还是什么。 --//实际上许多厂家,相关部门简直就是借着等保的幌子做毫无意义的工作. --//只能改成如下，取消监控的信息。 > @ ashtop sql_id,machine,client_id "client_id not in ('192.168.xxx.AAA','192.168.xxx.BBB','192.168.xxx.zzz')" &day