[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