Notice
Recent Posts
Recent Comments
Link
«   2025/05   »
일 월 화 수 목 금 토
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
Tags
more
Archives
Today
Total
관리 메뉴

노우!쑤

[Metricbeat] Mssql 본문

DevOps

[Metricbeat] Mssql

no500 2021. 10. 15. 16:01

https://www.elastic.co/kr/beats/metricbeat

 

 

1. 다운로드

https://www.elastic.co/kr/downloads/beats/metricbeat

 

2. 설정(Metricbeat)

#full path : C:\Program Files\metricbeat-7.14.2-windows-x86_64\metricbeat.yml


# ---------------------------- Elasticsearch Output ----------------------------
output.elasticsearch:
  hosts: [{elasticsearch}]
  ssl.verification_mode: none #error x509 
  username: {elasticsearch access username}
  password: {elasticsearch access password}

 

3. 설정(MSSql)

#full path: C:\Program Files\metricbeat-7.14.2-windows-x86_64\modules.d\mssql.yml

- module: mssql
  metricsets:
    - "transaction_log"
    - "performance"
  hosts: ["sqlserver://localhost"]
  username: {username}
  password: {password}
  period: 10s

 

4. 실행

#full path: cmd

#모듈 활성화
>> .\metricbeat.exe modules enable mssql

#실행 
>> .\metricbeat.exe -e

#서비스 등록
>> install-service-metricbeat.ps1

#활성화 모듈 확인
>> .\metricbeat.exe modules list

 

5. 로그확인

C:\Program Files\metricbeat-7.14.2-windows-x86_64\logs

 

 

6. 참고

https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-mssql.html

 

MSSQL module | Metricbeat Reference [7.15] | Elastic

This is the Microsoft SQL 2017 Metricbeat module. It is still under active development to add new Metricsets and introduce enhancements. Compatibilityedit The module is being tested with 2017 GA version under Linux Metricsetsedit The following Metricsets a

www.elastic.co

 

 

'DevOps' 카테고리의 다른 글

[ElasticSearch]설치  (0) 2021.10.21
[ElasticSearch]설정  (0) 2021.10.19
[CentOS7] 명령어  (0) 2021.08.20
[PowerShwll]신뢰할 수 있는 호스트 목록에 컴퓨터를 추가 하는 방법  (0) 2021.08.06
[MSBuild] 버전 확인  (0) 2021.08.05
'DevOps' Related Articles more