apiVersion: apps/v1
kind: Deployment
metadata:
  labels:
    k8s-app: mssql-exporter  # 根据业务需要调整成对应的名称，建议加上 MSSQL 实例的信息
  name: mssql-exporter  # 根据业务需要调整成对应的名称，建议加上 MSSQL 实例的信息
  namespace: mssql-demo  # 根据业务需要调整成对应的命名空间
spec:
  replicas: 1
  selector:
    matchLabels:
      k8s-app: mssql-exporter  # 根据业务需要调整成对应的名称，建议加上 MSSQL 实例的信息
  template:
    metadata:
      labels:
        k8s-app: mssql-exporter  # 根据业务需要调整成对应的名称，建议加上 MSSQL 实例的信息
    spec:
      containers:
      - env:
        - name: SERVER
          value: "127.0.0.1"  # 根据业务需要调整成对应的 MSSQL 的域名
        - name: PORT
          value: "1433"  # 根据业务需要调整成对应的 MSSQL 的端口
        - name: USERNAME
          value: user  # 根据业务需要调整成对应的 MSSQL 的用户名
        - name: PASSWORD
          value: "123456"  # 根据业务需要调整成对应的 MSSQL 的密码
        - name: EXPOSE
          value: "4000"  # 暴露指标端口，根据业务需要调整成对应的端口
        image: ccr.ccs.tencentyun.com/rig-agent/common-image:mssql-exporter-v1.3.0
        imagePullPolicy: IfNotPresent
        name: mssql-exporter
        ports:
        - containerPort: 4000  # 开放上述环境变量 EXPOSE 所对应的端口
          name: metric-port 
        terminationMessagePath: /dev/termination-log
        terminationMessagePolicy: File
      dnsPolicy: ClusterFirst
      imagePullSecrets:
      - name: qcloudregistrykey
      restartPolicy: Always
      schedulerName: default-scheduler
      securityContext: {}
      terminationGracePeriodSeconds: 30


wget -qO- http://localhost:4000/metrics

  apiVersion: monitoring.coreos.com/v1
  kind: PodMonitor
  metadata:
    name: mssql-exporter  # 填写一个唯一名称
    namespace: cm-prometheus  # 按量实例: 集群的 namespace; 包年包月实例(已停止售卖): namespace 固定，不要修改
  spec:
    podMetricsEndpoints:
    - interval: 30s
      port: metric-port    # 填写pod yaml中Prometheus Exporter对应的Port的Name
      path: /metrics  # 填写Prometheus Exporter对应的Path的值，不填默认/metrics
      relabelings:
      - action: replace
        sourceLabels: 
        - instance
        regex: (.*)
        targetLabel: instance
        replacement: 'crs-xxxxxx' # 调整成对应的 MSSQL 实例 ID
    namespaceSelector:   # 选择要监控 mssql exporter pod所在的namespace
      matchNames:
      - mssql-demo
    selector:  # 填写要监控pod的Label值，以定位目标pod
      matchLabels:
        k8s-app: mssql-exporter


USE master;
IF NOT EXISTS (SELECT 1 FROM sys.server_principals WHERE name = 'monitor')
    CREATE LOGIN [monitor] WITH PASSWORD=N'monitor', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;
GRANT VIEW SERVER STATE TO [monitor];
GRANT VIEW ANY DEFINITION TO [monitor];

USE prometheus;
CREATE USER [monitor] FOR LOGIN [monitor];
EXEC sp_addrolemember N'db_datareader', N'monitor';