11 2021 档案

摘要:events select date_format(from_unixtime(clock),'%Y-%m-%d')time,name,count(*) from events where name like '%frequent%' and value=0 group by date_format 阅读全文
posted @ 2021-11-23 09:26 sam_wang10 阅读(57) 评论(0) 推荐(0)
摘要:vim /etc/odbcinst.ini 创建监控账号 use master EXEC sp_addlogin 'zbx_monitor', 'Pas5W@0rd', 'master' USE [master] GO GRANT VIEW ANY DATABASE TO [zbx_monitor] 阅读全文
posted @ 2021-11-18 15:12 sam_wang10 阅读(39) 评论(0) 推荐(0)
摘要:Top 50 CPU Consuming Queries in SQL Server Select st.[text] AS [Query Text], wt.last_execution_time AS [Last Execution Time], wt.execution_count AS [E 阅读全文
posted @ 2021-11-05 10:57 sam_wang10 阅读(61) 评论(0) 推荐(0)