Home
- Details
- Written by: po3dno
- Category: MariaDB
- Hits: 3
-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: vm-ws-stat-db02:3306
-- Generation Time: Oct 15, 2026 at 10:15 AM
-- Server version: 10.6.17-MariaDB
-- PHP Version: 8.3.4
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `auth`
--
DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`s.barkov`@`%` PROCEDURE `create_new_partitions` (IN `p_schema` VARCHAR(64), IN `p_table` VARCHAR(64), IN `p_days_to_add` INT) SQL SECURITY INVOKER BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE current_partition_name varchar(64);
DECLARE current_partition_ts int;
-- We'll use this cursor later to check
-- whether a particular already exists.
-- @partition_name_to_add will be
-- set later.
DECLARE cur1 CURSOR FOR
SELECT partition_name
FROM information_schema.partitions
WHERE TABLE_SCHEMA = p_schema
AND TABLE_NAME = p_table
AND PARTITION_NAME != 'p_first'
AND PARTITION_NAME != 'p_future'
AND PARTITION_NAME = @partition_name_to_add;
-- We'll also use this cursor later
-- to query our temporary table.
DECLARE cur2 CURSOR FOR
SELECT partition_name, partition_range_ts
FROM partitions_to_add;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
DROP TEMPORARY TABLE IF EXISTS partitions_to_add;
CREATE TEMPORARY TABLE partitions_to_add (
partition_name varchar(64),
partition_range_ts int
);
SET @partitions_added = FALSE;
SET @days_ahead = 0;
-- Let's go through a loop and add each day individually between
-- the current day and the day p_day_to_add in the future.
WHILE @days_ahead <= p_days_to_add DO
-- We figure out what the correct month is by adding the
-- number of months to the current date
SET @date = CURDATE();
SET @q = 'SELECT DATE_ADD(?, INTERVAL ? DAY) INTO @day_to_add';
PREPARE st FROM @q;
EXECUTE st USING @date, @days_ahead;
DEALLOCATE PREPARE st;
SET @days_ahead = @days_ahead + 1;
-- Then we format the month in the same format used
-- in our partition names.
SET @q = 'SELECT DATE_FORMAT(@day_to_add, ''%Y%m%d'') INTO @formatted_day_to_add';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
-- And then we use the formatted date to build the name of the
-- partition that we want to add. This partition name is
-- assigned to @partition_name_to_add, which is used in
-- the cursor declared at the start of the procedure.
SET @q = 'SELECT CONCAT(''p'', @formatted_day_to_add) INTO @partition_name_to_add';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
SET done = FALSE;
SET @first = TRUE;
-- And then we loop through the results returned by the cursor,
-- and if a row already exists for the current partition,
-- then we do not need to create the partition.
OPEN cur1;
read_loop: LOOP
FETCH cur1 INTO current_partition_name;
-- The cursor returned 0 rows, so we can create the partition.
IF done AND @first THEN
SELECT CONCAT('Creating partition: ', @partition_name_to_add);
-- Now we need to get the end date of the new partition.
-- Note that the date is for the non-inclusive end range,
-- so we actually need the date of the first day of the *next* month.
-- First, let's get a date variable for the first of the partition month
SET @q = 'SELECT DATE_FORMAT(@day_to_add, ''%Y-%m-%d 00:00:00'') INTO @day_to_add';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
-- Then, let's add 1 month
SET @q = 'SELECT DATE_ADD(?, INTERVAL 1 DAY) INTO @partition_end_date';
PREPARE st FROM @q;
EXECUTE st USING @day_to_add;
DEALLOCATE PREPARE st;
-- We need the date in UNIX timestamp format.
SELECT UNIX_TIMESTAMP(@partition_end_date) INTO @partition_end_ts;
-- Now insert the information into our temporary table
INSERT INTO partitions_to_add VALUES (@partition_name_to_add, @partition_end_ts);
SET @partitions_added = TRUE;
END IF;
-- Since we had at least one row returned, we know the
-- partition already exists.
IF ! @first THEN
LEAVE read_loop;
END IF;
SET @first = FALSE;
END LOOP;
CLOSE cur1;
END WHILE;
-- Let's actually add the partitions now.
IF @partitions_added THEN
-- First we need to build the actual ALTER TABLE query.
SET @schema = p_schema;
SET @table = p_table;
SET @q = 'SELECT CONCAT(''ALTER TABLE '', @schema, ''.'', @table, '' REORGANIZE PARTITION p_future INTO ( '') INTO @query';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
SET done = FALSE;
SET @first = TRUE;
OPEN cur2;
read_loop: LOOP
FETCH cur2 INTO current_partition_name, current_partition_ts;
IF done THEN
LEAVE read_loop;
END IF;
-- If it is not the first partition,
-- then we need to add a comma
IF ! @first THEN
SET @q = 'SELECT CONCAT(@query, '', '') INTO @query';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
END IF;
-- Add the current partition
SET @partition_name = current_partition_name;
SET @partition_ts = current_partition_ts;
SET @q = 'SELECT CONCAT(@query, ''PARTITION '', @partition_name, '' VALUES LESS THAN ('', @partition_ts, '')'') INTO @query';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
SET @first = FALSE;
END LOOP;
CLOSE cur2;
-- We also need to include the p_future partition
SET @q = 'SELECT CONCAT(@query, '', PARTITION p_future VALUES LESS THAN (MAXVALUE))'') INTO @query';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
-- And then we prepare and execute the ALTER TABLE query.
PREPARE st FROM @query;
EXECUTE st;
DEALLOCATE PREPARE st;
END IF;
DROP TEMPORARY TABLE partitions_to_add;
END$$
CREATE DEFINER=`s.barkov`@`%` PROCEDURE `drop_old_partitions` (`p_schema` VARCHAR(64), `p_table` VARCHAR(64), `p_months_to_keep` INT, `p_seconds_to_sleep` INT) SQL SECURITY INVOKER BEGIN
DECLARE done INT DEFAULT FALSE;
DECLARE current_partition_name varchar(64);
-- We'll use this cursor later to get
-- the list of partitions to drop.
-- @last_partition_name_to_keep will be
-- set later.
DECLARE cur1 CURSOR FOR
SELECT partition_name
FROM information_schema.partitions
WHERE TABLE_SCHEMA = p_schema
AND TABLE_NAME = p_table
AND PARTITION_NAME != 'p_first'
AND PARTITION_NAME != 'p_future'
AND PARTITION_NAME < @last_partition_name_to_keep;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
-- Now we get the last month of data that we want to keep
-- by subtracting p_months_to_keep from the current date.
-- Note that it will actually keep p_months_to_keep+1 partitions,
-- since the current month is not complete.
SET @date = CURDATE();
SET @months_to_keep = p_months_to_keep;
SET @q = 'SELECT DATE_SUB(?, INTERVAL ? MONTH) INTO @last_month_to_keep';
PREPARE st FROM @q;
EXECUTE st USING @date, @months_to_keep;
DEALLOCATE PREPARE st;
-- Then we format the last month in the same format used
-- in our partition names.
SET @q = 'SELECT DATE_FORMAT(@last_month_to_keep, ''%Y%m'') INTO @formatted_last_month_to_keep';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
-- And then we use the formatted date to build the name of the
-- last partition that we want to keep. This partition name is
-- assigned to @last_partition_name_to_keep, which is used in
-- the cursor declared at the start of the procedure.
SET @q = 'SELECT CONCAT(''p'', @formatted_last_month_to_keep) INTO @last_partition_name_to_keep';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
SELECT CONCAT('Dropping all partitions before: ', @last_partition_name_to_keep);
SET @first = TRUE;
-- And then we loop through all partitions returned by the cursor,
-- and those partitions are dropped.
OPEN cur1;
read_loop: LOOP
FETCH cur1 INTO current_partition_name;
IF done THEN
LEAVE read_loop;
END IF;
IF ! @first AND p_seconds_to_sleep > 0 THEN
SELECT CONCAT('Sleeping for ', p_seconds_to_sleep, ' seconds');
SELECT SLEEP(p_seconds_to_sleep);
END IF;
SELECT CONCAT('Dropping partition: ', current_partition_name);
-- First we build the ALTER TABLE query.
SET @schema = p_schema;
SET @table = p_table;
SET @partition = current_partition_name;
SET @q = 'SELECT CONCAT(''ALTER TABLE '', @schema, ''.'', @table, '' DROP PARTITION '', @partition) INTO @query';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
-- And then we prepare and execute the ALTER TABLE query.
PREPARE st FROM @query;
EXECUTE st;
DEALLOCATE PREPARE st;
SET @first = FALSE;
END LOOP;
CLOSE cur1;
-- If no partitions were dropped, then we can also skip this.
IF ! @first THEN
-- Then we need to get the date of the new first partition.
-- We need the date in UNIX timestamp format.
SET @q = 'SELECT DATE_FORMAT(@last_month_to_keep, ''%Y-%m-01 00:00:00'') INTO @new_first_partition_date';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
SELECT UNIX_TIMESTAMP(@new_first_partition_date) INTO @new_first_partition_ts;
-- We also need to get the date of the second partition
-- since the second partition is also needed for REORGANIZE PARTITION.
SET @q = 'SELECT DATE_ADD(@new_first_partition_date, INTERVAL 1 MONTH) INTO @second_partition_date';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
SELECT UNIX_TIMESTAMP(@second_partition_date) INTO @second_partition_ts;
SELECT CONCAT('Reorganizing first and second partitions. first partition date = ', @new_first_partition_date, ', second partition date = ', @second_partition_date);
-- Then we build the ALTER TABLE query.
SET @schema = p_schema;
SET @table = p_table;
SET @q = 'SELECT CONCAT(''ALTER TABLE '', @schema, ''.'', @table, '' REORGANIZE PARTITION p_first, '', @last_partition_name_to_keep, '' INTO ( PARTITION p_first VALUES LESS THAN ( '', @new_first_partition_ts, '' ), PARTITION '', @last_partition_name_to_keep, '' VALUES LESS THAN ( '', @second_partition_ts, '' ) ) '') INTO @query';
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
-- And then we prepare and execute the ALTER TABLE query.
PREPARE st FROM @query;
EXECUTE st;
DEALLOCATE PREPARE st;
END IF;
END$$
CREATE DEFINER=`s.barkov`@`%` PROCEDURE `perform_partition_maintenance` (`p_schema` VARCHAR(64), `p_table` VARCHAR(64), `p_months_to_add` INT, `p_months_to_keep` INT, `p_seconds_to_sleep` INT) SQL SECURITY INVOKER BEGIN
CALL auth.drop_old_partitions(p_schema, p_table, p_months_to_keep, p_seconds_to_sleep);
CALL auth.create_new_partitions(p_schema, p_table, p_months_to_add);
END$$
DELIMITER ;
-- --------------------------------------------------------
--
-- Table structure for table `ecode`
--
CREATE TABLE `ecode` (
`id` int(11) NOT NULL,
`eventid` int(11) NOT NULL,
`status` varchar(10) DEFAULT NULL,
`kerberos` tinytext DEFAULT NULL,
`text` tinytext DEFAULT NULL,
`comment` varchar(20) DEFAULT NULL,
`showlog` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
--
-- Dumping data for table `ecode`
--
INSERT INTO `ecode` (`id`, `eventid`, `status`, `kerberos`, `text`, `comment`, `showlog`) VALUES
(1, 4769, '0x12', 'Clients credentials have been revoked', 'Account disabled, expired, locked out, logon hours.', NULL, 0),
(2, 4771, '0x18', 'Pre-authentication information was invalid', 'Usually means bad password', 'Возможная причина', 1),
(3, 4768, '0x12', 'Clients credentials have been revoked', 'Account disabled, expired, locked out, logon hours.', NULL, 0),
(4, 4768, '0x6', 'Client not found in Kerberos database', 'Bad user name, or new computer/user account has not replicated to DC yet', NULL, 0),
(5, 4625, '0xc000006e', 'An account failed to log on', 'Unknown user name or bad password.', 'Причина', 1),
(6, 4776, '0xc0000072', 'The domain controller attempted to validate the credentials for an account', 'account is currently disabled', '', 0),
(7, 4625, '0xc0000234', 'An account failed to log on', 'user is currently locked out', 'Попытка входа', 0),
(9, 4625, '0xc000006d', 'An account failed to log on', 'This is either due to a bad username or authentication information', 'Причина', 1),
(10, 4776, '0xc000006a', 'The domain controller attempted to validate the credentials for an account', 'user name is correct but the password is wrong', 'Возможная причина', 1),
(11, 4776, '0xc0000234', 'The domain controller attempted to validate the credentials for an account', 'user is currently locked out', 'Следствие', 0),
(12, 4625, '0xc0000070', 'User logon from unauthorized workstation', 'User logon from unauthorized workstation', 'Попытка входа', 0),
(13, 4625, '0xc0000071', 'User logon with expired password', 'User logon with expired password', 'Попытка входа', 0),
(14, 4625, '0xc0000133', 'Clocks between DC and other computer too far out of sync', 'Clocks between DC and other computer too far out of sync', 'Попытка входа', 0),
(15, 4740, NULL, 'A user account was locked out', 'The indicated user account was locked out after repeated logon failures due to a bad password. See event ID 4767 for account unlocked.', 'Блокировка УЗ', 1),
(16, 4767, NULL, 'A user account was unlocked', 'The user identified by Subject: unlocked the user identified by Target Account:', 'Разблокировка УЗ', 1),
(17, 4723, NULL, 'An attempt was made to change an account\'s password', 'The user attempted to change his/her own password. Subject and Target should always match. ', 'Смена пароля', 1),
(18, 4724, NULL, 'An attempt was made to reset an accounts password', 'The Subject attempted to reset the password of the Target: ', 'Смена пароля', 1),
(19, 4625, '0xc000018b', 'STATUS_NO_TRUST_SAM_ACCOUNT', 'The SAM database on the Windows Server does not have a computer account for this workstation trust relationship.', '', 1),
(20, 4768, '0x17', 'Password has expired', 'The user’s password has expired.', 'Попытка входа', 0),
(21, 4769, '0x1b', 'Server principal valid for user2user only', 'This error occurs because the service is missing an SPN.\r\n', 'Попытка входа', 0),
(22, 4776, '0xc0000064', 'The domain controller attempted to validate the credentials for an account', 'user name does not exist', 'Следствие', 0),
(23, 4776, '0xc0000071', 'The domain controller attempted to validate the credentials for an account', 'expired password', '', 0),
(24, 4776, '0xc0000173', 'The domain controller attempted to validate the credentials for an account', 'account expiration', '', 0),
(25, 4776, '0xc0000371', 'The domain controller attempted to validate the credentials for an account', 'The local account store does not contain secret material for the specified account.', '', 0),
(26, 4776, '0xc0000199', 'STATUS_NOLOGON_WORKSTATION_TRUST_ACCOUNT', 'The account used is a computer account. Use your global user account or local user account to access this server.', '', 0),
(27, 4776, '0xc000019a', 'STATUS_NOLOGON_SERVER_TRUST_ACCOUNT', 'The account used is a server trust account. Use your global user account or local user account to access this server.', '', 0),
(28, 4771, '0x12', 'KDC_ERR_CLIENT_REVOKED', 'KDC_ERR_CLIENT_REVOKED', '', 1),
(29, 4771, '0x3c', 'Kerberos pre-authentication failed', 'Generic error (description in e-text)', NULL, 1);
-- --------------------------------------------------------
--
-- Table structure for table `ejson`
--
CREATE TABLE `ejson` (
`id` bigint(20) UNSIGNED NOT NULL,
`dt` datetime NOT NULL DEFAULT current_timestamp(),
`data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`data`)),
`EventID` int(11) GENERATED ALWAYS AS (json_value(`data`,'$.System.EventID')) VIRTUAL,
`Computer` varchar(30) GENERATED ALWAYS AS (json_value(`data`,'$.System.Computer')) VIRTUAL,
`SubjectUserName` varchar(50) GENERATED ALWAYS AS (json_value(`data`,'$.EventData.SubjectUserName')) VIRTUAL,
`TargetUserName` varchar(50) GENERATED ALWAYS AS (json_value(`data`,'$.EventData.TargetUserName')) VIRTUAL,
`TargetDomainName` varchar(50) GENERATED ALWAYS AS (json_value(`data`,'$.EventData.TargetDomainName')) VIRTUAL,
`ServiceName` varchar(50) GENERATED ALWAYS AS (json_value(`data`,'$.EventData.ServiceName')) VIRTUAL,
`IpAddress` varchar(50) GENERATED ALWAYS AS (json_value(`data`,'$.EventData.IpAddress')) VIRTUAL,
`Status` varchar(12) GENERATED ALWAYS AS (json_value(`data`,'$.EventData.Status')) VIRTUAL,
`SystemTime` varchar(30) GENERATED ALWAYS AS (json_value(`data`,'$.System.TimeCreated."@SystemTime"')) VIRTUAL,
`Workstation` varchar(30) GENERATED ALWAYS AS (json_value(`data`,'$.EventData.Workstation')) VIRTUAL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
PARTITION BY RANGE (to_days(`dt`))
(
PARTITION p_first VALUES LESS THAN (0) ENGINE=InnoDB,
PARTITION p_20261012 VALUES LESS THAN (740267) ENGINE=InnoDB,
PARTITION p_20261013 VALUES LESS THAN (740268) ENGINE=InnoDB,
PARTITION p_20261014 VALUES LESS THAN (740269) ENGINE=InnoDB,
PARTITION p_20261015 VALUES LESS THAN (740270) ENGINE=InnoDB,
PARTITION p_20261016 VALUES LESS THAN (740271) ENGINE=InnoDB,
PARTITION p_future VALUES LESS THAN MAXVALUE ENGINE=InnoDB
);
-- --------------------------------------------------------
--
-- Table structure for table `stat`
--
CREATE TABLE `stat` (
`id` int(11) NOT NULL,
`login` varchar(50) NOT NULL,
`count` int(10) UNSIGNED NOT NULL DEFAULT 0,
`updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `ecode`
--
ALTER TABLE `ecode`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ejson`
--
ALTER TABLE `ejson`
ADD PRIMARY KEY (`id`,`dt`),
ADD KEY `EventID` (`EventID`),
ADD KEY `Computer` (`Computer`),
ADD KEY `TargetUserName` (`TargetUserName`),
ADD KEY `TargetDomainName` (`TargetDomainName`),
ADD KEY `ServiceName` (`ServiceName`),
ADD KEY `IpAddress` (`IpAddress`),
ADD KEY `Status` (`Status`),
ADD KEY `SystemTime` (`SystemTime`),
ADD KEY `Workstation` (`Workstation`),
ADD KEY `SubjectUserName` (`SubjectUserName`);
--
-- Indexes for table `stat`
--
ALTER TABLE `stat`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `ecode`
--
ALTER TABLE `ecode`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `ejson`
--
ALTER TABLE `ejson`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16434762509;
--
-- AUTO_INCREMENT for table `stat`
--
ALTER TABLE `stat`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
DELIMITER $$
--
-- Events
--
CREATE DEFINER=`s.barkov`@`%` EVENT `create_partition_ejson` ON SCHEDULE EVERY 1 MONTH STARTS '2021-02-01 00:00:00' ON COMPLETION PRESERVE DISABLE DO CALL auth.create_new_partitions('auth', 'ejson', 1)$$
CREATE DEFINER=`s.barkov`@`%` EVENT `create_partition_ejson_day` ON SCHEDULE EVERY 1 DAY STARTS '2021-02-10 00:05:00' ON COMPLETION PRESERVE ENABLE DO BEGIN
SELECT CONCAT('ALTER TABLE ejson REORGANIZE PARTITION p_future INTO (PARTITION ', concat('p_', DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 1 DAY), '%Y%m%d')), ' VALUES LESS THAN (TO_DAYS(''', DATE_ADD(CURDATE(), INTERVAL 2 DAY), ''')), PARTITION p_future VALUES LESS THAN (MAXVALUE))') INTO @q;
PREPARE st FROM @q;
EXECUTE st;
DEALLOCATE PREPARE st;
SELECT CONCAT('ALTER TABLE `ejson` DROP PARTITION ', concat('p_', DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL - 4 DAY), '%Y%m%d'))) into @q2;
PREPARE st2 FROM @q2;
EXECUTE st2;
DEALLOCATE PREPARE st2;
END$$
DELIMITER ;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- Details
- Written by: po3dno
- Category: Windows
- Hits: 28
Accordion summary…
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"target": {
"limit": 100,
"matchAny": false,
"tags": [],
"type": "dashboard"
},
"type": "dashboard"
}
]
},
"description": "Monitoring microsoft Active Directory",
"editable": true,
"fiscalYearStartMonth": 0,
"gnetId": 13466,
"graphTooltip": 1,
"id": 213,
"links": [],
"liveNow": false,
"panels": [
{
"collapsed": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 0
},
"id": 41,
"panels": [],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"refId": "A"
}
],
"title": "Resource overview",
"type": "row"
},
{
"columns": [],
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fontSize": "80%",
"gridPos": {
"h": 12,
"w": 24,
"x": 0,
"y": 1
},
"id": 45,
"showHeader": true,
"sort": {
"col": 4,
"desc": false
},
"styles": [
{
"alias": "operating system",
"align": "auto",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "product",
"preserveFormat": false,
"sanitize": false,
"thresholds": [],
"type": "string",
"unit": "short",
"valueMaps": []
},
{
"alias": "hostname",
"align": "auto",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": false,
"linkTooltip": "",
"linkUrl": "",
"mappingType": 1,
"pattern": "hostname",
"preserveFormat": false,
"thresholds": [],
"type": "string",
"unit": "short"
},
{
"alias": "instance",
"align": "auto",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": true,
"linkTargetBlank": false,
"linkTooltip": "${__cell_4}",
"linkUrl": "/d/Kdh0OoSGz/?var-job=${__cell_5}&var-hostname=All&var-instance=${__cell_4}",
"mappingType": 1,
"pattern": "instance",
"thresholds": [],
"type": "string",
"unit": "short"
},
{
"alias": "CPUs",
"align": "auto",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Value #B",
"thresholds": [],
"type": "string",
"unit": "short"
},
{
"alias": "RAM",
"align": "auto",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"mappingType": 1,
"pattern": "Value #C",
"thresholds": [],
"type": "number",
"unit": "bytes"
},
{
"alias": "uptime",
"align": "auto",
"colorMode": "cell",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"mappingType": 1,
"pattern": "Value #D",
"thresholds": [
"259200",
"432000"
],
"type": "number",
"unit": "s"
},
{
"alias": "C:/ usage rate",
"align": "auto",
"colorMode": "cell",
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Value #E",
"thresholds": [
"60",
"80"
],
"type": "number",
"unit": "percentunit"
},
{
"alias": "Most used partition%",
"align": "auto",
"colorMode": "cell",
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Value #F",
"thresholds": [
"60",
"80"
],
"type": "number",
"unit": "percentunit"
},
{
"alias": "processes",
"align": "auto",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": false,
"mappingType": 1,
"pattern": "Value #G",
"thresholds": [],
"type": "string",
"unit": "short"
},
{
"alias": "services",
"align": "auto",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Value #H",
"thresholds": [],
"type": "string",
"unit": "short"
},
{
"alias": "CPU usage",
"align": "auto",
"colorMode": "cell",
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Value #I",
"thresholds": [
"50",
"70"
],
"type": "number",
"unit": "percent"
},
{
"alias": "Memory usage",
"align": "auto",
"colorMode": "cell",
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Value #J",
"thresholds": [
"60",
"80"
],
"type": "number",
"unit": "percent"
},
{
"alias": "frequency",
"align": "auto",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Value #K",
"thresholds": [],
"type": "number",
"unit": "rothz"
},
{
"alias": "",
"align": "right",
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"decimals": 2,
"pattern": "/.*/",
"thresholds": [],
"type": "hidden",
"unit": "short"
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "windows_os_info{instance=~\"$server\"} * on(instance) group_right(product) windows_cs_hostname",
"format": "table",
"hide": true,
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "time() - windows_system_system_up_time{instance=~\"$server\"}",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "D"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "windows_cs_logical_processors{instance=~\"$server\"} - 0",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "avg by (instance) (windows_cpu_core_frequency_mhz{instance=~\"$server\"})",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "K"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "100 - (avg by (instance) (irate(windows_cpu_time_total{instance=~\"$server\",mode=\"idle\"}[1m])) * 100)",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "CPU usage",
"refId": "I"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "windows_cs_physical_memory_bytes{instance=~\"$server\"} - 0",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "C"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "100 - 100 * windows_os_physical_memory_free_bytes{instance=~\"$server\"} / windows_cs_physical_memory_bytes{instance=~\"$server\"}",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "Memory usage",
"refId": "J"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "1 - (windows_logical_disk_free_bytes{instance=~\"$server\",volume=~\"C:\"}/windows_logical_disk_size_bytes{instance=~\"$server\",volume=~\"C:\"})",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "E"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "max by (instance) (1-windows_logical_disk_free_bytes{instance=~\"$server\"}/windows_logical_disk_size_bytes{instance=~\"$server\"})",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "F"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "windows_os_processes{instance=~\"$server\"}",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "G"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": false,
"expr": "sum by (instance) (windows_service_state{instance=~\"$server\",state=~\"running\"})",
"format": "table",
"instant": true,
"interval": "",
"legendFormat": "",
"refId": "H"
}
],
"title": "Server resource overview",
"transform": "table",
"type": "table-old"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 80
},
{
"color": "red",
"value": 90
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 24,
"x": 0,
"y": 13
},
"id": 216,
"options": {
"displayMode": "lcd",
"maxVizHeight": 300,
"minVizHeight": 16,
"minVizWidth": 8,
"namePlacement": "auto",
"orientation": "horizontal",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showUnfilled": true,
"sizing": "auto",
"valueMode": "color"
},
"pluginVersion": "10.4.18",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": true,
"expr": "100 - (windows_logical_disk_free_bytes{instance=~\"$server\",volume=\"C:\"} / windows_logical_disk_size_bytes)*100",
"instant": false,
"interval": "",
"legendFormat": "{{instance}}__{{volume}}",
"refId": "A"
}
],
"title": "Usage rate of each partition",
"type": "bargauge"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 24,
"x": 0,
"y": 20
},
"id": 405,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": true,
"expr": "100 - (windows_logical_disk_free_bytes{instance=~\"$server\",volume=\"C:\"} / windows_logical_disk_size_bytes)*100",
"interval": "",
"legendFormat": "{{instance}}_{{volume}}",
"refId": "A"
}
],
"title": "Volume C:",
"type": "timeseries"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"decimals": 1,
"description": "Утилизация процессора",
"fieldConfig": {
"defaults": {
"links": []
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 8,
"x": 0,
"y": 28
},
"hiddenSeries": false,
"id": 47,
"legend": {
"alignAsTable": true,
"avg": true,
"current": true,
"max": true,
"min": false,
"rightSide": true,
"show": false,
"sort": "current",
"sortDesc": false,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"paceLength": 10,
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "100 - (avg by (instance) (irate(windows_cpu_time_total{instance=~\"$server\",mode=\"idle\"}[1m])) * 100)",
"hide": false,
"instant": false,
"interval": "",
"intervalFactor": 1,
"legendFormat": "",
"refId": "B"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU usage of each host",
"tooltip": {
"shared": true,
"sort": 2,
"value_type": "cumulative"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1676",
"format": "percent",
"logBase": 1,
"min": "0",
"show": true
},
{
"$$hashKey": "object:1677",
"format": "short",
"logBase": 1,
"show": false
}
],
"yaxis": {
"align": false
}
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Утилизация оперативной памяти ",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "opacity",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 2,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": true,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"links": [],
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Free Physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Free physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Free virtual memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "super-light-blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Physical memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "Virtual memory"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "/.*Physical.*/"
},
"properties": [
{
"id": "custom.lineWidth",
"value": 3
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 8,
"x": 8,
"y": 28
},
"hideTimeOverride": false,
"id": 49,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max"
],
"displayMode": "list",
"placement": "right",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "8.3.0",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": true,
"expr": "100.0 - 100 * windows_os_physical_memory_free_bytes{instance=~\"$server\"} / windows_cs_physical_memory_bytes",
"interval": "",
"legendFormat": "{{instance}}",
"refId": "A"
}
],
"title": "Memory usage of each host",
"type": "timeseries"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Утелизация сети ",
"fieldConfig": {
"defaults": {
"links": []
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 8,
"x": 16,
"y": 28
},
"hiddenSeries": false,
"hideTimeOverride": false,
"id": 53,
"legend": {
"alignAsTable": true,
"avg": true,
"current": true,
"max": true,
"min": false,
"rightSide": true,
"show": false,
"sort": "max",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null as zero",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "max by (instance) (irate(windows_net_bytes_sent_total{instance=~\"$server\",nic!~'isatap.*|VPN.*'}[2m]))*8",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Upload",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 10
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "-max by (instance) (irate(windows_net_bytes_received_total{instance=~\"$server\",nic!~'isatap.*|VPN.*'}[2m]))*8",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_download",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 10
}
],
"thresholds": [],
"timeRegions": [],
"title": "Network details of the maximum traffic network card of each host",
"tooltip": {
"shared": true,
"sort": 2,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1838",
"format": "bps",
"label": "Download Upload",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:1839",
"format": "short",
"logBase": 1,
"show": false
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Утелизация диска IOPS",
"fieldConfig": {
"defaults": {
"links": []
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 8,
"x": 0,
"y": 36
},
"hiddenSeries": false,
"hideTimeOverride": false,
"id": 55,
"legend": {
"alignAsTable": true,
"avg": true,
"current": true,
"max": true,
"min": false,
"rightSide": true,
"show": false,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null as zero",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "irate(windows_logical_disk_reads_total{instance=~\"$server\",volume=\"C:\"}[1m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Read",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 20
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "-irate(windows_logical_disk_writes_total{instance=~\"$server\",volume=\"C:\"}[1m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Write",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "C",
"step": 20
}
],
"thresholds": [],
"timeRegions": [],
"title": "Disk IO",
"tooltip": {
"shared": true,
"sort": 2,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:330",
"format": "iops",
"label": "Read write",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:331",
"format": "short",
"logBase": 1,
"show": false
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Утелизация диска",
"fieldConfig": {
"defaults": {
"links": []
},
"overrides": []
},
"fill": 2,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 8,
"x": 8,
"y": 36
},
"hiddenSeries": false,
"hideTimeOverride": false,
"id": 51,
"legend": {
"alignAsTable": true,
"avg": true,
"current": true,
"max": true,
"min": false,
"rightSide": true,
"show": false,
"sort": "max",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "irate(windows_logical_disk_read_bytes_total{instance=~\"$server\",volume=\"C:\"}[1m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Read",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 20
},
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "-irate(windows_logical_disk_write_bytes_total{instance=~\"$server\",volume=\"C:\"}[1m])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "{{instance}}_Write",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "B",
"step": 20
}
],
"thresholds": [],
"timeRegions": [],
"title": "Disk read and write (MB/s)",
"tooltip": {
"shared": true,
"sort": 2,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:5607",
"format": "Bps",
"label": "Read write",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:5608",
"format": "iops",
"label": "",
"logBase": 1,
"show": false
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 8,
"x": 16,
"y": 36
},
"hiddenSeries": false,
"id": 395,
"legend": {
"alignAsTable": true,
"avg": false,
"current": false,
"max": false,
"min": false,
"show": false,
"sort": "current",
"sortDesc": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "rate(windows_logical_disk_read_write_latency_seconds_total{instance=~\"$server\",volume=\"C:\"}[$__interval])",
"interval": "",
"legendFormat": "read@{{instance}}",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "rate(windows_logical_disk_read_write_latency_seconds_total{instance=~\"$server\",volume=\"C:\"}[$__interval])",
"hide": false,
"interval": "",
"legendFormat": "write@{{instance}}",
"refId": "B"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Latency disk",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"format": "short",
"logBase": 1,
"show": true
},
{
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Входящие DNS запросы в секундк",
"fieldConfig": {
"defaults": {
"unit": "none"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 8,
"x": 0,
"y": 43
},
"hiddenSeries": false,
"id": 246,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"maxDataPoints": 100,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "rate(windows_dns_queries_total{protocol=\"udp\",instance=~\"$server\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "DNS Queries/Sec",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:943",
"format": "none",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:944",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Кол-во подключений",
"fieldConfig": {
"defaults": {
"unit": "none"
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 8,
"x": 8,
"y": 43
},
"hiddenSeries": false,
"id": 250,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"maxDataPoints": 100,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": true,
"expr": "rate(windows_ad_ldap_opened_connections_total{type=\"ldap\",instance=~\"$server\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "LDAP Connections/Sec",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1116",
"format": "none",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:1117",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Количество запросов, помещенных в очередь на диск",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 7,
"w": 8,
"x": 16,
"y": 43
},
"id": 399,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": true,
"expr": "windows_logical_disk_requests_queued{instance=~\"$server\",volume=\"C:\"}",
"interval": "",
"legendFormat": "{{instance}}_Disk_{{volume}}",
"refId": "A"
}
],
"title": "CurrentDiskQueueLength",
"type": "timeseries"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Когда происходит аппаратное или программное исключение, процессор останавливает выполнение в точке, в которой возникло исключение, и передает управление системе. Во-первых, система сохраняет как состояние машины текущего потока, так и информацию, описывающую исключение. Затем система пытается найти обработчик исключения для обработки исключения.",
"fieldConfig": {
"defaults": {
"links": []
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 12,
"x": 0,
"y": 50
},
"hiddenSeries": false,
"hideTimeOverride": false,
"id": 13,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "Exception Dispatching",
"url": "https://docs.microsoft.com/en-us/windows/win32/debug/exception-dispatching"
}
],
"nullPointMode": "null as zero",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"application": {
"filter": ""
},
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "rate(windows_system_exception_dispatches_total{instance=~\"$server\"}[$__interval])",
"format": "time_series",
"functions": [],
"group": {
"filter": ""
},
"hide": false,
"host": {
"filter": ""
},
"interval": "",
"intervalFactor": 1,
"item": {
"filter": ""
},
"legendFormat": "exceptions {{instance}}",
"metric": "mysql_global_status_questions",
"mode": 0,
"options": {
"showDisabledItems": false
},
"refId": "A",
"step": 20
}
],
"thresholds": [],
"timeRegions": [],
"title": "System exception dispatches/sec",
"tooltip": {
"shared": false,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2196",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:2197",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "Поток - это единый последовательный поток выполнения задач процесса, поэтому он также известен как поток выполнения или поток управления. Внутри процесса любой операционной системы есть способ выполнения потока. Помимо этого, внутри процесса может быть более одного потока. Каждый поток одного и того же процесса использует отдельный счетчик программ и стек записей активации и блоков управления. Thread часто называют легким процессом.",
"fieldConfig": {
"defaults": {
"links": []
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 5,
"w": 12,
"x": 12,
"y": 50
},
"hiddenSeries": false,
"hideTimeOverride": false,
"id": 12,
"legend": {
"alignAsTable": true,
"avg": false,
"current": false,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null as zero",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "windows_system_threads{instance=~\"$server\"}",
"interval": "",
"legendFormat": "{{instance}}_threads",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "system_threads",
"tooltip": {
"shared": false,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2279",
"format": "none",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:2280",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 55
},
"id": 275,
"panels": [
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Ожидающие синхронизации",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 56
},
"hiddenSeries": false,
"id": 307,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "windows_ad_replication_pending_synchronizations{instance=~\"$server\"}",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Replication Pending Syncronisations",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2650",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:2651",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Межсайтовый трафик репликации",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 56
},
"hiddenSeries": false,
"id": 285,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "irate(windows_ad_replication_data_intersite_bytes_total{direction=\"inbound\",instance=~\"$server\"}[1m])",
"interval": "",
"legendFormat": "inbound ({{instance}})",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "-irate(windows_ad_replication_data_intersite_bytes_total{direction=\"outbound \",instance=~\"$server\"}[1m])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "outbound ({{instance}})",
"refId": "B"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Intersite Replication Traffic",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1299",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:1300",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Трафик внутрисайтовой репликации",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 0,
"y": 64
},
"hiddenSeries": false,
"id": 283,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_replication_data_intrasite_bytes_total{direction=\"inbound\",instance=~\"$server\"}[$__interval])",
"interval": "",
"legendFormat": "inbound ({{instance}})",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "-rate(windows_ad_replication_data_intrasite_bytes_total{direction=\"outbound\",instance=~\"$server\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "outbound ({{instance}})",
"refId": "B"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Intrasite Replication Traffic",
"tooltip": {
"shared": true,
"sort": 1,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1238",
"format": "decbytes",
"label": "inbound outbound",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:1239",
"format": "short",
"label": "",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 12,
"y": 64
},
"hiddenSeries": false,
"id": 354,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_replication_sync_requests_total{instance=~\"$server\"}[$__interval])",
"interval": "",
"legendFormat": "{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Replication sync requests ",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2995",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:2996",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "AD Replication",
"type": "row"
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 56
},
"id": 273,
"panels": [
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 0,
"y": 57
},
"hiddenSeries": false,
"id": 306,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_database_operations_total{instance=~\"$server\",operation=\"add\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{operation}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Directory Operations (Add)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7425",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7426",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 12,
"y": 57
},
"hiddenSeries": false,
"id": 360,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_database_operations_total{instance=~\"$server\",operation=\"delete\"}[1m])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{operation}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Directory Operations (Delete)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7425",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7426",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 0,
"y": 64
},
"hiddenSeries": false,
"id": 364,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_database_operations_total{instance=~\"$server\",operation=\"recycle\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{operation}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Directory Operations (recycle)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7425",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7426",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 12,
"y": 64
},
"hiddenSeries": false,
"id": 363,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_database_operations_total{instance=~\"$server\",operation=\"modify\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{operation}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Directory Operations (modify)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7425",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7426",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "SAM выполняет следующие задачи:\nИдентификация субъектов (трансляции имен в идентификаторы (SID'ы) и обратно);\nПроверка пароля, авторизация (участвует в процессе входа пользователей в систему);\nХранит статистику (время последнего входа, количества входов, количества некорректных вводов пароля);\nХранит настройки политики учетных записей и приводит их в действие (политика паролей и политика блокировки учетной записи);\nХранит логическую структуру группировки учетных записей (по группам, доменам, алиасам);\nКонтролирует доступ к базе учетных записей;\nПредоставляет программный интерфейс для управления базой учетных записей.",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 71
},
"hiddenSeries": false,
"id": 305,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"hideZero": false,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_directory_operations_total{instance=~\"$server\",origin=~\"security.*\"}[1m])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "({{instance}})__{{operation}}__{{origin}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Operations (read|write|search Security Account Manager)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:6042",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:6043",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "[MS-NSPI]: Name Service Provider Interface (NSPI) Protocol",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 12,
"y": 71
},
"hiddenSeries": false,
"id": 365,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"hideZero": false,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "NSPI",
"url": "https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-nspi/6dd0a3ea-b4d4-4a73-a857-add03a89a543"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "irate(windows_ad_directory_operations_total{instance=~\"$server\",origin=~\"name_service_provider_interface\"}[1m])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "({{instance}})__{{operation}}__{{origin}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Operations (read|write|search Name Service Provider Interface)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:6042",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:6043",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "API",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 77
},
"hiddenSeries": false,
"id": 367,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"hideZero": false,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_directory_operations_total{instance=~\"$server\",origin=~\"directory_service_api\"}[1m])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "({{instance}})__{{operation}}__{{origin}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Operations (read|write|search API)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:6042",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:6043",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Active Directory является частью распределенной системы, выполняющей репликацию . Средство проверки согласованности (KCC)",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 12,
"y": 77
},
"hiddenSeries": false,
"id": 366,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"hideZero": false,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "Knowledge Consistency Checker",
"url": "https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-adts/f2e2f6c7-b232-406d-b48a-fc6ccf231202"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_directory_operations_total{instance=~\"$server\",origin=~\"knowledge_consistency_checker\"}[1m])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "({{instance}})__{{operation}}__{{origin}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Operations (read|write|search Knowledge Consistency Checker)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:6042",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:6043",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 83
},
"hiddenSeries": false,
"id": 312,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_sam_password_changes_total{instance=~\"$server\"})",
"interval": "",
"intervalFactor": 2,
"legendFormat": "changes_password_{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "count changes password",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2099",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:2100",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "AD Operations",
"type": "row"
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 57
},
"id": 271,
"panels": [
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Операции привязки используются для аутентификации клиентов (и пользователей или приложений, стоящих за ними) на сервере каталогов, для установления удостоверения авторизации, которое будет использоваться для последующих операций, обрабатываемых в этом соединении, и для указания версии протокола LDAP, которую будет использовать клиент",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 58
},
"hiddenSeries": false,
"id": 303,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "BIND LDAP",
"url": "https://docs.microsoft.com/ru-ru/dotnet/api/system.directoryservices.protocols.ldapconnection.bind?view=dotnet-plat-ext-5.0"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_binds_total{instance=~\"$server\",bind_method=\"ldap\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{bind_method}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Bind method LDAP",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4459",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:4460",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 12,
"y": 58
},
"hiddenSeries": false,
"id": 369,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "NTLM",
"url": "https://docs.microsoft.com/ru-ru/windows-server/security/kerberos/ntlm-overview"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_binds_total{instance=~\"$server\",bind_method=\"ntlm\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{bind_method}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Bind method NTLM",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4459",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:4460",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Active Directory поддерживает режим работы, известный как «быстрое связывание», который можно включить для каждого соединения LDAP . Режим быстрого связывания позволяет клиенту использоватьзапрос связывания LDAP для простой проверки учетных данных и аутентификации клиента без дополнительных затрат на установление информации авторизации",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 64
},
"hiddenSeries": false,
"id": 372,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "Using Fast Bind",
"url": "https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-adts/dc4eb502-fb94-470c-9ab8-ad09fa720ea6"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_binds_total{instance=~\"$server\",bind_method=\"fast\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{bind_method}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Bind method fast",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4459",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:4460",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Клиент LDAP, реализующий пакет расширений B, C или D, будет либо использовать простую аутентификацию в запросе привязки LDAP, либо запросить механизм безопасности DIGEST-MD5 SASL в запросе привязки LDAP, в зависимости от конфигурации клиента LDAP.",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 12,
"y": 64
},
"hiddenSeries": false,
"id": 370,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "LDAP Digest Authentication",
"url": "https://docs.microsoft.com/en-us/openspecs/sharepoint_protocols/ms-upsldap/a549de98-d428-49e8-9fe7-f6b7cdde2f81"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_binds_total{instance=~\"$server\",bind_method=\"digest\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{bind_method}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Bind method digest",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4459",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:4460",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 70
},
"hiddenSeries": false,
"id": 371,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_binds_total{instance=~\"$server\",bind_method=\"ds_client\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{bind_method}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Bind method client",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4459",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:4460",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Простая привязка аутентификации - наиболее распространенный способ аутентификации клиентов LDAP. При простой привязке клиент выполняет привязку анонимно, то есть с пустым DN привязки, или путем предоставления DN и пароля",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 12,
"y": 70
},
"hiddenSeries": false,
"id": 368,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_binds_total{instance=~\"$server\",bind_method=\"simple\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{bind_method}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Bind simple",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4459",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:4460",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 76
},
"hiddenSeries": false,
"id": 373,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "NTLM",
"url": "https://docs.microsoft.com/ru-ru/windows-server/security/kerberos/ntlm-overview"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_binds_total{instance=~\"$server\",bind_method=\"ds_server\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{bind_method}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Bind method server",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:4459",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:4460",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 24,
"x": 0,
"y": 82
},
"hiddenSeries": false,
"id": 356,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_binds_total{instance=~\"$server\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{bind_method}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "AD Bind",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:5967",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:5968",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "AD Binds",
"type": "row"
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 58
},
"id": 314,
"panels": [
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Asynchronous Thread Queue\nМониторинг среднего числа потоков для очереди асинхронных потоков (ATQ). Больше 4 используемых потоков ATQ может отрицательно повлиять на обработку клиентских запросов. ",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 93
},
"hiddenSeries": false,
"id": 316,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "ATQ",
"url": "https://techcommunity.microsoft.com/t5/ask-the-directory-services-team/understanding-atq-performance-counters-yet-another-twist-in-the/ba-p/400293"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "windows_ad_atq_average_request_latency{instance=~\"$server\"}",
"interval": "",
"intervalFactor": 2,
"legendFormat": "Latency ATQ_{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "average latency request ATQ",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:6197",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:6198",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Текущее количество запросов в очереди ATQ",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 93
},
"hiddenSeries": false,
"id": 397,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "windows_ad_atq_outstanding_requests {instance=~\"$server\"}",
"interval": "",
"legendFormat": "{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "ATQ Queue latency",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"format": "short",
"logBase": 1,
"show": true
},
{
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Количество потоков, используемых сервером LDAP, как определено политикой LDAP.",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 101
},
"hiddenSeries": false,
"id": 318,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "ATQ",
"url": "https://techcommunity.microsoft.com/t5/ask-the-directory-services-team/understanding-atq-performance-counters-yet-another-twist-in-the/ba-p/400293"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "windows_ad_atq_current_threads{exported_service=\"ldap\"}",
"instant": false,
"interval": "",
"intervalFactor": 2,
"legendFormat": "LDAP_{{__name__}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "atq current threads LDAP",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:6278",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:6279",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Asynchronous Thread Queue Мониторинг среднего числа потоков для очереди асинхронных потоков (ATQ). Больше 4 используемых потоков ATQ может отрицательно повлиять на обработку клиентских запросов",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 101
},
"hiddenSeries": false,
"id": 375,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "ATQ",
"url": "https://techcommunity.microsoft.com/t5/ask-the-directory-services-team/understanding-atq-performance-counters-yet-another-twist-in-the/ba-p/400293"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_atq_current_threads{exported_service=\"other\"}[$__interval])",
"instant": false,
"interval": "",
"intervalFactor": 2,
"legendFormat": "{{instance}}__other",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "atq current threads other",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:6278",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:6279",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "AD ATQ",
"type": "row"
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 59
},
"id": 332,
"panels": [
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Кол-во подключений ",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 0,
"y": 6
},
"hiddenSeries": false,
"id": 302,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_ldap_opened_connections_total{type=\"ldap\",instance=~\"$server\"}[1m])",
"format": "time_series",
"hide": false,
"instant": false,
"interval": "",
"intervalFactor": 2,
"legendFormat": "Opened ({{instance}})",
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "-(rate(windows_ad_ldap_closed_connections_total{instance=~\"$server\"}[1m]))",
"format": "time_series",
"hide": false,
"interval": "",
"intervalFactor": 2,
"legendFormat": "Closed ({{instance}})",
"refId": "C"
}
],
"thresholds": [],
"timeRegions": [],
"title": "LDAP Connections",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:1102",
"format": "locale",
"label": "",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:1103",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Показывает количество подопераций поиска в секунду. Одна операция поиска состоит из множества подопераций. Каждая подоперация примерно соответствует объекту, который при поиске учитывается служба каталогов.\nЭтот сбор данных о производительности может помочь определить, есть ли проблема с нагрузкой на контроллер домена.",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 12,
"y": 6
},
"hiddenSeries": false,
"id": 322,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_directory_search_suboperations_total{instance=~\"$server\"}[$__interval])",
"interval": "",
"intervalFactor": 2,
"legendFormat": "sub-operations_{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Search sub-operations",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7461",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7462",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Показывает процент операций записи в каталог из LDAP.",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 13
},
"hiddenSeries": false,
"id": 304,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_ldap_writes_total{instance=~\"$server\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "Writes ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "LDAP writers",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:5893",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:5894",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
"y": 13
},
"hiddenSeries": false,
"id": 374,
"legend": {
"alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_ldap_searches_total{instance=~\"$server\"}[$__interval])",
"format": "time_series",
"hide": false,
"interval": "",
"intervalFactor": 2,
"legendFormat": "Searches ({{instance}}",
"refId": "B"
}
],
"thresholds": [],
"timeRegions": [],
"title": "LDAP search",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:5893",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:5894",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Одна из причин этой рекомендации - наличие фантомных объектов в Active Directory. Фантомные объекты - это объекты базы данных, используемые для «внутренних административных операций» в Active Directory. Эти фантомные объекты не могут отображаться с помощью LDAP или ADSI .\n\nФантомные объекты могут быть созданы, если, например, объект удален в Active Directory, но все еще есть ссылки или ссылки на объект. Фантомные объекты также могут быть созданы, если в группе локального домена есть пользователь из другого домена в качестве члена.",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 22
},
"hiddenSeries": false,
"id": 330,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_phantom_objects_cleaned_total{instance=~\"$server\"}[5m])",
"interval": "",
"legendFormat": "phantom objects cleaned@{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "ad phantom objects cleaned",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7623",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7624",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Active Directory поддерживает поиск по UDP только для поиска по rootDSE . Он кодирует результаты поиска LDAP, выполняемого через UDP, таким же образом, как и поиск, выполняемый через TCP",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 22
},
"hiddenSeries": false,
"id": 326,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_ldap_udp_operations_total{instance=~\"$server\"}[$__interval])",
"interval": "",
"legendFormat": "udp_operations_{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "LDAP udp operations",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7542",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7543",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "NameTranslate относится к интерфейсу IADsNameTranslate, который можно использовать для преобразования имен объектов Active Directory из одного формата в другой. IADsNameTranslate - это реализация API DsCrackNames на ADSI. DsCrackNames использует вызовы RPC к Active Directory вместо запросов LDAP. ",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 30
},
"hiddenSeries": false,
"id": 328,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_name_translations_total{target_name=\"server\"}[$__interval])",
"hide": false,
"interval": "",
"legendFormat": "server@{{instance}}",
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "-rate(windows_ad_name_translations_total{target_name=\"client\"}[$__interval])",
"hide": true,
"interval": "",
"legendFormat": "client@{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "ad name translations",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7783",
"format": "string",
"label": "",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7784",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "NameTranslate относится к интерфейсу IADsNameTranslate, который можно использовать для преобразования имен объектов Active Directory из одного формата в другой. IADsNameTranslate - это реализация API DsCrackNames на ADSI. DsCrackNames использует вызовы RPC к Active Directory вместо запросов LDAP. ",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 30
},
"hiddenSeries": false,
"id": 376,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_name_translations_total{target_name=\"server\"}[$__interval])",
"hide": true,
"interval": "",
"legendFormat": "server@{{instance}}",
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_ad_name_translations_total{target_name=\"client\"}[$__interval])",
"hide": false,
"interval": "",
"legendFormat": "client@{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "ad name translations",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:7783",
"format": "string",
"label": "",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:7784",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "AD perfomance",
"type": "row"
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 60
},
"id": 257,
"panels": [
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Входящие DNS запросы в секундк ",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 0,
"y": 7
},
"hiddenSeries": false,
"id": 259,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "irate(windows_dns_queries_total{instance=~\"$server\",protocol=\"tcp\"}[1m])",
"hide": false,
"interval": "",
"legendFormat": "in-{{protocol}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "TCP-DNS Queries/sec",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:11622",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:11623",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Входящие DNS запросы в секундк ",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 12,
"y": 7
},
"hiddenSeries": false,
"id": 406,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "irate(windows_dns_queries_total{instance=~\"$server\",protocol=\"udp\"}[1m])",
"hide": false,
"interval": "",
"legendFormat": "in-{{protocol}} ({{instance}})",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "-irate(windows_dns_responses_total{instance=~\"$server\"}[1m])",
"format": "time_series",
"hide": true,
"interval": "",
"intervalFactor": 2,
"legendFormat": "out-{{protocol}} ({{instance}})",
"refId": "B"
}
],
"thresholds": [],
"timeRegions": [],
"title": "UDP-DNS Queries/sec",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:11622",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:11623",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Этот монитор вычисляет значение счетчика производительности \"DNS()\\ошибок рекурсивных запросов в секунду\". Если среднее значение счетчика выше настроенного порогового значения на число образцов настроенного номера, измените состояние.\nПричины:\nDNS-сервер неправильно настроен, или на него подается много запросов, которые он не может удовлетворить.",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 0,
"y": 14
},
"hiddenSeries": false,
"id": 261,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dns_recursive_query_failures_total{instance=~\"$server\"}[$__interval])",
"interval": "",
"intervalFactor": 1,
"legendFormat": "failures ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "DNS Recursive Queries Failures",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2184",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:2185",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Исходящие ответы от DNS в секунду",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 12,
"y": 14
},
"hiddenSeries": false,
"id": 377,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "irate(windows_dns_queries_total{instance=~\"$server\"}[$__interval])",
"hide": true,
"interval": "",
"legendFormat": "in-{{protocol}} ({{instance}})",
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "irate(windows_dns_responses_total{instance=~\"$server\"}[$__interval])",
"format": "time_series",
"hide": false,
"interval": "",
"intervalFactor": 1,
"legendFormat": "out-{{protocol}} ({{instance}})",
"refId": "B"
}
],
"thresholds": [],
"timeRegions": [],
"title": "DNS out Responses/sec",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:11622",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:11623",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Таймауты отправки рекурсивных запросов DNS",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 0,
"y": 21
},
"hiddenSeries": false,
"id": 378,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dns_recursive_query_send_timeouts_total{instance=~\"$server\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "sent timeouts ({{instance}})",
"refId": "C"
}
],
"thresholds": [],
"timeRegions": [],
"title": "DNS Recursive Queries send timeouts",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2184",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:2185",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Рекурсивный запрос DNS",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 7,
"w": 12,
"x": 12,
"y": 21
},
"hiddenSeries": false,
"id": 379,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": true,
"min": true,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dns_recursive_queries_total{instance=~\"$server\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "queries ({{instance}})",
"refId": "B"
}
],
"thresholds": [],
"timeRegions": [],
"title": "DNS Recursive Queries",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:2184",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:2185",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Показывает общий объем кэширующей памяти, используемой DNS-сервером.",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 27
},
"hiddenSeries": false,
"id": 297,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "DNS Object",
"url": "https://docs.microsoft.com/en-us/previous-versions/ms803992(v=msdn.10)?redirectedfrom=MSDN"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "windows_dns_memory_used_bytes{instance=~\"$server\",area=\"caching\"}",
"interval": "",
"legendFormat": "{{area}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "DNS Memory Usage caching",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:9292",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:9293",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Функция обновления DNS позволяет клиентские компьютеры DNS регистрироваться и динамически обновлять свои записи ресурсов на DNS-сервере при всех изменениях. ",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 6,
"w": 12,
"x": 12,
"y": 28
},
"hiddenSeries": false,
"id": 301,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "DNS",
"url": "https://docs.microsoft.com/ru-ru/troubleshoot/windows-server/networking/configure-dns-dynamic-updates-windows-server-2003"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dns_dynamic_updates_failures_total{instance=~\"$server\",reason=\"rejected\"}[$__interval])",
"format": "time_series",
"interval": "",
"intervalFactor": 2,
"legendFormat": "rejected@{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Dynamic Updates DNS failures",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:9715",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:9716",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Показывает общую память узла базы данных, используемую DNS-сервером.",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 34
},
"hiddenSeries": false,
"id": 380,
"legend": {
"alignAsTable": true,
"avg": false,
"current": true,
"max": false,
"min": false,
"rightSide": true,
"show": true,
"sort": "current",
"sortDesc": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "DNS Object",
"url": "https://docs.microsoft.com/en-us/previous-versions/ms803992(v=msdn.10)?redirectedfrom=MSDN"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "windows_dns_memory_used_bytes{instance=~\"$server\",area=\"database_node\"}",
"interval": "",
"legendFormat": "{{area}} ({{instance}})",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory Usage DNS node",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:9292",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:9293",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 35
},
"hiddenSeries": false,
"id": 383,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"dns\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process dns",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 42
},
"hiddenSeries": false,
"id": 385,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "8.3.0",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "windows_process_working_set{process=\"dns\", instance=~\"$server\"}",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process dns",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "DNS",
"type": "row"
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 61
},
"id": 344,
"panels": [
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Количество запросов на передачу зоны (AXFR ), отправленных вторичным DNS-сервером",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 56
},
"hiddenSeries": false,
"id": 336,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [
{
"targetBlank": true,
"title": "Transfer DNS zone",
"url": "https://docs.microsoft.com/en-us/services-hub/health/remediation-steps-ad/configure-all-dns-zones-only-to-allow-zone-transfers-to-specified-ip-addresses"
}
],
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dns_zone_transfer_requests_sent_total{instance=~\"$server\",qtype=\"full\"}[$__interval])",
"interval": "",
"legendFormat": "{{qtype}}@{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "DNS zone transfer requests sent",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:11541",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:11542",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Количество ответов о переносе зоны (AXFR / IXFR), полученных вторичным DNS-сервером",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 56
},
"hiddenSeries": false,
"id": 338,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dns_zone_transfer_response_received_total{instance=~\"$server\",qtype=\"full\"}[$__interval])",
"interval": "",
"legendFormat": "{{instance}}@{{qtype}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "DNS zone transfer response received",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:11767",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:11768",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "dns zone transfer",
"type": "row"
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 62
},
"id": 352,
"panels": [
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Количество файлов и папок, перемещенных в папку «Конфликт и удаленные».",
"fieldConfig": {
"defaults": {
"custom": {},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 57
},
"hiddenSeries": false,
"id": 350,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dfsr_folder_conflict_generated_files_total{instance=~\"$server\"}[$__interval])",
"interval": "",
"legendFormat": "{{instance}}@{{name}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "dfsr move file folder (SYSVOL) conflict",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:558",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:559",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Общий размер файлов и папок удаленных из папки «Конфликт и удалено», в байтах",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 57
},
"hiddenSeries": false,
"id": 348,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dfsr_folder_conflict_cleaned_up_bytes_total{instance=~\"$server\"}[$__interval])",
"interval": "",
"legendFormat": "{{instance}}@{{name}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "folder (SYSVOL) conflict cleaned (DFSR)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:415",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:416",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "Общее количество полученных файлов",
"fieldConfig": {
"defaults": {
"custom": {}
},
"overrides": []
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 65
},
"hiddenSeries": false,
"id": 346,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "7.3.7",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "rate(windows_dfsr_folder_received_files_total{instance=~\"$server\"}[$__interval])",
"interval": "",
"legendFormat": "{{instance}}@{{name}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Total number of files received (DFSR)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:306",
"format": "short",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:307",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "AD-DFSR",
"type": "row"
},
{
"collapsed": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 63
},
"id": 232,
"panels": [],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "Process load (CPU, Memory)",
"type": "row"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 64
},
"hiddenSeries": false,
"id": 234,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"MsMpEng\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process MsMpEng",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"format": "percent",
"logBase": 1,
"show": true
},
{
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 64
},
"hiddenSeries": false,
"id": 236,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": true,
"expr": "windows_process_working_set{process=\"MsMpEng\", instance=~\"$server\"}",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process MsMpEng",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:218",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:219",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 72
},
"hiddenSeries": false,
"id": 237,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"MsSense\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process MsSense",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"format": "percent",
"logBase": 1,
"show": true
},
{
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisBorderShow": false,
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"insertNulls": false,
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "never",
"spanNulls": true,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "decbytes"
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 72
},
"id": 238,
"options": {
"legend": {
"calcs": [
"mean",
"lastNotNull",
"max"
],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "8.3.1",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "windows_process_working_set{process=\"MsSense\", instance=~\"$server\"}",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"title": "Memory process MsSense",
"type": "timeseries"
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 80
},
"hiddenSeries": false,
"id": 241,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"powershell\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process powershell",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"format": "percent",
"logBase": 1,
"show": true
},
{
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 80
},
"hiddenSeries": false,
"id": 242,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "sum by (instance) (windows_process_working_set{process=\"powershell\", instance=~\"$server\"})",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process powershell",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 88
},
"hiddenSeries": false,
"id": 381,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"GXHSMService\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process GXHSMService (Simpana)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 88
},
"hiddenSeries": false,
"id": 384,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "sum by (instance) (windows_process_working_set{process=\"GXHSMService\", instance=~\"$server\"})",
"interval": "",
"legendFormat": "{{instance}}@{{process}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process GXHSMService (simpana)",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 96
},
"hiddenSeries": false,
"id": 386,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"Microsoft.ActiveDirectory.WebServices\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process Microsoft.ActiveDirectory.WebServices",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 96
},
"hiddenSeries": false,
"id": 387,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "windows_process_working_set{process=\"Microsoft.ActiveDirectory.WebServices\", instance=~\"$server\"}",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process Microsoft.ActiveDirectory.WebServices",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 104
},
"hiddenSeries": false,
"id": 388,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"Microsoft.Tri.Sensor\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process Microsoft.Tri.Sensor",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 104
},
"hiddenSeries": false,
"id": 389,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "windows_process_working_set{process=\"Microsoft.Tri.Sensor\", instance=~\"$server\"}",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process Microsoft.Tri.Sensor",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 112
},
"hiddenSeries": false,
"id": 390,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"svchost\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process svchost",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 112
},
"hiddenSeries": false,
"id": 391,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"expr": "sum by (instance) (windows_process_working_set{process=\"svchost\", instance=~\"$server\"})",
"interval": "",
"legendFormat": "{{instance}}@svchost",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process svchost",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 120
},
"hiddenSeries": false,
"id": 392,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=\"windows_exporter\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process windows_exporter",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 120
},
"hiddenSeries": false,
"id": 393,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"expr": "sum by (instance) (windows_process_working_set{process=\"windows_exporter\", instance=~\"$server\"})",
"interval": "",
"legendFormat": "{{instance}}@windows_exporter",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process windows_exporter",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 128
},
"hiddenSeries": false,
"id": 407,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=~\"Silverfort.*\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process silverfort",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 128
},
"hiddenSeries": false,
"id": 408,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "sum by (instance) (windows_process_working_set{process=~\"Silverfort.*\", instance=~\"$server\"})",
"interval": "",
"legendFormat": "{{instance}}@windows_exporter",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process Silverfort",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 136
},
"hiddenSeries": false,
"id": 409,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=~\"lsass\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process lsass",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 136
},
"hiddenSeries": false,
"id": 410,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "sum by (instance) (windows_process_working_set{process=~\"lsass\", instance=~\"$server\"})",
"interval": "",
"legendFormat": "{{instance}}@windows_exporter",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process lsass",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 144
},
"hiddenSeries": false,
"id": 411,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=~\"svchost\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process svchost",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 144
},
"hiddenSeries": false,
"id": 412,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "sum by (instance) (windows_process_working_set{process=~\"svchost\", instance=~\"$server\"})",
"interval": "",
"legendFormat": "{{instance}}@windows_exporter",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process svchost",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 152
},
"hiddenSeries": false,
"id": 413,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "100 * sum by(instance, process, process_id) (rate(windows_process_cpu_time_total{instance=~\"$server\", process=~\"ADInsight\"}[1m]))\n / on(instance) group_left sum by(instance) (rate(windows_cpu_time_total{instance=~\"$server\"}[1m]))",
"interval": "",
"legendFormat": "{{process}}__{{instance}}",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "CPU load process ADInsight",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12579",
"format": "percent",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12580",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"aliasColors": {},
"bars": false,
"dashLength": 10,
"dashes": false,
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"description": "",
"fill": 1,
"fillGradient": 0,
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 152
},
"hiddenSeries": false,
"id": 414,
"legend": {
"avg": true,
"current": true,
"max": true,
"min": false,
"show": true,
"total": false,
"values": true
},
"lines": true,
"linewidth": 1,
"nullPointMode": "null",
"options": {
"alertThreshold": true
},
"percentage": false,
"pluginVersion": "10.4.18",
"pointradius": 2,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "1TTSbTm7z"
},
"exemplar": true,
"expr": "sum by (instance) (windows_process_working_set{process=~\"ADInsight\", instance=~\"$server\"})",
"interval": "",
"legendFormat": "{{instance}}@windows_exporter",
"refId": "A"
}
],
"thresholds": [],
"timeRegions": [],
"title": "Memory process ADInsight",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
"type": "graph",
"xaxis": {
"mode": "time",
"show": true,
"values": []
},
"yaxes": [
{
"$$hashKey": "object:12749",
"format": "decbytes",
"logBase": 1,
"show": true
},
{
"$$hashKey": "object:12750",
"format": "short",
"logBase": 1,
"show": true
}
],
"yaxis": {
"align": false
}
},
{
"collapsed": true,
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 160
},
"id": 401,
"panels": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"description": "1 - running\n0 - stop",
"fieldConfig": {
"defaults": {
"color": {
"mode": "continuous-GrYlRd"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "yellow",
"value": null
},
{
"color": "red",
"value": 0
},
{
"color": "green",
"value": 1
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 9,
"w": 24,
"x": 0,
"y": 65
},
"id": 403,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showPercentChange": false,
"textMode": "auto",
"wideLayout": true
},
"pluginVersion": "10.4.18",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"exemplar": true,
"expr": "windows_service_state{name=\"silverfortadadapter\",state=\"running\"}",
"interval": "",
"legendFormat": "{{instance}}",
"refId": "A"
}
],
"title": "Состояние службы silverfortadadapter",
"transparent": true,
"type": "stat"
}
],
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"refId": "A"
}
],
"title": "Service silver fort",
"type": "row"
}
],
"refresh": false,
"schemaVersion": 39,
"tags": [
"Prometheus",
"tcsbank.ru",
"DNS",
"AD",
"active directory"
],
"templating": {
"list": [
{
"current": {
"selected": true,
"text": [
"ds-msk-dc02.tcsbank.ru",
"ds-msk-dc03.tcsbank.ru",
"ds-msk-dc04.tcsbank.ru",
"ds-msk-dc05.tcsbank.ru",
"ds-msk-dc06.tcsbank.ru",
"ds-msk-dc07.tcsbank.ru",
"ds-msk-dc08.tcsbank.ru",
"ds-msk-dc09.tcsbank.ru",
"ds-msk-dc10.tcsbank.ru",
"ds-msk-rodc01.tcsbank.ru",
"ix-msk-dc01.tcsbank.ru",
"ix-msk-dc02.tcsbank.ru",
"ix-msk-dc03.tcsbank.ru",
"ix-msk-dc04.tcsbank.ru",
"m1-msk-dc02.tcsbank.ru",
"m1-msk-dc03.tcsbank.ru",
"m1-msk-dc04.tcsbank.ru",
"m1-msk-dc05.tcsbank.ru",
"m1-msk-rodc01.tcsbank.ru",
"vd-msk-dc02.tcsbank.ru"
],
"value": [
"ds-msk-dc02.tcsbank.ru",
"ds-msk-dc03.tcsbank.ru",
"ds-msk-dc04.tcsbank.ru",
"ds-msk-dc05.tcsbank.ru",
"ds-msk-dc06.tcsbank.ru",
"ds-msk-dc07.tcsbank.ru",
"ds-msk-dc08.tcsbank.ru",
"ds-msk-dc09.tcsbank.ru",
"ds-msk-dc10.tcsbank.ru",
"ds-msk-rodc01.tcsbank.ru",
"ix-msk-dc01.tcsbank.ru",
"ix-msk-dc02.tcsbank.ru",
"ix-msk-dc03.tcsbank.ru",
"ix-msk-dc04.tcsbank.ru",
"m1-msk-dc02.tcsbank.ru",
"m1-msk-dc03.tcsbank.ru",
"m1-msk-dc04.tcsbank.ru",
"m1-msk-dc05.tcsbank.ru",
"m1-msk-rodc01.tcsbank.ru",
"vd-msk-dc02.tcsbank.ru"
]
},
"datasource": {
"type": "prometheus",
"uid": "QTwcPbR7k"
},
"definition": "windows_cs_hostname{domain=\"tcsbank.ru\",hostname=~\"(m1|ds|vd|ix)-msk-.*dc.*\"} ",
"hide": 0,
"includeAll": true,
"label": "server",
"multi": true,
"name": "server",
"options": [],
"query": {
"qryType": 4,
"query": "windows_cs_hostname{domain=\"tcsbank.ru\",hostname=~\"(m1|ds|vd|ix)-msk-.*dc.*\"} ",
"refId": "PrometheusVariableQueryEditor-VariableQuery"
},
"refresh": 1,
"regex": ".*instance=\"(.*?)\".*",
"skipUrlSync": false,
"sort": 5,
"tagValuesQuery": "",
"tagsQuery": "",
"type": "query",
"useTags": false
}
]
},
"time": {
"from": "now-1h",
"to": "now"
},
"timepicker": {
"refresh_intervals": [
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
],
"time_options": [
"5m",
"15m",
"1h",
"6h",
"12h",
"24h",
"2d",
"7d",
"30d"
]
},
"timezone": "",
"title": "MS Active Directory/DNS Prometheus",
"uid": "CaVPQGcnz",
"version": 4,
"weekStart": ""
}
- Details
- Written by: po3dno
- Category: Docker
- Hits: 85
I was looking at my logs and analytics, and I saw something interesting. I had a few requests to these endpoints which they do not exist on my blog!
.git/config
.aws/credentials
.aws/config
config.phpSo I started looking into this …
On my old web server, I had an extensive defensing mechanism with mod security, fail2ban and many more. At some point I had some OWASP prevention mechanism, so I had them connected to fail2ban and fail2ban blocked IPs via iptables.
On my new setup, I use traefik reverse proxy and I was thinking that for sure, there is a way to connect traefik with fail2ban. So after a quick research, I ended to fail2ban traefik plugin. Which does something similar to fail2ban, but it does not need fail2ban, iptables or nftables to block incoming traffic.
So, if you’re running services behind Traefik, you’ve got a powerful tool right at your fingertips: the fail2ban plugin. Unlike the traditional Linux fail2ban package that operates at the kernel level with iptables, Traefik’s fail2ban plugin works at the middleware level—meaning it can protect specific routes, integrate seamlessly with your containerized stack, and start banning malicious IPs within seconds.
Prerequisites & How the Plugin Works
What You Need
- Traefik 3.0 or later (the plugin requires traefik experimental plugin system)
- Basic familiarity with Traefik (routers, services, middleware concepts)
- Docker Compose or Kubernetes (we’ll focus on Docker in this guide)
- Administrative access to your Traefik configuration files
The Traefik Fail2ban Plugin
If you’re familiar with traditional fail2ban on Linux, Traefik’s version works differently—and that’s actually good news. Instead of relying on log file parsing and kernel-level packet filtering, the Traefik plugin watches HTTP responses in real-time at the middleware level. When it detects a pattern of failures (e.g., four 401 “Unauthorized” responses from the same IP within eg. 10 minutes), it blocks that IP for a configurable duration for x hours.
Here’s the flow:
Incoming Request
↓
Traefik Router (matches domain/path)
↓
Middleware Chain (security headers → rate-limit → fail2ban)
↓
Fail2ban Plugin checks: Is this IP banned?
├─→ YES: Return 403 Forbidden, block request
└─→ NO: Continue to backend service
↓
Backend responds (200, 401, 403, etc.)
↓
Fail2ban updates counters: Track failures by IP
↓
Threshold exceeded? Ban this IP for 3 hoursKey Advantages
- Application-aware: Works at the HTTP level, not raw packets
- URL-specific: Protect only sensitive routes; allow legitimate traffic to other endpoints
- Dynamic: No service restarts needed; configuration reloads on-the-fly
- Container-friendly: Zero external dependencies; runs inside your Traefik container
- Flexible: Whitelist trusted IPs, customize ban duration, define custom rules per endpoint
Installation & Plugin Setup
Add the Plugin to Your Traefik Configuration
First, declare the fail2ban plugin in your traefik.yml. This tells Traefik where to find and how to load the plugin.
# traefik.yml
experimental:
plugins:
fail2ban:
moduleName: github.com/tomMoulard/fail2ban
version: v0.9.0 # or use the latest stable versionRestart Traefik
After updating traefik.yml, restart the Traefik container:
docker-compose down traefik && docker-compose up -d traefikVerify Plugin Initialization
Check the container logs for successful plugin loading:
docker-compose logs traefik | grep -i fail2banYou should see output something like:
traefik | 2024-04-05 14:32:15 INF Loaded plugin fail2ban from github.com/tomMoulard/fail2ban@v0.9.0If you see an error instead, verify:
- Traefik version is 3.0+
- Plugin module name is spelled correctly
- The version tag exists in the GitHub repository
Configuration: Building Your Protection Rules
Now comes the interesting part. Configuring what and how fail2ban protects your services. All middleware definitions live in dynamic/ directory and usually in middlewares.yml or a similar file that Traefik loads from the dynamic/ directory. For this blog post, we will use this file.
Understanding Each Configuration Parameter
Here’s a complete fail2ban middleware definition with detailed explanations:
# etc_traefik/dynamic/middlewares.yml
http:
middlewares:
my-fail2ban:
plugin:
fail2ban:
# ============================================
# ALLOWLIST: IPs that bypass the plugin
# ============================================
allowlist:
ip:
- "::1" # IPv6 localhost
- "127.0.0.1" # IPv4 localhost
- "10.0.0.5" # Your monitoring system
- "203.0.113.0/24" # Your corporate network
# ============================================
# DENYLIST: IPs to proactively ban (optional)
# ============================================
denylist:
ip:
- "192.0.2.50" # Known attacker IP
- "198.51.100.0/24" # Suspicious range
# ============================================
# RULES: The banning logic
# ============================================
rules:
enabled: "true" # Enable/disable rule
bantime: 3h # Ban duration (3 hours)
findtime: 10m # Time window for counting
maxretry: "4" # Trigger ban after N failures
statuscode: "400,401,403-499" # Which codes = failure
# ============================================
# URL-SPECIFIC RULES (optional)
# ============================================
urlregexps:
- regexp: "^/admin" # Protect /admin routes
mode: "block" # Immediate ban on match
- regexp: "^/api/auth" # Protect auth endpoints
mode: "block"Configuration Strategy: Tuning for Your Use Case
Choosing maxretry:
- For public API endpoints: Use
4–5retries. Few legitimate users fail 4 times. - For admin panels: Use
3retries. Admin accounts should rarely mistype passwords. - For sensitive operations (password reset): Use
2retries. Minimize brute-force exposure.
If maxretry is too low, legitimate users with forgotten passwords get blocked (false positives). Too high, and attackers get many free attempts.
Choosing bantime:
- 3 hours: Balanced default. Long enough to deter automated attacks; short enough that legitimate users aren’t locked out overnight.
- 1 hour: Faster recovery for false positives; less deterrent for attackers.
- 24 hours: Maximum security; risk of user frustration.
Choosing findtime:
- 5–10 minutes: Standard for authentication. Most humans retry a few times within 10 minutes, then try again the next day.
- 30 minutes: If you expect bots to spread attacks over time (less common).
Monitoring IPs for the Allowlist:
If you run monitoring software (Prometheus, Uptime Robot, etc.), add those IPs to your allowlist. Otherwise, repeated health checks triggering non-200 responses will get your monitoring blocked!
allowlist:
ip:
- "127.0.0.1" # Localhost
- "10.0.1.10" # Your Prometheus instance
- "203.0.113.100/32" # UptimeRobot static IPURL-Specific Blocking: Protecting Critical Routes
One of the plugin’s most powerful features is the ability to apply different rules—or no rules at all—to specific URLs. This prevents false positives on high-traffic public endpoints while aggressively protecting authentication gateways.
Real-World Scenarios
and part of my setup :)
http:
middlewares:
my-fail2ban:
plugin:
fail2ban:
allowlist:
ip:
- "::1"
- "127.0.0.1"
- "203.0.113.100"
denylist:
ip: 192.168.0.0/24
rules:
bantime: 3h
enabled: "true"
findtime: 10m
maxretry: "4"
statuscode: 400,401,403-499
urlregexps:
- regexp: "/do-not-access"
mode: block
Applying Fail2ban Plugin to Multiple Services
Now that you understand the configuration, let’s apply it across your infrastructure. The key insight: define the middleware once, reference it everywhere.
Apply to Services
In each service’s routing configuration, reference the middleware by name. Here are three examples:
Example 1: Blog Admin Panel
# etc_traefik/dynamic/blog.yml
http:
routers:
blog-https:
rule: "Host(`blog.example.com`)"
service: "blog-backend"
entryPoints:
- websecure
tls:
certResolver: letsencrypt
middlewares:
- security-headers@file
- rate-limit@file
- my-fail2ban@file # <--- Applied here
blog-http:
rule: "Host(`blog.example.com`)"
entryPoints:
- web
middlewares:
- redirect-to-https@file
services:
blog-backend:
loadBalancer:
servers:
- url: "http://blog:8080"Best Practices for Middleware Ordering
Order matters. Here’s the recommended chain:
middlewares:
- security-headers@file # First: Set HTTP headers (no performance impact)
- rate-limit@file # Second: Rate limit (broad protection against bots)
- my-fail2ban@file # Third: Fail2ban (targeted protection against auth attacks)Why this order?
- Security headers are light and should run first.
- Rate-limiting stops bots before they generate many auth failures.
- Fail2ban picks up remaining aggressive auth attackers.
Verifying Your Setup
Configuration is only half the battle.
Test Banning Behavior
Simulate authentication failures and watch fail2ban trigger:
curl -I https://blog.example.org
HTTP/2 200
cache-control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
content-security-policy: default-src https:; script-src 'self' 'unsafe-inline' 'unsafe-eval'; style-src 'self' 'unsafe-inline'; font-src 'self' data:; connect-src 'self'; frame-ancestors 'none';
content-type: text/html; charset=utf-8
date: Fri, 10 Apr 2026 14:59:05 GMT
expires: Thu, 19 Nov 1981 08:52:00 GMT
permissions-policy: geolocation=(), microphone=(), camera=()
pragma: no-cache
server: Apache/2.4.25 (Debian)
set-cookie: fpsess_fp-8654f976=06c0e118e99442af9a7ebd89d04a2657; path=/
strict-transport-security: max-age=15768000; includeSubDomains; preload
x-content-type-options: nosniff
x-frame-options: DENY
x-powered-by: PHP/5.6.40
x-xss-protection: 1; mode=blockDo Not Access
curl -I https://blog.example.org/do-not-access
HTTP/2 429
content-security-policy: default-src https:; script-src 'self' 'unsafe-inline' 'unsafe-eval'; style-src 'self' 'unsafe-inline'; font-src 'self' data:; connect-src 'self'; frame-ancestors 'none';
permissions-policy: geolocation=(), microphone=(), camera=()
strict-transport-security: max-age=15768000; includeSubDomains; preload
x-content-type-options: nosniff
x-frame-options: DENY
x-xss-protection: 1; mode=block
date: Fri, 10 Apr 2026 15:02:47 GMTSo you will see the 429 status which is defined from fail2ban plugin
now if you check again, nothing will be shown :
~> curl https://blog.example.org
~>
~> That’s it my friends ! 🛡️
Disclaimer: coding agent helped with the blog post but all technical notes and examples are mine.
- Details
- Written by: po3dno
- Category: pg
- Hits: 252
select
table_schema,
table_name,
pg_relation_size('"'||table_schema||'"."'||table_name||'"'),
pg_size_pretty(pg_relation_size('"'||table_schema||'"."'||table_name||'"'))
from information_schema.tables
order by 3 desc- Details
- Written by: po3dno
- Category: Linux
- Hits: 276
The repositories for older releases that are not supported get moved to an archive server. There are repositories available at http://old-releases.ubuntu.com.
First, back up this file:
sudo cp /etc/apt/sources.list{,.bak} # Older versions
sudo cp /etc/apt/sources.list.d/ubuntu.sources{,.bak} # Newer Ubuntu uses this file instead
In those files, replace "archive" and "security" in the URLs with "old-releases":
sudo sed -i -re 's/([a-z]{2}\.)?archive.ubuntu.com|security.ubuntu.com/old-releases.ubuntu.com/g' /etc/apt/sources.list{,.d/ubuntu.sources}
Finally, upgrade to a newer release:
sudo apt-get update && sudo apt-get dist-upgrade