NRDOT를 사용한 Microsoft SQL Server 모니터링 설정 참조

이 참조는 OpenTelemetry의 뉴렐릭 배포판(NRDOT) Collector를 사용한 Microsoft SQL Server 모니터링을 위한 포괄적인 YAML 설정을 제공합니다. 이 모든 기능을 갖춘 설정에는 Linux 및 Windows 전반의 자체 호스팅 및 AWS RDS 배포 모두에서 운영 환경을 위한 모든 사용 가능한 메트릭, 고급 프로세서 설정 및 최적화된 파이프라인이 포함되어 있습니다.

중요

빠르게 시작하고 싶으십니까? 프로덕션 사용을 위한 고급 설정입니다. SQL Server 모니터링을 처음 설정하는 경우, 설정 가이드의 표준 설정으로 시작하여 기본 기능을 확인한 후 이 포괄적인 설정으로 돌아오는 것을 권장합니다.

리눅스용

이 설정에는 Linux 자체 호스팅 환경에서 포괄적인 가시성을 제공하기 위한 인프라 호스트 메트릭과 데이터베이스 모니터링이 모두 포함되어 있습니다.

데이터베이스 사용자 이름

데이터베이스 비밀번호

SQL Server 호스트명/IP

SQL Server 포트

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

mssql-config.yaml

1
extensions:
2
health_check:
3

4
receivers:
5
otlp:
6
   protocols:
7
     grpc:
8
     http:
9

10
host_metrics:
11
   collection_interval: 30s
12
   scrapers:
13
     cpu:
14
       metrics:
15
         system.cpu.time:
16
           enabled: false
17
         system.cpu.utilization:
18
           enabled: true
19
     load:
20
     memory:
21
       metrics:
22
         system.memory.utilization:
23
           enabled: true
24
     paging:
25
       metrics:
26
         system.paging.utilization:
27
           enabled: false
28
         system.paging.faults:
29
           enabled: false
30
     disk:
31
       metrics:
32
         system.disk.merged:
33
           enabled: false
34
         system.disk.pending_operations:
35
           enabled: false
36
         system.disk.weighted_io_time:
37
           enabled: false
38
     network:
39
       metrics:
40
         system.network.connections:
41
           enabled: false
42
     processes:
43
     process:
44
       mute_process_name_error: true
45
       mute_process_exe_error: true
46
       mute_process_user_error: true
47
       mute_process_io_error: true
48
       metrics:
49
         process.cpu.utilization:
50
           enabled: true
51
         process.memory.utilization:
52
           enabled: true
53

54
nrsqlserver:
55
   collection_interval: 30s
56
   username: newrelic
57
   password: YOUR_PASSWORD
58
   server: sqlserver.example.com
59
   port: 1433
60

61
   # Enable comprehensive database metrics
62
   metrics:
63
     # Database
64
     sqlserver.database.count:
65
       enabled: true
66
     sqlserver.database.file.size:
67
       enabled: true 
68
     sqlserver.database.io:
69
       enabled: true
70
     sqlserver.database.latency:
71
       enabled: true
72
     sqlserver.database.operations:
73
       enabled: true
74
     sqlserver.database.transactions.active:
75
       enabled: true
76
     sqlserver.database.backup_or_restore.rate:
77
       enabled: true
78
     sqlserver.database.execution.errors:
79
       enabled: true
80
     sqlserver.database.full_scan.rate:
81
       enabled: true
82
     sqlserver.database.tempdb.space:
83
       enabled: true
84
     sqlserver.database.tempdb.version_store.size:
85
       enabled: true
86
     # Locks
87
     sqlserver.lock.timeout.rate:
88
       enabled: true
89
     sqlserver.lock.wait.count:
90
       enabled: true
91
     sqlserver.deadlock.rate:
92
       enabled: true
93
     # Transactions
94
     sqlserver.transaction.delay:
95
       enabled: true
96
     sqlserver.transaction.longest_running_time:
97
       enabled: true
98
     sqlserver.transaction.version_cleanup.rate:
99
       enabled: true
100
     sqlserver.transaction.version_generation.rate:
101
       enabled: true
102
     # Memory
103
     sqlserver.memory.area:
104
       enabled: true
105
     sqlserver.memory.cache.object.count:
106
       enabled: true
107
     sqlserver.memory.grants.pending.count:
108
       enabled: true
109
     sqlserver.memory.page.count:
110
       enabled: true
111
     sqlserver.memory.usage:
112
       enabled: true
113
     # OS
114
     sqlserver.os.memory.usage:
115
       enabled: true
116
     sqlserver.os.memory.utilization:
117
       enabled: true
118
     sqlserver.os.scheduler.runnable_tasks.count:
119
       enabled: true
120
     sqlserver.os.wait.duration:
121
       enabled: true
122
     sqlserver.os.wait.tasks.count:
123
       enabled: true
124
     # Pages / Buffer
125
     sqlserver.page.buffer_cache.free_list.stalls.rate:
126
       enabled: true
127
     sqlserver.page.lookup.rate:
128
       enabled: true
129
     # Batch / Compilation
130
     sqlserver.batch.compilation.utilization:
131
       enabled: true
132
     sqlserver.batch.page_split.utilization:
133
       enabled: true
134
     sqlserver.recompilation.ratio:
135
       enabled: true
136
     sqlserver.parameterization.rate:
137
       enabled: true
138
     sqlserver.plan.execution.rate:
139
       enabled: true
140
     sqlserver.attention.rate:
141
       enabled: true
142
     # Processes / Connections
143
     sqlserver.process.count:
144
       enabled: true
145
     sqlserver.processes.blocked:
146
       enabled: true
147
     sqlserver.login.rate:
148
       enabled: true
149
     sqlserver.logout.rate:
150
       enabled: true
151
     # Thread Pool
152
     sqlserver.thread_pool.tasks.count:
153
       enabled: true
154
     sqlserver.thread_pool.workers.count:
155
       enabled: true
156
     sqlserver.thread_pool.workers.max:
157
       enabled: true
158
     sqlserver.thread_pool.workers.utilization:
159
       enabled: true
160
     # TempDB
161
     sqlserver.tempdb.allocation.wait_time.total:
162
       enabled: true
163
     sqlserver.tempdb.contention.waiters.count:
164
       enabled: true
165
     sqlserver.tempdb.data_files.count:
166
       enabled: true
167
     sqlserver.tempdb.file.size:
168
       enabled: true
169
     sqlserver.tempdb.space.usage:
170
       enabled: true
171
     # Latch
172
     sqlserver.latch.superlatch.count:
173
       enabled: true
174
     sqlserver.latch.superlatch.transition.rate:
175
       enabled: true
176
     sqlserver.latch.wait.rate:
177
       enabled: true
178
     sqlserver.latch.wait_time.avg:
179
       enabled: true
180
     sqlserver.latch.wait_time.total:
181
       enabled: true
182
     # Index
183
     sqlserver.index.search.rate:
184
       enabled: true
185
     # Resource Pool
186
     sqlserver.resource_pool.disk.operations:
187
       enabled: true
188
     sqlserver.resource_pool.disk.throttled.read.rate:
189
       enabled: true
190
     sqlserver.resource_pool.disk.throttled.write.rate:
191
       enabled: true
192
     # Replica / Always-On
193
     sqlserver.replica.data.rate:
194
       enabled: true
195
     sqlserver.failover_cluster.ag.cluster_type:
196
       enabled: true
197
     sqlserver.failover_cluster.ag.failure_condition_level:
198
       enabled: true
199
     sqlserver.failover_cluster.ag.health_check_timeout:
200
       enabled: true
201
     sqlserver.failover_cluster.ag.required_sync_secondaries:
202
       enabled: true
203
     sqlserver.failover_cluster.replica.database.queue_size:
204
       enabled: true
205
     sqlserver.failover_cluster.replica.database.redo.rate:
206
       enabled: true
207
     sqlserver.failover_cluster.replica.flow_control_time:
208
       enabled: true
209
     sqlserver.failover_cluster.replica.role:
210
       enabled: true
211
     sqlserver.failover_cluster.replica.synchronization_health:
212
       enabled: true
213
     # Server Properties
214
     sqlserver.computer.uptime:
215
       enabled: true
216
     sqlserver.cpu.count:
217
       enabled: true
218
     # Tables
219
     sqlserver.table.count:
220
       enabled: true
221

222
   # Enable top query and query sample log collection
223
   events:
224
     db.server.query_sample:
225
       enabled: true
226
     db.server.top_query:
227
       enabled: true
228

229
   # Top query collection configuration
230
   top_query_collection:
231
     lookback_time: 45s
232
     max_query_sample_count: 100
233
     top_query_count: 30
234
     collection_interval: 30s
235

236
   collect_full_query_text: true
237
   allowed_comment_keys:
238
     - nr_service_guid
239

240
   # Query sample collection configuration
241
   query_sample_collection:
242
     max_rows_per_query: 50
243

244
processors:
245
metrics_transform:
246
   transforms:
247
     - include: system.cpu.utilization
248
       action: update
249
       operations:
250
         - action: aggregate_labels
251
           label_set: [state]
252
           aggregation_type: mean
253
     - include: system.paging.operations
254
       action: update
255
       operations:
256
         - action: aggregate_labels
257
           label_set: [direction]
258
           aggregation_type: sum
259

260
  filter/exclude_cpu_utilization:
261
   metrics:
262
     datapoint:
263
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
264
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
265
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
266

267
  filter/exclude_memory_utilization:
268
   metrics:
269
     datapoint:
270
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
271
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
272
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
273
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
274
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
275

276
  filter/exclude_memory_usage:
277
   metrics:
278
     datapoint:
279
       - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
280
       - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
281

282
  filter/exclude_filesystem_utilization:
283
   metrics:
284
     datapoint:
285
       - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
286

287
  filter/exclude_filesystem_usage:
288
   metrics:
289
     datapoint:
290
       - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
291
       - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
292

293
  filter/exclude_filesystem_inodes_usage:
294
   metrics:
295
     datapoint:
296
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
297
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
298

299
  filter/exclude_system_disk:
300
   metrics:
301
     datapoint:
302
       - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
303
       - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
304
       - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
305
       - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
306
       - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
307

308
  filter/exclude_network:
309
   metrics:
310
     datapoint:
311
       - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
312

313
  attributes/exclude_system_paging:
314
   include:
315
     match_type: strict
316
     metric_names:
317
       - system.paging.operations
318
   actions:
319
     - key: type
320
       action: delete
321

322
cumulative_to_delta:
323

324
  transform/host:
325
   metric_statements:
326
     - context: metric
327
       statements:
328
         - set(metric.description, "")
329
         - set(metric.unit, "")
330

331
batch:
332

333
  batch/logs:
334
   send_batch_size: 15          # flush target: ~15 records per request
335
   send_batch_max_size: 15      # HARD cap: never emit more than 15 records/request
336
   timeout: 5s
337

338
resource_detection:
339
   detectors: ["system"]
340
   system:
341
     hostname_sources: ["os"]
342
     resource_attributes:
343
       host.id:
344
         enabled: true
345

346
  resource_detection/cloud:
347
   detectors: ["gcp", "ec2", "azure"]
348
   timeout: 2s
349
   override: true
350

351
  resource_detection/env:
352
   detectors: ["env"]
353
   timeout: 2s
354
   override: true
355

356
exporters:
357
otlp:
358
   endpoint: https://otlp.nr-data.net:4318
359
   headers:
360
     api-key: YOUR_LICENSE_KEY
361
   tls:
362
     insecure: false
363
   compression: gzip
364

365
service:
366
telemetry:
367
   metrics:
368
     level: none
369

370
  extensions: [health_check]
371

372
pipelines:
373
   metrics/host:
374
     receivers: [host_metrics, nrsqlserver]
375
     processors:
376
       - metrics_transform
377
       - filter/exclude_cpu_utilization
378
       - filter/exclude_memory_utilization
379
       - filter/exclude_memory_usage
380
       - filter/exclude_filesystem_utilization
381
       - filter/exclude_filesystem_usage
382
       - filter/exclude_filesystem_inodes_usage
383
       - filter/exclude_system_disk
384
       - filter/exclude_network
385
       - attributes/exclude_system_paging
386
       - transform/host
387
       - resource_detection
388
       - resource_detection/cloud
389
       - resource_detection/env
390
       - cumulative_to_delta
391
       - batch
392
     exporters: [otlp]
393

394
   logs/host:
395
     receivers: [nrsqlserver]
396
     processors:
397
       - resource_detection
398
       - resource_detection/cloud
399
       - resource_detection/env
400
       - batch/logs
401
     exporters: [otlp]
402

403
   traces:
404
     receivers: [otlp]
405
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
406
     exporters: [otlp]
407

408
   metrics:
409
     receivers: [otlp]
410
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
411
     exporters: [otlp]
412

413
   logs:
414
     receivers: [otlp]
415
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
416
     exporters: [otlp]

전체 설정을 다운로드하거나 mssql-config.yaml 파일에 붙여넣은 후, Linux 자체 호스팅 가이드를 따라 설정을 완료하십시오.

이 설정은 Linux의 AWS RDS SQL Server 환경에 대해 사용 가능한 모든 메트릭을 포함하여 포괄적인 데이터베이스 모니터링을 제공합니다.

데이터베이스 사용자 이름

데이터베이스 비밀번호

RDS 엔드포인트

SQL Server 포트

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

mssql-config.yaml

1
extensions:
2
health_check:
3

4
receivers:
5
otlp:
6
   protocols:
7
     grpc:
8
     http:
9

10
host_metrics:
11
   collection_interval: 30s
12
   scrapers:
13
     cpu:
14
       metrics:
15
         system.cpu.time:
16
           enabled: false
17
         system.cpu.utilization:
18
           enabled: true
19
     load:
20
     memory:
21
       metrics:
22
         system.memory.utilization:
23
           enabled: true
24
     paging:
25
       metrics:
26
         system.paging.utilization:
27
           enabled: false
28
         system.paging.faults:
29
           enabled: false
30
     disk:
31
       metrics:
32
         system.disk.merged:
33
           enabled: false
34
         system.disk.pending_operations:
35
           enabled: false
36
         system.disk.weighted_io_time:
37
           enabled: false
38
     network:
39
       metrics:
40
         system.network.connections:
41
           enabled: false
42
     processes:
43
     process:
44
       mute_process_name_error: true
45
       mute_process_exe_error: true
46
       mute_process_user_error: true
47
       mute_process_io_error: true
48
       metrics:
49
         process.cpu.utilization:
50
           enabled: true
51
         process.memory.utilization:
52
           enabled: true
53

54
nrsqlserver:
55
   collection_interval: 30s
56
   username: newrelic
57
   password: YOUR_PASSWORD
58
   server: mydb-instance.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com
59
   port: 1433
60

61
   # Enable comprehensive database metrics
62
   metrics:
63
     # Database
64
     sqlserver.database.count:
65
       enabled: true
66
     sqlserver.database.file.size:
67
       enabled: true 
68
     sqlserver.database.io:
69
       enabled: true
70
     sqlserver.database.latency:
71
       enabled: true
72
     sqlserver.database.operations:
73
       enabled: true
74
     sqlserver.database.transactions.active:
75
       enabled: true
76
     sqlserver.database.backup_or_restore.rate:
77
       enabled: true
78
     sqlserver.database.full_scan.rate:
79
       enabled: true
80
     sqlserver.database.tempdb.space:
81
       enabled: true
82
     sqlserver.database.tempdb.version_store.size:
83
       enabled: true
84
     # Locks
85
     sqlserver.lock.timeout.rate:
86
       enabled: true
87
     sqlserver.lock.wait.count:
88
       enabled: true
89
     sqlserver.deadlock.rate:
90
       enabled: true
91
     # Transactions
92
     sqlserver.transaction.delay:
93
       enabled: true
94
     sqlserver.transaction.longest_running_time:
95
       enabled: true
96
     sqlserver.transaction.version_cleanup.rate:
97
       enabled: true
98
     sqlserver.transaction.version_generation.rate:
99
       enabled: true
100
     # Memory
101
     sqlserver.memory.area:
102
       enabled: true
103
     sqlserver.memory.cache.object.count:
104
       enabled: true
105
     sqlserver.memory.grants.pending.count:
106
       enabled: true
107
     sqlserver.memory.page.count:
108
       enabled: true
109
     sqlserver.memory.usage:
110
       enabled: true
111
     # OS
112
     sqlserver.os.memory.usage:
113
       enabled: true
114
     sqlserver.os.memory.utilization:
115
       enabled: true
116
     sqlserver.os.scheduler.runnable_tasks.count:
117
       enabled: true
118
     sqlserver.os.wait.duration:
119
       enabled: true
120
     sqlserver.os.wait.tasks.count:
121
       enabled: true
122
     # Pages / Buffer
123
     sqlserver.page.buffer_cache.free_list.stalls.rate:
124
       enabled: true
125
     sqlserver.page.lookup.rate:
126
       enabled: true
127
     # Batch / Compilation
128
     sqlserver.batch.compilation.utilization:
129
       enabled: true
130
     sqlserver.batch.page_split.utilization:
131
       enabled: true
132
     sqlserver.recompilation.ratio:
133
       enabled: true
134
     sqlserver.parameterization.rate:
135
       enabled: true
136
     sqlserver.plan.execution.rate:
137
       enabled: true
138
     sqlserver.attention.rate:
139
       enabled: true
140
     # Processes / Connections
141
     sqlserver.process.count:
142
       enabled: true
143
     sqlserver.processes.blocked:
144
       enabled: true
145
     sqlserver.login.rate:
146
       enabled: true
147
     sqlserver.logout.rate:
148
       enabled: true
149
     # Thread Pool
150
     sqlserver.thread_pool.tasks.count:
151
       enabled: true
152
     sqlserver.thread_pool.workers.count:
153
       enabled: true
154
     sqlserver.thread_pool.workers.max:
155
       enabled: true
156
     sqlserver.thread_pool.workers.utilization:
157
       enabled: true
158
     # TempDB
159
     sqlserver.tempdb.allocation.wait_time.total:
160
       enabled: true
161
     sqlserver.tempdb.contention.waiters.count:
162
       enabled: true
163
     sqlserver.tempdb.data_files.count:
164
       enabled: true
165
     sqlserver.tempdb.file.size:
166
       enabled: true
167
     sqlserver.tempdb.space.usage:
168
       enabled: true
169
     # Latch
170
     sqlserver.latch.superlatch.count:
171
       enabled: true
172
     sqlserver.latch.superlatch.transition.rate:
173
       enabled: true
174
     sqlserver.latch.wait.rate:
175
       enabled: true
176
     sqlserver.latch.wait_time.avg:
177
       enabled: true
178
     sqlserver.latch.wait_time.total:
179
       enabled: true
180
     # Index
181
     sqlserver.index.search.rate:
182
       enabled: true
183
     # Resource Pool
184
     sqlserver.resource_pool.disk.operations:
185
       enabled: true
186
     sqlserver.resource_pool.disk.throttled.read.rate:
187
       enabled: true
188
     sqlserver.resource_pool.disk.throttled.write.rate:
189
       enabled: true
190
     # Replica / Always-On
191
     sqlserver.replica.data.rate:
192
       enabled: true
193
     sqlserver.failover_cluster.ag.cluster_type:
194
       enabled: true
195
     sqlserver.failover_cluster.ag.failure_condition_level:
196
       enabled: true
197
     sqlserver.failover_cluster.ag.health_check_timeout:
198
       enabled: true
199
     sqlserver.failover_cluster.ag.required_sync_secondaries:
200
       enabled: true
201
     sqlserver.failover_cluster.replica.database.queue_size:
202
       enabled: true
203
     sqlserver.failover_cluster.replica.database.redo.rate:
204
       enabled: true
205
     sqlserver.failover_cluster.replica.flow_control_time:
206
       enabled: true
207
     sqlserver.failover_cluster.replica.role:
208
       enabled: true
209
     sqlserver.failover_cluster.replica.synchronization_health:
210
       enabled: true
211
     # Server Properties
212
     sqlserver.computer.uptime:
213
       enabled: true
214
     sqlserver.cpu.count:
215
       enabled: true
216
     # Tables
217
     sqlserver.table.count:
218
       enabled: true
219
   # Enable top query and query sample log collection
220
   events:
221
     db.server.query_sample:
222
       enabled: true
223
     db.server.top_query:
224
       enabled: true
225
   # Top query collection configuration
226
   top_query_collection:
227
     lookback_time: 45s
228
     max_query_sample_count: 100
229
     top_query_count: 30
230
     collection_interval: 30s
231
   collect_full_query_text: true
232
   allowed_comment_keys:
233
     - nr_service_guid
234
   # Query sample collection configuration
235
   query_sample_collection:
236
     max_rows_per_query: 50
237
processors:
238
metrics_transform:
239
   transforms:
240
     - include: system.cpu.utilization
241
       action: update
242
       operations:
243
         - action: aggregate_labels
244
           label_set: [state]
245
           aggregation_type: mean
246
     - include: system.paging.operations
247
       action: update
248
       operations:
249
         - action: aggregate_labels
250
           label_set: [direction]
251
           aggregation_type: sum
252
  filter/exclude_cpu_utilization:
253
   metrics:
254
     datapoint:
255
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
256
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
257
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
258
  filter/exclude_memory_utilization:
259
   metrics:
260
     datapoint:
261
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
262
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
263
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
264
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
265
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
266
  filter/exclude_memory_usage:
267
   metrics:
268
     datapoint:
269
       - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
270
       - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
271
  filter/exclude_filesystem_utilization:
272
   metrics:
273
     datapoint:
274
       - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
275
  filter/exclude_filesystem_usage:
276
   metrics:
277
     datapoint:
278
       - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
279
       - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
280
  filter/exclude_filesystem_inodes_usage:
281
   metrics:
282
     datapoint:
283
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
284
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
285
  filter/exclude_system_disk:
286
   metrics:
287
     datapoint:
288
       - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
289
       - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
290
       - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
291
       - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
292
       - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
293
  filter/exclude_network:
294
   metrics:
295
     datapoint:
296
       - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
297
  attributes/exclude_system_paging:
298
   include:
299
     match_type: strict
300
     metric_names:
301
       - system.paging.operations
302
   actions:
303
     - key: type
304
       action: delete
305
cumulative_to_delta:
306
  transform/host:
307
   metric_statements:
308
     - context: metric
309
       statements:
310
         - set(metric.description, "")
311
         - set(metric.unit, "")
312
batch:
313

314
  batch/logs:
315
   send_batch_size: 15          # flush target: ~15 records per request
316
   send_batch_max_size: 15      # HARD cap: never emit more than 15 records/request
317
   timeout: 5s
318

319
resource_detection:
320
   detectors: ["system"]
321
   system:
322
     hostname_sources: ["os"]
323
     resource_attributes:
324
       host.id:
325
         enabled: true
326
  resource_detection/cloud:
327
   detectors: ["gcp", "ec2", "azure"]
328
   timeout: 2s
329
   override: true
330
  resource_detection/env:
331
   detectors: ["env"]
332
   timeout: 2s
333
   override: true
334
exporters:
335
otlp:
336
   endpoint: https://otlp.nr-data.net:4318
337
   headers:
338
     api-key: YOUR_LICENSE_KEY
339
   tls:
340
     insecure: false
341
   compression: gzip
342
service:
343
telemetry:
344
   metrics:
345
     level: none
346
  extensions: [health_check]
347
pipelines:
348
   metrics/host:
349
     receivers: [host_metrics, nrsqlserver]
350
     processors:
351
       - metrics_transform
352
       - filter/exclude_cpu_utilization
353
       - filter/exclude_memory_utilization
354
       - filter/exclude_memory_usage
355
       - filter/exclude_filesystem_utilization
356
       - filter/exclude_filesystem_usage
357
       - filter/exclude_filesystem_inodes_usage
358
       - filter/exclude_system_disk
359
       - filter/exclude_network
360
       - attributes/exclude_system_paging
361
       - transform/host
362
       - resource_detection
363
       - resource_detection/cloud
364
       - resource_detection/env
365
       - cumulative_to_delta
366
       - batch
367
     exporters: [otlp]
368
   logs/host:
369
     receivers: [nrsqlserver]
370
     processors:
371
       - resource_detection
372
       - resource_detection/cloud
373
       - resource_detection/env
374
       - batch/logs
375
     exporters: [otlp]
376
   traces:
377
     receivers: [otlp]
378
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
379
     exporters: [otlp]
380
   metrics:
381
     receivers: [otlp]
382
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
383
     exporters: [otlp]
384
   logs:
385
     receivers: [otlp]
386
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
387
     exporters: [otlp]

전체 설정을 다운로드하거나 mssql-config.yaml 파일에 붙여넣은 후 Linux RDS 가이드를 따라 설정을 완료하십시오.

Windows용

이 설정은 인프라 호스트 메트릭 및 데이터베이스 모니터링을 모두 포함하여 SQL Server 인증을 사용하는 Windows 자체 호스팅 환경에 대한 포괄적인 모니터링을 제공합니다.

SQL Server 사용자 이름

SQL Server 비밀번호

서버 호스트명/IP

서버 포트

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

mssql-config.yaml

1
extensions:
2
health_check:
3

4
receivers:
5
otlp:
6
   protocols:
7
     grpc:
8
     http:
9

10
host_metrics:
11
   collection_interval: 30s
12
   scrapers:
13
     cpu:
14
       metrics:
15
         system.cpu.time:
16
           enabled: false
17
         system.cpu.utilization:
18
           enabled: true
19
     load:
20
     memory:
21
       metrics:
22
         system.memory.utilization:
23
           enabled: true
24
     paging:
25
       metrics:
26
         system.paging.utilization:
27
           enabled: false
28
         system.paging.faults:
29
           enabled: false
30
     disk:
31
       metrics:
32
         system.disk.merged:
33
           enabled: false
34
         system.disk.pending_operations:
35
           enabled: false
36
         system.disk.weighted_io_time:
37
           enabled: false
38
     network:
39
       metrics:
40
         system.network.connections:
41
           enabled: false
42
     processes:
43
     process:
44
       mute_process_name_error: true
45
       mute_process_exe_error: true
46
       mute_process_user_error: true
47
       mute_process_io_error: true
48
       metrics:
49
         process.cpu.utilization:
50
           enabled: true
51
         process.memory.utilization:
52
           enabled: true
53

54
nrsqlserver:
55
   collection_interval: 30s
56
   username: newrelic
57
   password: YOUR_PASSWORD
58
   server: sqlserver.example.com
59
   port: 1433
60

61
   # Enable comprehensive database metrics
62
   metrics:
63
     # Database
64
     sqlserver.database.count:
65
       enabled: true
66
     sqlserver.database.file.size:
67
       enabled: true 
68
     sqlserver.database.io:
69
       enabled: true
70
     sqlserver.database.latency:
71
       enabled: true
72
     sqlserver.database.operations:
73
       enabled: true
74
     sqlserver.database.transactions.active:
75
       enabled: true
76
     sqlserver.database.backup_or_restore.rate:
77
       enabled: true
78
     sqlserver.database.execution.errors:
79
       enabled: true
80
     sqlserver.database.full_scan.rate:
81
       enabled: true
82
     sqlserver.database.tempdb.space:
83
       enabled: true
84
     sqlserver.database.tempdb.version_store.size:
85
       enabled: true
86
     # Locks
87
     sqlserver.lock.timeout.rate:
88
       enabled: true
89
     sqlserver.lock.wait.count:
90
       enabled: true
91
     sqlserver.deadlock.rate:
92
       enabled: true
93
     # Transactions
94
     sqlserver.transaction.delay:
95
       enabled: true
96
     sqlserver.transaction.longest_running_time:
97
       enabled: true
98
     sqlserver.transaction.version_cleanup.rate:
99
       enabled: true
100
     sqlserver.transaction.version_generation.rate:
101
       enabled: true
102
     # Memory
103
     sqlserver.memory.area:
104
       enabled: true
105
     sqlserver.memory.cache.object.count:
106
       enabled: true
107
     sqlserver.memory.grants.pending.count:
108
       enabled: true
109
     sqlserver.memory.page.count:
110
       enabled: true
111
     sqlserver.memory.usage:
112
       enabled: true
113
     # OS
114
     sqlserver.os.memory.usage:
115
       enabled: true
116
     sqlserver.os.memory.utilization:
117
       enabled: true
118
     sqlserver.os.scheduler.runnable_tasks.count:
119
       enabled: true
120
     sqlserver.os.wait.duration:
121
       enabled: true
122
     sqlserver.os.wait.tasks.count:
123
       enabled: true
124
     # Pages / Buffer
125
     sqlserver.page.buffer_cache.free_list.stalls.rate:
126
       enabled: true
127
     sqlserver.page.lookup.rate:
128
       enabled: true
129
     # Batch / Compilation
130
     sqlserver.batch.compilation.utilization:
131
       enabled: true
132
     sqlserver.batch.page_split.utilization:
133
       enabled: true
134
     sqlserver.recompilation.ratio:
135
       enabled: true
136
     sqlserver.parameterization.rate:
137
       enabled: true
138
     sqlserver.plan.execution.rate:
139
       enabled: true
140
     sqlserver.attention.rate:
141
       enabled: true
142
     # Processes / Connections
143
     sqlserver.process.count:
144
       enabled: true
145
     sqlserver.processes.blocked:
146
       enabled: true
147
     sqlserver.login.rate:
148
       enabled: true
149
     sqlserver.logout.rate:
150
       enabled: true
151
     # Thread Pool
152
     sqlserver.thread_pool.tasks.count:
153
       enabled: true
154
     sqlserver.thread_pool.workers.count:
155
       enabled: true
156
     sqlserver.thread_pool.workers.max:
157
       enabled: true
158
     sqlserver.thread_pool.workers.utilization:
159
       enabled: true
160
     # TempDB
161
     sqlserver.tempdb.allocation.wait_time.total:
162
       enabled: true
163
     sqlserver.tempdb.contention.waiters.count:
164
       enabled: true
165
     sqlserver.tempdb.data_files.count:
166
       enabled: true
167
     sqlserver.tempdb.file.size:
168
       enabled: true
169
     sqlserver.tempdb.space.usage:
170
       enabled: true
171
     # Latch
172
     sqlserver.latch.superlatch.count:
173
       enabled: true
174
     sqlserver.latch.superlatch.transition.rate:
175
       enabled: true
176
     sqlserver.latch.wait.rate:
177
       enabled: true
178
     sqlserver.latch.wait_time.avg:
179
       enabled: true
180
     sqlserver.latch.wait_time.total:
181
       enabled: true
182
     # Index
183
     sqlserver.index.search.rate:
184
       enabled: true
185
     # Resource Pool
186
     sqlserver.resource_pool.disk.operations:
187
       enabled: true
188
     sqlserver.resource_pool.disk.throttled.read.rate:
189
       enabled: true
190
     sqlserver.resource_pool.disk.throttled.write.rate:
191
       enabled: true
192
     # Replica / Always-On
193
     sqlserver.replica.data.rate:
194
       enabled: true
195
     sqlserver.failover_cluster.ag.cluster_type:
196
       enabled: true
197
     sqlserver.failover_cluster.ag.failure_condition_level:
198
       enabled: true
199
     sqlserver.failover_cluster.ag.health_check_timeout:
200
       enabled: true
201
     sqlserver.failover_cluster.ag.required_sync_secondaries:
202
       enabled: true
203
     sqlserver.failover_cluster.replica.database.queue_size:
204
       enabled: true
205
     sqlserver.failover_cluster.replica.database.redo.rate:
206
       enabled: true
207
     sqlserver.failover_cluster.replica.flow_control_time:
208
       enabled: true
209
     sqlserver.failover_cluster.replica.role:
210
       enabled: true
211
     sqlserver.failover_cluster.replica.synchronization_health:
212
       enabled: true
213
     # Server Properties
214
     sqlserver.computer.uptime:
215
       enabled: true
216
     sqlserver.cpu.count:
217
       enabled: true
218
     # Tables
219
     sqlserver.table.count:
220
       enabled: true
221

222
   # Enable top query and query sample log collection
223
   events:
224
     db.server.query_sample:
225
       enabled: true
226
     db.server.top_query:
227
       enabled: true
228

229
   # Top query collection configuration
230
   top_query_collection:
231
     lookback_time: 45s
232
     max_query_sample_count: 100
233
     top_query_count: 30
234
     collection_interval: 30s
235

236
   collect_full_query_text: true
237
   allowed_comment_keys:
238
     - nr_service_guid
239

240
   # Query sample collection configuration
241
   query_sample_collection:
242
     max_rows_per_query: 50
243

244
processors:
245
metrics_transform:
246
   transforms:
247
     - include: system.cpu.utilization
248
       action: update
249
       operations:
250
         - action: aggregate_labels
251
           label_set: [state]
252
           aggregation_type: mean
253
     - include: system.paging.operations
254
       action: update
255
       operations:
256
         - action: aggregate_labels
257
           label_set: [direction]
258
           aggregation_type: sum
259

260
  filter/exclude_cpu_utilization:
261
   metrics:
262
     datapoint:
263
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
264
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
265
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
266

267
  filter/exclude_memory_utilization:
268
   metrics:
269
     datapoint:
270
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
271
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
272
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
273
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
274
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
275

276
  filter/exclude_memory_usage:
277
   metrics:
278
     datapoint:
279
       - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
280
       - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
281

282
  filter/exclude_filesystem_utilization:
283
   metrics:
284
     datapoint:
285
       - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
286

287
  filter/exclude_filesystem_usage:
288
   metrics:
289
     datapoint:
290
       - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
291
       - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
292

293
  filter/exclude_filesystem_inodes_usage:
294
   metrics:
295
     datapoint:
296
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
297
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
298

299
  filter/exclude_system_disk:
300
   metrics:
301
     datapoint:
302
       - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
303
       - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
304
       - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
305
       - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
306
       - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
307

308
  filter/exclude_network:
309
   metrics:
310
     datapoint:
311
       - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
312

313
  attributes/exclude_system_paging:
314
   include:
315
     match_type: strict
316
     metric_names:
317
       - system.paging.operations
318
   actions:
319
     - key: type
320
       action: delete
321

322
cumulative_to_delta:
323

324
  transform/host:
325
   metric_statements:
326
     - context: metric
327
       statements:
328
         - set(metric.description, "")
329
         - set(metric.unit, "")
330

331
batch:
332

333
  batch/logs:
334
   send_batch_size: 15          # flush target: ~15 records per request
335
   send_batch_max_size: 15      # HARD cap: never emit more than 15 records/request
336
   timeout: 5s
337

338
resource_detection:
339
   detectors: ["system"]
340
   system:
341
     hostname_sources: ["os"]
342
     resource_attributes:
343
       host.id:
344
         enabled: true
345

346
  resource_detection/cloud:
347
   detectors: ["gcp", "ec2", "azure"]
348
   timeout: 2s
349
   override: true
350

351
  resource_detection/env:
352
   detectors: ["env"]
353
   timeout: 2s
354
   override: true
355

356
exporters:
357
otlp:
358
   endpoint: https://otlp.nr-data.net:4318
359
   headers:
360
     api-key: YOUR_LICENSE_KEY
361
   tls:
362
     insecure: false
363
   compression: gzip
364

365
service:
366
telemetry:
367
   metrics:
368
     level: none
369

370
  extensions: [health_check]
371

372
pipelines:
373
   metrics/host:
374
     receivers: [host_metrics, nrsqlserver]
375
     processors:
376
       - metrics_transform
377
       - filter/exclude_cpu_utilization
378
       - filter/exclude_memory_utilization
379
       - filter/exclude_memory_usage
380
       - filter/exclude_filesystem_utilization
381
       - filter/exclude_filesystem_usage
382
       - filter/exclude_filesystem_inodes_usage
383
       - filter/exclude_system_disk
384
       - filter/exclude_network
385
       - attributes/exclude_system_paging
386
       - transform/host
387
       - resource_detection
388
       - resource_detection/cloud
389
       - resource_detection/env
390
       - cumulative_to_delta
391
       - batch
392
     exporters: [otlp]
393

394
   logs/host:
395
     receivers: [nrsqlserver]
396
     processors:
397
       - resource_detection
398
       - resource_detection/cloud
399
       - resource_detection/env
400
       - batch/logs
401
     exporters: [otlp]
402

403
   traces:
404
     receivers: [otlp]
405
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
406
     exporters: [otlp]
407

408
   metrics:
409
     receivers: [otlp]
410
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
411
     exporters: [otlp]
412

413
   logs:
414
     receivers: [otlp]
415
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
416
     exporters: [otlp]

전체 설정을 다운로드하거나 mssql-config.yaml 파일에 붙여넣은 후, Windows 자체 호스팅 가이드를 따라 SQL Server 인증 방법을 사용하여 설정을 완료하십시오.

이 설정은 Windows 도메인 인증(통합 보안)을 사용하는 Windows 자체 호스팅 환경을 위한 포괄적인 인프라 호스트 메트릭 및 데이터베이스 모니터링을 제공합니다.

아래에 값을 입력하고 실시간으로 설정 업데이트를 확인하십시오:

SQL Server 호스트명/IP

SQL Server 포트

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

mssql-config.yaml

1
extensions:
2
health_check:
3

4
receivers:
5
otlp:
6
   protocols:
7
     grpc:
8
     http:
9

10
host_metrics:
11
   collection_interval: 30s
12
   scrapers:
13
     cpu:
14
       metrics:
15
         system.cpu.time:
16
           enabled: false
17
         system.cpu.utilization:
18
           enabled: true
19
     load:
20
     memory:
21
       metrics:
22
         system.memory.utilization:
23
           enabled: true
24
     paging:
25
       metrics:
26
         system.paging.utilization:
27
           enabled: false
28
         system.paging.faults:
29
           enabled: false
30
     disk:
31
       metrics:
32
         system.disk.merged:
33
           enabled: false
34
         system.disk.pending_operations:
35
           enabled: false
36
         system.disk.weighted_io_time:
37
           enabled: false
38
     network:
39
       metrics:
40
         system.network.connections:
41
           enabled: false
42
     processes:
43
     process:
44
       mute_process_name_error: true
45
       mute_process_exe_error: true
46
       mute_process_user_error: true
47
       mute_process_io_error: true
48
       metrics:
49
         process.cpu.utilization:
50
           enabled: true
51
         process.memory.utilization:
52
           enabled: true
53

54
nrsqlserver:
55
   collection_interval: 30s
56
   datasource: "server=sqlserver.example.com;port=1433;integrated security=true;encrypt=true;TrustServerCertificate=true;"
57

58
   # Enable comprehensive database metrics
59
   metrics:
60
     # Database
61
     sqlserver.database.count:
62
       enabled: true
63
     sqlserver.database.file.size:
64
       enabled: true 
65
     sqlserver.database.io:
66
       enabled: true
67
     sqlserver.database.latency:
68
       enabled: true
69
     sqlserver.database.operations:
70
       enabled: true
71
     sqlserver.database.transactions.active:
72
       enabled: true
73
     sqlserver.database.backup_or_restore.rate:
74
       enabled: true
75
     sqlserver.database.execution.errors:
76
       enabled: true
77
     sqlserver.database.full_scan.rate:
78
       enabled: true
79
     sqlserver.database.tempdb.space:
80
       enabled: true
81
     sqlserver.database.tempdb.version_store.size:
82
       enabled: true
83
     # Locks
84
     sqlserver.lock.timeout.rate:
85
       enabled: true
86
     sqlserver.lock.wait.count:
87
       enabled: true
88
     sqlserver.deadlock.rate:
89
       enabled: true
90
     # Transactions
91
     sqlserver.transaction.delay:
92
       enabled: true
93
     sqlserver.transaction.longest_running_time:
94
       enabled: true
95
     sqlserver.transaction.version_cleanup.rate:
96
       enabled: true
97
     sqlserver.transaction.version_generation.rate:
98
       enabled: true
99
     # Memory
100
     sqlserver.memory.area:
101
       enabled: true
102
     sqlserver.memory.cache.object.count:
103
       enabled: true
104
     sqlserver.memory.grants.pending.count:
105
       enabled: true
106
     sqlserver.memory.page.count:
107
       enabled: true
108
     sqlserver.memory.usage:
109
       enabled: true
110
     # OS
111
     sqlserver.os.memory.usage:
112
       enabled: true
113
     sqlserver.os.memory.utilization:
114
       enabled: true
115
     sqlserver.os.scheduler.runnable_tasks.count:
116
       enabled: true
117
     sqlserver.os.wait.duration:
118
       enabled: true
119
     sqlserver.os.wait.tasks.count:
120
       enabled: true
121
     # Pages / Buffer
122
     sqlserver.page.buffer_cache.free_list.stalls.rate:
123
       enabled: true
124
     sqlserver.page.lookup.rate:
125
       enabled: true
126
     # Batch / Compilation
127
     sqlserver.batch.compilation.utilization:
128
       enabled: true
129
     sqlserver.batch.page_split.utilization:
130
       enabled: true
131
     sqlserver.recompilation.ratio:
132
       enabled: true
133
     sqlserver.parameterization.rate:
134
       enabled: true
135
     sqlserver.plan.execution.rate:
136
       enabled: true
137
     sqlserver.attention.rate:
138
       enabled: true
139
     # Processes / Connections
140
     sqlserver.process.count:
141
       enabled: true
142
     sqlserver.processes.blocked:
143
       enabled: true
144
     sqlserver.login.rate:
145
       enabled: true
146
     sqlserver.logout.rate:
147
       enabled: true
148
     # Thread Pool
149
     sqlserver.thread_pool.tasks.count:
150
       enabled: true
151
     sqlserver.thread_pool.workers.count:
152
       enabled: true
153
     sqlserver.thread_pool.workers.max:
154
       enabled: true
155
     sqlserver.thread_pool.workers.utilization:
156
       enabled: true
157
     # TempDB
158
     sqlserver.tempdb.allocation.wait_time.total:
159
       enabled: true
160
     sqlserver.tempdb.contention.waiters.count:
161
       enabled: true
162
     sqlserver.tempdb.data_files.count:
163
       enabled: true
164
     sqlserver.tempdb.file.size:
165
       enabled: true
166
     sqlserver.tempdb.space.usage:
167
       enabled: true
168
     # Latch
169
     sqlserver.latch.superlatch.count:
170
       enabled: true
171
     sqlserver.latch.superlatch.transition.rate:
172
       enabled: true
173
     sqlserver.latch.wait.rate:
174
       enabled: true
175
     sqlserver.latch.wait_time.avg:
176
       enabled: true
177
     sqlserver.latch.wait_time.total:
178
       enabled: true
179
     # Index
180
     sqlserver.index.search.rate:
181
       enabled: true
182
     # Resource Pool
183
     sqlserver.resource_pool.disk.operations:
184
       enabled: true
185
     sqlserver.resource_pool.disk.throttled.read.rate:
186
       enabled: true
187
     sqlserver.resource_pool.disk.throttled.write.rate:
188
       enabled: true
189
     # Replica / Always-On
190
     sqlserver.replica.data.rate:
191
       enabled: true
192
     sqlserver.failover_cluster.ag.cluster_type:
193
       enabled: true
194
     sqlserver.failover_cluster.ag.failure_condition_level:
195
       enabled: true
196
     sqlserver.failover_cluster.ag.health_check_timeout:
197
       enabled: true
198
     sqlserver.failover_cluster.ag.required_sync_secondaries:
199
       enabled: true
200
     sqlserver.failover_cluster.replica.database.queue_size:
201
       enabled: true
202
     sqlserver.failover_cluster.replica.database.redo.rate:
203
       enabled: true
204
     sqlserver.failover_cluster.replica.flow_control_time:
205
       enabled: true
206
     sqlserver.failover_cluster.replica.role:
207
       enabled: true
208
     sqlserver.failover_cluster.replica.synchronization_health:
209
       enabled: true
210
     # Server Properties
211
     sqlserver.computer.uptime:
212
       enabled: true
213
     sqlserver.cpu.count:
214
       enabled: true
215
     # Tables
216
     sqlserver.table.count:
217
       enabled: true
218
   # Enable top query and query sample log collection
219
   events:
220
     db.server.query_sample:
221
       enabled: true
222
     db.server.top_query:
223
       enabled: true
224

225
   # Top query collection configuration
226
   top_query_collection:
227
     lookback_time: 45s
228
     max_query_sample_count: 100
229
     top_query_count: 30
230
     collection_interval: 30s
231

232
   collect_full_query_text: true
233
   allowed_comment_keys:
234
     - nr_service_guid
235

236
   # Query sample collection configuration
237
   query_sample_collection:
238
     max_rows_per_query: 50
239

240
processors:
241
metrics_transform:
242
   transforms:
243
     - include: system.cpu.utilization
244
       action: update
245
       operations:
246
         - action: aggregate_labels
247
           label_set: [state]
248
           aggregation_type: mean
249
     - include: system.paging.operations
250
       action: update
251
       operations:
252
         - action: aggregate_labels
253
           label_set: [direction]
254
           aggregation_type: sum
255

256
  filter/exclude_cpu_utilization:
257
   metrics:
258
     datapoint:
259
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
260
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
261
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
262

263
  filter/exclude_memory_utilization:
264
   metrics:
265
     datapoint:
266
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
267
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
268
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
269
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
270
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
271

272
  filter/exclude_memory_usage:
273
   metrics:
274
     datapoint:
275
       - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
276
       - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
277

278
  filter/exclude_filesystem_utilization:
279
   metrics:
280
     datapoint:
281
       - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
282

283
  filter/exclude_filesystem_usage:
284
   metrics:
285
     datapoint:
286
       - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
287
       - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
288

289
  filter/exclude_filesystem_inodes_usage:
290
   metrics:
291
     datapoint:
292
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
293
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
294

295
  filter/exclude_system_disk:
296
   metrics:
297
     datapoint:
298
       - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
299
       - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
300
       - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
301
       - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
302
       - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
303

304
  filter/exclude_network:
305
   metrics:
306
     datapoint:
307
       - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
308

309
  attributes/exclude_system_paging:
310
   include:
311
     match_type: strict
312
     metric_names:
313
       - system.paging.operations
314
   actions:
315
     - key: type
316
       action: delete
317

318
cumulative_to_delta:
319

320
  transform/host:
321
   metric_statements:
322
     - context: metric
323
       statements:
324
         - set(metric.description, "")
325
         - set(metric.unit, "")
326

327
batch:
328

329
  batch/logs:
330
   send_batch_size: 15          # flush target: ~15 records per request
331
   send_batch_max_size: 15      # HARD cap: never emit more than 15 records/request
332
   timeout: 5s
333

334
resource_detection:
335
   detectors: ["system"]
336
   system:
337
     hostname_sources: ["os"]
338
     resource_attributes:
339
       host.id:
340
         enabled: true
341

342
  resource_detection/cloud:
343
   detectors: ["gcp", "ec2", "azure"]
344
   timeout: 2s
345
   override: true
346

347
  resource_detection/env:
348
   detectors: ["env"]
349
   timeout: 2s
350
   override: true
351

352
exporters:
353
otlp:
354
   endpoint: https://otlp.nr-data.net:4318
355
   headers:
356
     api-key: YOUR_LICENSE_KEY
357
   tls:
358
     insecure: false
359
   compression: gzip
360

361
service:
362
telemetry:
363
   metrics:
364
     level: none
365

366
  extensions: [health_check]
367

368
pipelines:
369
   metrics/host:
370
     receivers: [host_metrics, nrsqlserver]
371
     processors:
372
       - metrics_transform
373
       - filter/exclude_cpu_utilization
374
       - filter/exclude_memory_utilization
375
       - filter/exclude_memory_usage
376
       - filter/exclude_filesystem_utilization
377
       - filter/exclude_filesystem_usage
378
       - filter/exclude_filesystem_inodes_usage
379
       - filter/exclude_system_disk
380
       - filter/exclude_network
381
       - attributes/exclude_system_paging
382
       - transform/host
383
       - resource_detection
384
       - resource_detection/cloud
385
       - resource_detection/env
386
       - cumulative_to_delta
387
       - batch
388
     exporters: [otlp]
389

390
   logs/host:
391
     receivers: [nrsqlserver]
392
     processors:
393
       - resource_detection
394
       - resource_detection/cloud
395
       - resource_detection/env
396
       - batch/logs
397
     exporters: [otlp]
398

399
   traces:
400
     receivers: [otlp]
401
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
402
     exporters: [otlp]
403

404
   metrics:
405
     receivers: [otlp]
406
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
407
     exporters: [otlp]
408

409
   logs:
410
     receivers: [otlp]
411
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
412
     exporters: [otlp]

전체 설정을 다운로드하거나 mssql-config.yaml 파일에 붙여넣은 후, Windows 자체 호스팅 가이드를 따라 Windows 인증 방법을 사용하여 설정을 완료하십시오.

이 설정에는 gMSA 인증을 사용하는 데이터베이스 모니터링이 포함됩니다.

아래에 값을 입력하고 실시간으로 설정 업데이트를 확인하십시오:

SQL Server 호스트명/IP

SQL Server 포트

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

mssql-config.yaml

1
extensions:
2
health_check:
3

4
receivers:
5
otlp:
6
   protocols:
7
     grpc:
8
     http:
9

10
host_metrics:
11
   collection_interval: 30s
12
   scrapers:
13
     cpu:
14
       metrics:
15
         system.cpu.time:
16
           enabled: false
17
         system.cpu.utilization:
18
           enabled: true
19
     load:
20
     memory:
21
       metrics:
22
         system.memory.utilization:
23
           enabled: true
24
     paging:
25
       metrics:
26
         system.paging.utilization:
27
           enabled: false
28
         system.paging.faults:
29
           enabled: false
30
     disk:
31
       metrics:
32
         system.disk.merged:
33
           enabled: false
34
         system.disk.pending_operations:
35
           enabled: false
36
         system.disk.weighted_io_time:
37
           enabled: false
38
     network:
39
       metrics:
40
         system.network.connections:
41
           enabled: false
42
     processes:
43
     process:
44
       mute_process_name_error: true
45
       mute_process_exe_error: true
46
       mute_process_user_error: true
47
       mute_process_io_error: true
48
       metrics:
49
         process.cpu.utilization:
50
           enabled: true
51
         process.memory.utilization:
52
           enabled: true
53

54
nrsqlserver:
55
   collection_interval: 30s
56
   datasource: "server=sqlserver.example.com;port=1433;integrated security=true;encrypt=true;TrustServerCertificate=true;"
57

58
   # Enable comprehensive database metrics
59
   metrics:
60
     # Database
61
     sqlserver.database.count:
62
       enabled: true
63
     sqlserver.database.file.size:
64
       enabled: true 
65
     sqlserver.database.io:
66
       enabled: true
67
     sqlserver.database.latency:
68
       enabled: true
69
     sqlserver.database.operations:
70
       enabled: true
71
     sqlserver.database.transactions.active:
72
       enabled: true
73
     sqlserver.database.backup_or_restore.rate:
74
       enabled: true
75
     sqlserver.database.execution.errors:
76
       enabled: true
77
     sqlserver.database.full_scan.rate:
78
       enabled: true
79
     sqlserver.database.tempdb.space:
80
       enabled: true
81
     sqlserver.database.tempdb.version_store.size:
82
       enabled: true
83
     # Locks
84
     sqlserver.lock.timeout.rate:
85
       enabled: true
86
     sqlserver.lock.wait.count:
87
       enabled: true
88
     sqlserver.deadlock.rate:
89
       enabled: true
90
     # Transactions
91
     sqlserver.transaction.delay:
92
       enabled: true
93
     sqlserver.transaction.longest_running_time:
94
       enabled: true
95
     sqlserver.transaction.version_cleanup.rate:
96
       enabled: true
97
     sqlserver.transaction.version_generation.rate:
98
       enabled: true
99
     # Memory
100
     sqlserver.memory.area:
101
       enabled: true
102
     sqlserver.memory.cache.object.count:
103
       enabled: true
104
     sqlserver.memory.grants.pending.count:
105
       enabled: true
106
     sqlserver.memory.page.count:
107
       enabled: true
108
     sqlserver.memory.usage:
109
       enabled: true
110
     # OS
111
     sqlserver.os.memory.usage:
112
       enabled: true
113
     sqlserver.os.memory.utilization:
114
       enabled: true
115
     sqlserver.os.scheduler.runnable_tasks.count:
116
       enabled: true
117
     sqlserver.os.wait.duration:
118
       enabled: true
119
     sqlserver.os.wait.tasks.count:
120
       enabled: true
121
     # Pages / Buffer
122
     sqlserver.page.buffer_cache.free_list.stalls.rate:
123
       enabled: true
124
     sqlserver.page.lookup.rate:
125
       enabled: true
126
     # Batch / Compilation
127
     sqlserver.batch.compilation.utilization:
128
       enabled: true
129
     sqlserver.batch.page_split.utilization:
130
       enabled: true
131
     sqlserver.recompilation.ratio:
132
       enabled: true
133
     sqlserver.parameterization.rate:
134
       enabled: true
135
     sqlserver.plan.execution.rate:
136
       enabled: true
137
     sqlserver.attention.rate:
138
       enabled: true
139
     # Processes / Connections
140
     sqlserver.process.count:
141
       enabled: true
142
     sqlserver.processes.blocked:
143
       enabled: true
144
     sqlserver.login.rate:
145
       enabled: true
146
     sqlserver.logout.rate:
147
       enabled: true
148
     # Thread Pool
149
     sqlserver.thread_pool.tasks.count:
150
       enabled: true
151
     sqlserver.thread_pool.workers.count:
152
       enabled: true
153
     sqlserver.thread_pool.workers.max:
154
       enabled: true
155
     sqlserver.thread_pool.workers.utilization:
156
       enabled: true
157
     # TempDB
158
     sqlserver.tempdb.allocation.wait_time.total:
159
       enabled: true
160
     sqlserver.tempdb.contention.waiters.count:
161
       enabled: true
162
     sqlserver.tempdb.data_files.count:
163
       enabled: true
164
     sqlserver.tempdb.file.size:
165
       enabled: true
166
     sqlserver.tempdb.space.usage:
167
       enabled: true
168
     # Latch
169
     sqlserver.latch.superlatch.count:
170
       enabled: true
171
     sqlserver.latch.superlatch.transition.rate:
172
       enabled: true
173
     sqlserver.latch.wait.rate:
174
       enabled: true
175
     sqlserver.latch.wait_time.avg:
176
       enabled: true
177
     sqlserver.latch.wait_time.total:
178
       enabled: true
179
     # Index
180
     sqlserver.index.search.rate:
181
       enabled: true
182
     # Resource Pool
183
     sqlserver.resource_pool.disk.operations:
184
       enabled: true
185
     sqlserver.resource_pool.disk.throttled.read.rate:
186
       enabled: true
187
     sqlserver.resource_pool.disk.throttled.write.rate:
188
       enabled: true
189
     # Replica / Always-On
190
     sqlserver.replica.data.rate:
191
       enabled: true
192
     sqlserver.failover_cluster.ag.cluster_type:
193
       enabled: true
194
     sqlserver.failover_cluster.ag.failure_condition_level:
195
       enabled: true
196
     sqlserver.failover_cluster.ag.health_check_timeout:
197
       enabled: true
198
     sqlserver.failover_cluster.ag.required_sync_secondaries:
199
       enabled: true
200
     sqlserver.failover_cluster.replica.database.queue_size:
201
       enabled: true
202
     sqlserver.failover_cluster.replica.database.redo.rate:
203
       enabled: true
204
     sqlserver.failover_cluster.replica.flow_control_time:
205
       enabled: true
206
     sqlserver.failover_cluster.replica.role:
207
       enabled: true
208
     sqlserver.failover_cluster.replica.synchronization_health:
209
       enabled: true
210
     # Server Properties
211
     sqlserver.computer.uptime:
212
       enabled: true
213
     sqlserver.cpu.count:
214
       enabled: true
215
     # Tables
216
     sqlserver.table.count:
217
       enabled: true
218

219
   # Enable top query and query sample log collection
220
   events:
221
     db.server.query_sample:
222
       enabled: true
223
     db.server.top_query:
224
       enabled: true
225

226
   # Top query collection configuration
227
   top_query_collection:
228
     lookback_time: 45s
229
     max_query_sample_count: 100
230
     top_query_count: 30
231
     collection_interval: 30s
232

233
   collect_full_query_text: true
234
   allowed_comment_keys:
235
     - nr_service_guid
236

237
   # Query sample collection configuration
238
   query_sample_collection:
239
     max_rows_per_query: 50
240

241
processors:
242
metrics_transform:
243
   transforms:
244
     - include: system.cpu.utilization
245
       action: update
246
       operations:
247
         - action: aggregate_labels
248
           label_set: [state]
249
           aggregation_type: mean
250
     - include: system.paging.operations
251
       action: update
252
       operations:
253
         - action: aggregate_labels
254
           label_set: [direction]
255
           aggregation_type: sum
256

257
  filter/exclude_cpu_utilization:
258
   metrics:
259
     datapoint:
260
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
261
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
262
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
263

264
  filter/exclude_memory_utilization:
265
   metrics:
266
     datapoint:
267
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
268
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
269
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
270
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
271
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
272

273
  filter/exclude_memory_usage:
274
   metrics:
275
     datapoint:
276
       - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
277
       - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
278

279
  filter/exclude_filesystem_utilization:
280
   metrics:
281
     datapoint:
282
       - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
283

284
  filter/exclude_filesystem_usage:
285
   metrics:
286
     datapoint:
287
       - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
288
       - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
289

290
  filter/exclude_filesystem_inodes_usage:
291
   metrics:
292
     datapoint:
293
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
294
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
295

296
  filter/exclude_system_disk:
297
   metrics:
298
     datapoint:
299
       - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
300
       - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
301
       - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
302
       - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
303
       - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
304

305
  filter/exclude_network:
306
   metrics:
307
     datapoint:
308
       - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
309

310
  attributes/exclude_system_paging:
311
   include:
312
     match_type: strict
313
     metric_names:
314
       - system.paging.operations
315
   actions:
316
     - key: type
317
       action: delete
318

319
cumulative_to_delta:
320

321
  transform/host:
322
   metric_statements:
323
     - context: metric
324
       statements:
325
         - set(metric.description, "")
326
         - set(metric.unit, "")
327

328
batch:
329

330
  batch/logs:
331
   send_batch_size: 15          # flush target: ~15 records per request
332
   send_batch_max_size: 15      # HARD cap: never emit more than 15 records/request
333
   timeout: 5s
334

335
resource_detection:
336
   detectors: ["system"]
337
   system:
338
     hostname_sources: ["os"]
339
     resource_attributes:
340
       host.id:
341
         enabled: true
342

343
  resource_detection/cloud:
344
   detectors: ["gcp", "ec2", "azure"]
345
   timeout: 2s
346
   override: true
347

348
  resource_detection/env:
349
   detectors: ["env"]
350
   timeout: 2s
351
   override: true
352

353
exporters:
354
otlp:
355
   endpoint: https://otlp.nr-data.net:4318
356
   headers:
357
     api-key: YOUR_LICENSE_KEY
358
   tls:
359
     insecure: false
360
   compression: gzip
361

362
service:
363
telemetry:
364
   metrics:
365
     level: none
366

367
  extensions: [health_check]
368

369
pipelines:
370
   metrics/host:
371
     receivers: [host_metrics, nrsqlserver]
372
     processors:
373
       - metrics_transform
374
       - filter/exclude_cpu_utilization
375
       - filter/exclude_memory_utilization
376
       - filter/exclude_memory_usage
377
       - filter/exclude_filesystem_utilization
378
       - filter/exclude_filesystem_usage
379
       - filter/exclude_filesystem_inodes_usage
380
       - filter/exclude_system_disk
381
       - filter/exclude_network
382
       - attributes/exclude_system_paging
383
       - transform/host
384
       - resource_detection
385
       - resource_detection/cloud
386
       - resource_detection/env
387
       - cumulative_to_delta
388
       - batch
389
     exporters: [otlp]
390

391
   logs/host:
392
     receivers: [nrsqlserver]
393
     processors:
394
       - resource_detection
395
       - resource_detection/cloud
396
       - resource_detection/env
397
       - batch/logs
398
     exporters: [otlp]
399

400
   traces:
401
     receivers: [otlp]
402
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
403
     exporters: [otlp]
404

405
   metrics:
406
     receivers: [otlp]
407
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
408
     exporters: [otlp]
409

410
   logs:
411
     receivers: [otlp]
412
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
413
     exporters: [otlp]

전체 설정을 다운로드하거나 mssql-config.yaml 파일에 붙여넣은 후, Windows 자체 호스팅 가이드를 따라 gMSA 인증 방법을 사용하여 설정을 완료하십시오.

이 설정은 SQL Server 인증을 사용하여 AWS RDS SQL Server 인스턴스에 연결하는 Windows 환경에 대한 데이터베이스 모니터링을 제공합니다.

아래에 값을 입력하고 실시간으로 설정 업데이트를 확인하십시오:

SQL Server 사용자 이름

SQL Server 비밀번호

RDS 엔드포인트

서버 포트

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

mssql-config.yaml

1
extensions:
2
health_check:
3

4
receivers:
5
otlp:
6
   protocols:
7
     grpc:
8
     http:
9

10
host_metrics:
11
   collection_interval: 30s
12
   scrapers:
13
     cpu:
14
       metrics:
15
         system.cpu.time:
16
           enabled: false
17
         system.cpu.utilization:
18
           enabled: true
19
     load:
20
     memory:
21
       metrics:
22
         system.memory.utilization:
23
           enabled: true
24
     paging:
25
       metrics:
26
         system.paging.utilization:
27
           enabled: false
28
         system.paging.faults:
29
           enabled: false
30
     disk:
31
       metrics:
32
         system.disk.merged:
33
           enabled: false
34
         system.disk.pending_operations:
35
           enabled: false
36
         system.disk.weighted_io_time:
37
           enabled: false
38
     network:
39
       metrics:
40
         system.network.connections:
41
           enabled: false
42
     processes:
43
     process:
44
       mute_process_name_error: true
45
       mute_process_exe_error: true
46
       mute_process_user_error: true
47
       mute_process_io_error: true
48
       metrics:
49
         process.cpu.utilization:
50
           enabled: true
51
         process.memory.utilization:
52
           enabled: true
53

54
nrsqlserver:
55
   collection_interval: 30s
56
   username: newrelic
57
   password: YOUR_PASSWORD
58
   server: mydb-instance.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com
59
   port: 1433
60

61
   # Enable comprehensive database metrics
62
   metrics:
63
     # Database
64
     sqlserver.database.count:
65
       enabled: true
66
     sqlserver.database.file.size:
67
       enabled: true 
68
     sqlserver.database.io:
69
       enabled: true
70
     sqlserver.database.latency:
71
       enabled: true
72
     sqlserver.database.operations:
73
       enabled: true
74
     sqlserver.database.transactions.active:
75
       enabled: true
76
     sqlserver.database.backup_or_restore.rate:
77
       enabled: true
78
     sqlserver.database.full_scan.rate:
79
       enabled: true
80
     sqlserver.database.tempdb.space:
81
       enabled: true
82
     sqlserver.database.tempdb.version_store.size:
83
       enabled: true
84
     # Locks
85
     sqlserver.lock.timeout.rate:
86
       enabled: true
87
     sqlserver.lock.wait.count:
88
       enabled: true
89
     sqlserver.deadlock.rate:
90
       enabled: true
91
     # Transactions
92
     sqlserver.transaction.delay:
93
       enabled: true
94
     sqlserver.transaction.longest_running_time:
95
       enabled: true
96
     sqlserver.transaction.version_cleanup.rate:
97
       enabled: true
98
     sqlserver.transaction.version_generation.rate:
99
       enabled: true
100
     # Memory
101
     sqlserver.memory.area:
102
       enabled: true
103
     sqlserver.memory.cache.object.count:
104
       enabled: true
105
     sqlserver.memory.grants.pending.count:
106
       enabled: true
107
     sqlserver.memory.page.count:
108
       enabled: true
109
     sqlserver.memory.usage:
110
       enabled: true
111
     # OS
112
     sqlserver.os.memory.usage:
113
       enabled: true
114
     sqlserver.os.memory.utilization:
115
       enabled: true
116
     sqlserver.os.scheduler.runnable_tasks.count:
117
       enabled: true
118
     sqlserver.os.wait.duration:
119
       enabled: true
120
     sqlserver.os.wait.tasks.count:
121
       enabled: true
122
     # Pages / Buffer
123
     sqlserver.page.buffer_cache.free_list.stalls.rate:
124
       enabled: true
125
     sqlserver.page.lookup.rate:
126
       enabled: true
127
     # Batch / Compilation
128
     sqlserver.batch.compilation.utilization:
129
       enabled: true
130
     sqlserver.batch.page_split.utilization:
131
       enabled: true
132
     sqlserver.recompilation.ratio:
133
       enabled: true
134
     sqlserver.parameterization.rate:
135
       enabled: true
136
     sqlserver.plan.execution.rate:
137
       enabled: true
138
     sqlserver.attention.rate:
139
       enabled: true
140
     # Processes / Connections
141
     sqlserver.process.count:
142
       enabled: true
143
     sqlserver.processes.blocked:
144
       enabled: true
145
     sqlserver.login.rate:
146
       enabled: true
147
     sqlserver.logout.rate:
148
       enabled: true
149
     # Thread Pool
150
     sqlserver.thread_pool.tasks.count:
151
       enabled: true
152
     sqlserver.thread_pool.workers.count:
153
       enabled: true
154
     sqlserver.thread_pool.workers.max:
155
       enabled: true
156
     sqlserver.thread_pool.workers.utilization:
157
       enabled: true
158
     # TempDB
159
     sqlserver.tempdb.allocation.wait_time.total:
160
       enabled: true
161
     sqlserver.tempdb.contention.waiters.count:
162
       enabled: true
163
     sqlserver.tempdb.data_files.count:
164
       enabled: true
165
     sqlserver.tempdb.file.size:
166
       enabled: true
167
     sqlserver.tempdb.space.usage:
168
       enabled: true
169
     # Latch
170
     sqlserver.latch.superlatch.count:
171
       enabled: true
172
     sqlserver.latch.superlatch.transition.rate:
173
       enabled: true
174
     sqlserver.latch.wait.rate:
175
       enabled: true
176
     sqlserver.latch.wait_time.avg:
177
       enabled: true
178
     sqlserver.latch.wait_time.total:
179
       enabled: true
180
     # Index
181
     sqlserver.index.search.rate:
182
       enabled: true
183
     # Resource Pool
184
     sqlserver.resource_pool.disk.operations:
185
       enabled: true
186
     sqlserver.resource_pool.disk.throttled.read.rate:
187
       enabled: true
188
     sqlserver.resource_pool.disk.throttled.write.rate:
189
       enabled: true
190
     # Replica / Always-On
191
     sqlserver.replica.data.rate:
192
       enabled: true
193
     sqlserver.failover_cluster.ag.cluster_type:
194
       enabled: true
195
     sqlserver.failover_cluster.ag.failure_condition_level:
196
       enabled: true
197
     sqlserver.failover_cluster.ag.health_check_timeout:
198
       enabled: true
199
     sqlserver.failover_cluster.ag.required_sync_secondaries:
200
       enabled: true
201
     sqlserver.failover_cluster.replica.database.queue_size:
202
       enabled: true
203
     sqlserver.failover_cluster.replica.database.redo.rate:
204
       enabled: true
205
     sqlserver.failover_cluster.replica.flow_control_time:
206
       enabled: true
207
     sqlserver.failover_cluster.replica.role:
208
       enabled: true
209
     sqlserver.failover_cluster.replica.synchronization_health:
210
       enabled: true
211
   # Server Properties
212
     sqlserver.computer.uptime:
213
       enabled: true
214
     sqlserver.cpu.count:
215
       enabled: true
216
     # Tables
217
     sqlserver.table.count:
218
       enabled: true
219
   # Enable top query and query sample log collection
220
   events:
221
     db.server.query_sample:
222
       enabled: true
223
     db.server.top_query:
224
       enabled: true
225
   # Top query collection configuration
226
   top_query_collection:
227
     lookback_time: 45s
228
     max_query_sample_count: 100
229
     top_query_count: 30
230
     collection_interval: 30s
231
   collect_full_query_text: true
232
   allowed_comment_keys:
233
     - nr_service_guid
234
   # Query sample collection configuration
235
   query_sample_collection:
236
     max_rows_per_query: 50
237
processors:
238
metrics_transform:
239
   transforms:
240
     - include: system.cpu.utilization
241
       action: update
242
       operations:
243
         - action: aggregate_labels
244
           label_set: [state]
245
           aggregation_type: mean
246
     - include: system.paging.operations
247
       action: update
248
       operations:
249
         - action: aggregate_labels
250
           label_set: [direction]
251
           aggregation_type: sum
252
  filter/exclude_cpu_utilization:
253
   metrics:
254
     datapoint:
255
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
256
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
257
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
258
  filter/exclude_memory_utilization:
259
   metrics:
260
     datapoint:
261
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
262
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
263
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
264
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
265
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
266
  filter/exclude_memory_usage:
267
   metrics:
268
     datapoint:
269
       - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
270
       - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
271
  filter/exclude_filesystem_utilization:
272
   metrics:
273
     datapoint:
274
       - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
275
  filter/exclude_filesystem_usage:
276
   metrics:
277
     datapoint:
278
       - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
279
       - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
280
  filter/exclude_filesystem_inodes_usage:
281
   metrics:
282
     datapoint:
283
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
284
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
285
  filter/exclude_system_disk:
286
   metrics:
287
     datapoint:
288
       - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
289
       - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
290
       - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
291
       - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
292
       - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
293
  filter/exclude_network:
294
   metrics:
295
     datapoint:
296
       - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
297
  attributes/exclude_system_paging:
298
   include:
299
     match_type: strict
300
     metric_names:
301
       - system.paging.operations
302
   actions:
303
     - key: type
304
       action: delete
305
cumulative_to_delta:
306
  transform/host:
307
   metric_statements:
308
     - context: metric
309
       statements:
310
         - set(metric.description, "")
311
         - set(metric.unit, "")
312
batch:
313

314
  batch/logs:
315
   send_batch_size: 15          # flush target: ~15 records per request
316
   send_batch_max_size: 15      # HARD cap: never emit more than 15 records/request
317
   timeout: 5s
318

319
resource_detection:
320
   detectors: ["system"]
321
   system:
322
     hostname_sources: ["os"]
323
     resource_attributes:
324
       host.id:
325
         enabled: true
326
  resource_detection/cloud:
327
   detectors: ["gcp", "ec2", "azure"]
328
   timeout: 2s
329
   override: true
330
  resource_detection/env:
331
   detectors: ["env"]
332
   timeout: 2s
333
   override: true
334
exporters:
335
otlp:
336
   endpoint: https://otlp.nr-data.net:4318
337
   headers:
338
     api-key: YOUR_LICENSE_KEY
339
   tls:
340
     insecure: false
341
   compression: gzip
342
service:
343
telemetry:
344
   metrics:
345
     level: none
346
  extensions: [health_check]
347
pipelines:
348
   metrics/host:
349
     receivers: [host_metrics, nrsqlserver]
350
     processors:
351
       - metrics_transform
352
       - filter/exclude_cpu_utilization
353
       - filter/exclude_memory_utilization
354
       - filter/exclude_memory_usage
355
       - filter/exclude_filesystem_utilization
356
       - filter/exclude_filesystem_usage
357
       - filter/exclude_filesystem_inodes_usage
358
       - filter/exclude_system_disk
359
       - filter/exclude_network
360
       - attributes/exclude_system_paging
361
       - transform/host
362
       - resource_detection
363
       - resource_detection/cloud
364
       - resource_detection/env
365
       - cumulative_to_delta
366
       - batch
367
     exporters: [otlp]
368
   logs/host:
369
     receivers: [nrsqlserver]
370
     processors:
371
       - resource_detection
372
       - resource_detection/cloud
373
       - resource_detection/env
374
       - batch/logs
375
     exporters: [otlp]
376
   traces:
377
     receivers: [otlp]
378
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
379
     exporters: [otlp]
380
   metrics:
381
     receivers: [otlp]
382
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
383
     exporters: [otlp]
384
   logs:
385
     receivers: [otlp]
386
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
387
     exporters: [otlp]

전체 설정을 다운로드하거나 mssql-config.yaml 파일에 붙여넣은 후, Windows RDS 가이드를 따라 SQL Server 인증 방법을 사용하여 설정을 완료하십시오.

이 설정은 Windows 도메인 인증(통합 보안)을 사용하여 AWS RDS SQL Server 인스턴스에 연결하는 Windows 환경에 대한 포괄적인 데이터베이스 모니터링을 제공합니다.

아래에 값을 입력하고 실시간으로 설정 업데이트를 확인하십시오:

RDS 엔드포인트

RDS 포트

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

mssql-config.yaml

1
extensions:
2
health_check:
3

4
receivers:
5
otlp:
6
   protocols:
7
     grpc:
8
     http:
9

10
host_metrics:
11
   collection_interval: 30s
12
   scrapers:
13
     cpu:
14
       metrics:
15
         system.cpu.time:
16
           enabled: false
17
         system.cpu.utilization:
18
           enabled: true
19
     load:
20
     memory:
21
       metrics:
22
         system.memory.utilization:
23
           enabled: true
24
     paging:
25
       metrics:
26
         system.paging.utilization:
27
           enabled: false
28
         system.paging.faults:
29
           enabled: false
30
     disk:
31
       metrics:
32
         system.disk.merged:
33
           enabled: false
34
         system.disk.pending_operations:
35
           enabled: false
36
         system.disk.weighted_io_time:
37
           enabled: false
38
     network:
39
       metrics:
40
         system.network.connections:
41
           enabled: false
42
     processes:
43
     process:
44
       mute_process_name_error: true
45
       mute_process_exe_error: true
46
       mute_process_user_error: true
47
       mute_process_io_error: true
48
       metrics:
49
         process.cpu.utilization:
50
           enabled: true
51
         process.memory.utilization:
52
           enabled: true
53

54
nrsqlserver:
55
   collection_interval: 30s
56
   datasource: "server=mydb-instance.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com;port=1433;integrated security=true;encrypt=true;TrustServerCertificate=true;"
57

58
   # Enable comprehensive database metrics
59
   metrics:
60
     # Database
61
     sqlserver.database.count:
62
       enabled: true
63
     sqlserver.database.file.size:
64
       enabled: true 
65
     sqlserver.database.io:
66
       enabled: true
67
     sqlserver.database.latency:
68
       enabled: true
69
     sqlserver.database.operations:
70
       enabled: true
71
     sqlserver.database.transactions.active:
72
       enabled: true
73
     sqlserver.database.backup_or_restore.rate:
74
       enabled: true
75
     sqlserver.database.full_scan.rate:
76
       enabled: true
77
     sqlserver.database.tempdb.space:
78
       enabled: true
79
     sqlserver.database.tempdb.version_store.size:
80
       enabled: true
81
     # Locks
82
     sqlserver.lock.timeout.rate:
83
       enabled: true
84
     sqlserver.lock.wait.count:
85
       enabled: true
86
     sqlserver.deadlock.rate:
87
       enabled: true
88
     # Transactions
89
     sqlserver.transaction.delay:
90
       enabled: true
91
     sqlserver.transaction.longest_running_time:
92
       enabled: true
93
     sqlserver.transaction.version_cleanup.rate:
94
       enabled: true
95
     sqlserver.transaction.version_generation.rate:
96
       enabled: true
97
     # Memory
98
     sqlserver.memory.area:
99
       enabled: true
100
     sqlserver.memory.cache.object.count:
101
       enabled: true
102
     sqlserver.memory.grants.pending.count:
103
       enabled: true
104
     sqlserver.memory.page.count:
105
       enabled: true
106
     sqlserver.memory.usage:
107
       enabled: true
108
     # OS
109
     sqlserver.os.memory.usage:
110
       enabled: true
111
     sqlserver.os.memory.utilization:
112
       enabled: true
113
     sqlserver.os.scheduler.runnable_tasks.count:
114
       enabled: true
115
     sqlserver.os.wait.duration:
116
       enabled: true
117
     sqlserver.os.wait.tasks.count:
118
       enabled: true
119
     # Pages / Buffer
120
     sqlserver.page.buffer_cache.free_list.stalls.rate:
121
       enabled: true
122
     sqlserver.page.lookup.rate:
123
       enabled: true
124
     # Batch / Compilation
125
     sqlserver.batch.compilation.utilization:
126
       enabled: true
127
     sqlserver.batch.page_split.utilization:
128
       enabled: true
129
     sqlserver.recompilation.ratio:
130
       enabled: true
131
     sqlserver.parameterization.rate:
132
       enabled: true
133
     sqlserver.plan.execution.rate:
134
       enabled: true
135
     sqlserver.attention.rate:
136
       enabled: true
137
     # Processes / Connections
138
     sqlserver.process.count:
139
       enabled: true
140
     sqlserver.processes.blocked:
141
       enabled: true
142
     sqlserver.login.rate:
143
       enabled: true
144
     sqlserver.logout.rate:
145
       enabled: true
146
     # Thread Pool
147
     sqlserver.thread_pool.tasks.count:
148
       enabled: true
149
     sqlserver.thread_pool.workers.count:
150
       enabled: true
151
     sqlserver.thread_pool.workers.max:
152
       enabled: true
153
     sqlserver.thread_pool.workers.utilization:
154
       enabled: true
155
     # TempDB
156
     sqlserver.tempdb.allocation.wait_time.total:
157
       enabled: true
158
     sqlserver.tempdb.contention.waiters.count:
159
       enabled: true
160
     sqlserver.tempdb.data_files.count:
161
       enabled: true
162
     sqlserver.tempdb.file.size:
163
       enabled: true
164
     sqlserver.tempdb.space.usage:
165
       enabled: true
166
     # Latch
167
     sqlserver.latch.superlatch.count:
168
       enabled: true
169
     sqlserver.latch.superlatch.transition.rate:
170
       enabled: true
171
     sqlserver.latch.wait.rate:
172
       enabled: true
173
     sqlserver.latch.wait_time.avg:
174
       enabled: true
175
     sqlserver.latch.wait_time.total:
176
       enabled: true
177
     # Index
178
     sqlserver.index.search.rate:
179
       enabled: true
180
     # Resource Pool
181
     sqlserver.resource_pool.disk.operations:
182
       enabled: true
183
     sqlserver.resource_pool.disk.throttled.read.rate:
184
       enabled: true
185
     sqlserver.resource_pool.disk.throttled.write.rate:
186
       enabled: true
187
     # Replica / Always-On
188
     sqlserver.replica.data.rate:
189
       enabled: true
190
     sqlserver.failover_cluster.ag.cluster_type:
191
       enabled: true
192
     sqlserver.failover_cluster.ag.failure_condition_level:
193
       enabled: true
194
     sqlserver.failover_cluster.ag.health_check_timeout:
195
       enabled: true
196
     sqlserver.failover_cluster.ag.required_sync_secondaries:
197
       enabled: true
198
     sqlserver.failover_cluster.replica.database.queue_size:
199
       enabled: true
200
     sqlserver.failover_cluster.replica.database.redo.rate:
201
       enabled: true
202
     sqlserver.failover_cluster.replica.flow_control_time:
203
       enabled: true
204
     sqlserver.failover_cluster.replica.role:
205
       enabled: true
206
     sqlserver.failover_cluster.replica.synchronization_health:
207
       enabled: true
208
     # Server Properties
209
     sqlserver.computer.uptime:
210
       enabled: true
211
     sqlserver.cpu.count:
212
       enabled: true
213
     # Tables
214
     sqlserver.table.count:
215
       enabled: true
216
   # Enable top query and query sample log collection
217
   events:
218
     db.server.query_sample:
219
       enabled: true
220
     db.server.top_query:
221
       enabled: true
222
   # Top query collection configuration
223
   top_query_collection:
224
     lookback_time: 45s
225
     max_query_sample_count: 100
226
     top_query_count: 30
227
     collection_interval: 30s
228
   collect_full_query_text: true
229
   allowed_comment_keys:
230
     - nr_service_guid
231
   # Query sample collection configuration
232
   query_sample_collection:
233
     max_rows_per_query: 50
234
processors:
235
metrics_transform:
236
   transforms:
237
     - include: system.cpu.utilization
238
       action: update
239
       operations:
240
         - action: aggregate_labels
241
           label_set: [state]
242
           aggregation_type: mean
243
     - include: system.paging.operations
244
       action: update
245
       operations:
246
         - action: aggregate_labels
247
           label_set: [direction]
248
           aggregation_type: sum
249
  filter/exclude_cpu_utilization:
250
   metrics:
251
     datapoint:
252
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
253
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
254
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
255
  filter/exclude_memory_utilization:
256
   metrics:
257
     datapoint:
258
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
259
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
260
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
261
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
262
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
263
  filter/exclude_memory_usage:
264
   metrics:
265
     datapoint:
266
       - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
267
       - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
268
  filter/exclude_filesystem_utilization:
269
   metrics:
270
     datapoint:
271
       - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
272
  filter/exclude_filesystem_usage:
273
   metrics:
274
     datapoint:
275
       - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
276
       - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
277
  filter/exclude_filesystem_inodes_usage:
278
   metrics:
279
     datapoint:
280
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
281
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
282
  filter/exclude_system_disk:
283
   metrics:
284
     datapoint:
285
       - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
286
       - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
287
       - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
288
       - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
289
       - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
290
  filter/exclude_network:
291
   metrics:
292
     datapoint:
293
       - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
294
  attributes/exclude_system_paging:
295
   include:
296
     match_type: strict
297
     metric_names:
298
       - system.paging.operations
299
   actions:
300
     - key: type
301
       action: delete
302
cumulative_to_delta:
303
  transform/host:
304
   metric_statements:
305
     - context: metric
306
       statements:
307
         - set(metric.description, "")
308
         - set(metric.unit, "")
309
batch:
310

311
  batch/logs:
312
   send_batch_size: 15          # flush target: ~15 records per request
313
   send_batch_max_size: 15      # HARD cap: never emit more than 15 records/request
314
   timeout: 5s
315

316
resource_detection:
317
   detectors: ["system"]
318
   system:
319
     hostname_sources: ["os"]
320
     resource_attributes:
321
       host.id:
322
         enabled: true
323
  resource_detection/cloud:
324
   detectors: ["gcp", "ec2", "azure"]
325
   timeout: 2s
326
   override: true
327
  resource_detection/env:
328
   detectors: ["env"]
329
   timeout: 2s
330
   override: true
331
exporters:
332
otlp:
333
   endpoint: https://otlp.nr-data.net:4318
334
   headers:
335
     api-key: YOUR_LICENSE_KEY
336
   tls:
337
     insecure: false
338
   compression: gzip
339
service:
340
telemetry:
341
   metrics:
342
     level: none
343
  extensions: [health_check]
344
pipelines:
345
   metrics/host:
346
     receivers: [host_metrics, nrsqlserver]
347
     processors:
348
       - metrics_transform
349
       - filter/exclude_cpu_utilization
350
       - filter/exclude_memory_utilization
351
       - filter/exclude_memory_usage
352
       - filter/exclude_filesystem_utilization
353
       - filter/exclude_filesystem_usage
354
       - filter/exclude_filesystem_inodes_usage
355
       - filter/exclude_system_disk
356
       - filter/exclude_network
357
       - attributes/exclude_system_paging
358
       - transform/host
359
       - resource_detection
360
       - resource_detection/cloud
361
       - resource_detection/env
362
       - cumulative_to_delta
363
       - batch
364
     exporters: [otlp]
365
   logs/host:
366
     receivers: [nrsqlserver]
367
     processors:
368
       - resource_detection
369
       - resource_detection/cloud
370
       - resource_detection/env
371
       - batch/logs
372
     exporters: [otlp]
373
   traces:
374
     receivers: [otlp]
375
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
376
     exporters: [otlp]
377
   metrics:
378
     receivers: [otlp]
379
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
380
     exporters: [otlp]
381
   logs:
382
     receivers: [otlp]
383
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
384
     exporters: [otlp]

전체 설정을 다운로드하거나 mssql-config.yaml 파일에 붙여넣은 후, Windows RDS 가이드를 따라 Windows 인증 방법을 사용하여 설정을 완료하십시오.

이 설정은 통합 보안과 함께 그룹 관리 서비스 계정(gMSA) 인증을 사용하여 AWS RDS SQL Server 인스턴스에 연결하는 Windows 환경에 대한 포괄적인 데이터베이스 모니터링을 제공합니다.

아래에 값을 입력하고 실시간으로 설정 업데이트를 확인하십시오:

RDS 엔드포인트

RDS 포트

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

mssql-config.yaml

1
extensions:
2
health_check:
3

4
receivers:
5
otlp:
6
   protocols:
7
     grpc:
8
     http:
9

10
host_metrics:
11
   collection_interval: 30s
12
   scrapers:
13
     cpu:
14
       metrics:
15
         system.cpu.time:
16
           enabled: false
17
         system.cpu.utilization:
18
           enabled: true
19
     load:
20
     memory:
21
       metrics:
22
         system.memory.utilization:
23
           enabled: true
24
     paging:
25
       metrics:
26
         system.paging.utilization:
27
           enabled: false
28
         system.paging.faults:
29
           enabled: false
30
     disk:
31
       metrics:
32
         system.disk.merged:
33
           enabled: false
34
         system.disk.pending_operations:
35
           enabled: false
36
         system.disk.weighted_io_time:
37
           enabled: false
38
     network:
39
       metrics:
40
         system.network.connections:
41
           enabled: false
42
     processes:
43
     process:
44
       mute_process_name_error: true
45
       mute_process_exe_error: true
46
       mute_process_user_error: true
47
       mute_process_io_error: true
48
       metrics:
49
         process.cpu.utilization:
50
           enabled: true
51
         process.memory.utilization:
52
           enabled: true
53

54
nrsqlserver:
55
   collection_interval: 30s
56
   datasource: "server=mydb-instance.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com;port=1433;integrated security=true;encrypt=true;TrustServerCertificate=true;"
57

58
   # Enable comprehensive database metrics
59
   metrics:
60
     # Database
61
     sqlserver.database.count:
62
       enabled: true
63
     sqlserver.database.file.size:
64
       enabled: true 
65
     sqlserver.database.io:
66
       enabled: true
67
     sqlserver.database.latency:
68
       enabled: true
69
     sqlserver.database.operations:
70
       enabled: true
71
     sqlserver.database.transactions.active:
72
       enabled: true
73
     sqlserver.database.backup_or_restore.rate:
74
       enabled: true
75
     sqlserver.database.full_scan.rate:
76
       enabled: true
77
     sqlserver.database.tempdb.space:
78
       enabled: true
79
     sqlserver.database.tempdb.version_store.size:
80
       enabled: true
81
     # Locks
82
     sqlserver.lock.timeout.rate:
83
       enabled: true
84
     sqlserver.lock.wait.count:
85
       enabled: true
86
     sqlserver.deadlock.rate:
87
       enabled: true
88
     # Transactions
89
     sqlserver.transaction.delay:
90
       enabled: true
91
     sqlserver.transaction.longest_running_time:
92
       enabled: true
93
     sqlserver.transaction.version_cleanup.rate:
94
       enabled: true
95
     sqlserver.transaction.version_generation.rate:
96
       enabled: true
97
     # Memory
98
     sqlserver.memory.area:
99
       enabled: true
100
     sqlserver.memory.cache.object.count:
101
       enabled: true
102
     sqlserver.memory.grants.pending.count:
103
       enabled: true
104
     sqlserver.memory.page.count:
105
       enabled: true
106
     sqlserver.memory.usage:
107
       enabled: true
108
     # OS
109
     sqlserver.os.memory.usage:
110
       enabled: true
111
     sqlserver.os.memory.utilization:
112
       enabled: true
113
     sqlserver.os.scheduler.runnable_tasks.count:
114
       enabled: true
115
     sqlserver.os.wait.duration:
116
       enabled: true
117
     sqlserver.os.wait.tasks.count:
118
       enabled: true
119
     # Pages / Buffer
120
     sqlserver.page.buffer_cache.free_list.stalls.rate:
121
       enabled: true
122
     sqlserver.page.lookup.rate:
123
       enabled: true
124
     # Batch / Compilation
125
     sqlserver.batch.compilation.utilization:
126
       enabled: true
127
     sqlserver.batch.page_split.utilization:
128
       enabled: true
129
     sqlserver.recompilation.ratio:
130
       enabled: true
131
     sqlserver.parameterization.rate:
132
       enabled: true
133
     sqlserver.plan.execution.rate:
134
       enabled: true
135
     sqlserver.attention.rate:
136
       enabled: true
137
     # Processes / Connections
138
     sqlserver.process.count:
139
       enabled: true
140
     sqlserver.processes.blocked:
141
       enabled: true
142
     sqlserver.login.rate:
143
       enabled: true
144
     sqlserver.logout.rate:
145
       enabled: true
146
     # Thread Pool
147
     sqlserver.thread_pool.tasks.count:
148
       enabled: true
149
     sqlserver.thread_pool.workers.count:
150
       enabled: true
151
     sqlserver.thread_pool.workers.max:
152
       enabled: true
153
     sqlserver.thread_pool.workers.utilization:
154
       enabled: true
155
     # TempDB
156
     sqlserver.tempdb.allocation.wait_time.total:
157
       enabled: true
158
     sqlserver.tempdb.contention.waiters.count:
159
       enabled: true
160
     sqlserver.tempdb.data_files.count:
161
       enabled: true
162
     sqlserver.tempdb.file.size:
163
       enabled: true
164
     sqlserver.tempdb.space.usage:
165
       enabled: true
166
     # Latch
167
     sqlserver.latch.superlatch.count:
168
       enabled: true
169
     sqlserver.latch.superlatch.transition.rate:
170
       enabled: true
171
     sqlserver.latch.wait.rate:
172
       enabled: true
173
     sqlserver.latch.wait_time.avg:
174
       enabled: true
175
     sqlserver.latch.wait_time.total:
176
       enabled: true
177
     # Index
178
     sqlserver.index.search.rate:
179
       enabled: true
180
     # Resource Pool
181
     sqlserver.resource_pool.disk.operations:
182
       enabled: true
183
     sqlserver.resource_pool.disk.throttled.read.rate:
184
       enabled: true
185
     sqlserver.resource_pool.disk.throttled.write.rate:
186
       enabled: true
187
     # Replica / Always-On
188
     sqlserver.replica.data.rate:
189
       enabled: true
190
     sqlserver.failover_cluster.ag.cluster_type:
191
       enabled: true
192
     sqlserver.failover_cluster.ag.failure_condition_level:
193
       enabled: true
194
     sqlserver.failover_cluster.ag.health_check_timeout:
195
       enabled: true
196
     sqlserver.failover_cluster.ag.required_sync_secondaries:
197
       enabled: true
198
     sqlserver.failover_cluster.replica.database.queue_size:
199
       enabled: true
200
     sqlserver.failover_cluster.replica.database.redo.rate:
201
       enabled: true
202
     sqlserver.failover_cluster.replica.flow_control_time:
203
       enabled: true
204
     sqlserver.failover_cluster.replica.role:
205
       enabled: true
206
     sqlserver.failover_cluster.replica.synchronization_health:
207
       enabled: true
208
     # Server Properties
209
     sqlserver.computer.uptime:
210
       enabled: true
211
     sqlserver.cpu.count:
212
       enabled: true
213
     # Tables
214
     sqlserver.table.count:
215
       enabled: true
216
   # Enable top query and query sample log collection
217
   events:
218
     db.server.query_sample:
219
       enabled: true
220
     db.server.top_query:
221
       enabled: true
222
   # Top query collection configuration
223
   top_query_collection:
224
     lookback_time: 45s
225
     max_query_sample_count: 100
226
     top_query_count: 30
227
     collection_interval: 30s
228
   collect_full_query_text: true
229
   allowed_comment_keys:
230
     - nr_service_guid
231
   # Query sample collection configuration
232
   query_sample_collection:
233
     max_rows_per_query: 50
234
processors:
235
metrics_transform:
236
   transforms:
237
     - include: system.cpu.utilization
238
       action: update
239
       operations:
240
         - action: aggregate_labels
241
           label_set: [state]
242
           aggregation_type: mean
243
     - include: system.paging.operations
244
       action: update
245
       operations:
246
         - action: aggregate_labels
247
           label_set: [direction]
248
           aggregation_type: sum
249
  filter/exclude_cpu_utilization:
250
   metrics:
251
     datapoint:
252
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
253
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
254
       - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
255
  filter/exclude_memory_utilization:
256
   metrics:
257
     datapoint:
258
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
259
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
260
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
261
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
262
       - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
263
  filter/exclude_memory_usage:
264
   metrics:
265
     datapoint:
266
       - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
267
       - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
268
  filter/exclude_filesystem_utilization:
269
   metrics:
270
     datapoint:
271
       - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
272
  filter/exclude_filesystem_usage:
273
   metrics:
274
     datapoint:
275
       - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
276
       - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
277
  filter/exclude_filesystem_inodes_usage:
278
   metrics:
279
     datapoint:
280
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
281
       - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
282
  filter/exclude_system_disk:
283
   metrics:
284
     datapoint:
285
       - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
286
       - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
287
       - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
288
       - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
289
       - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
290
  filter/exclude_network:
291
   metrics:
292
     datapoint:
293
       - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
294
  attributes/exclude_system_paging:
295
   include:
296
     match_type: strict
297
     metric_names:
298
       - system.paging.operations
299
   actions:
300
     - key: type
301
       action: delete
302
cumulative_to_delta:
303
  transform/host:
304
   metric_statements:
305
     - context: metric
306
       statements:
307
         - set(metric.description, "")
308
         - set(metric.unit, "")
309
batch:
310

311
  batch/logs:
312
   send_batch_size: 15          # flush target: ~15 records per request
313
   send_batch_max_size: 15      # HARD cap: never emit more than 15 records/request
314
   timeout: 5s
315

316
resource_detection:
317
   detectors: ["system"]
318
   system:
319
     hostname_sources: ["os"]
320
     resource_attributes:
321
       host.id:
322
         enabled: true
323
  resource_detection/cloud:
324
   detectors: ["gcp", "ec2", "azure"]
325
   timeout: 2s
326
   override: true
327
  resource_detection/env:
328
   detectors: ["env"]
329
   timeout: 2s
330
   override: true
331
exporters:
332
otlp:
333
   endpoint: https://otlp.nr-data.net:4318
334
   headers:
335
     api-key: YOUR_LICENSE_KEY
336
   tls:
337
     insecure: false
338
   compression: gzip
339
service:
340
telemetry:
341
   metrics:
342
     level: none
343
  extensions: [health_check]
344
pipelines:
345
   metrics/host:
346
     receivers: [host_metrics, nrsqlserver]
347
     processors:
348
       - metrics_transform
349
       - filter/exclude_cpu_utilization
350
       - filter/exclude_memory_utilization
351
       - filter/exclude_memory_usage
352
       - filter/exclude_filesystem_utilization
353
       - filter/exclude_filesystem_usage
354
       - filter/exclude_filesystem_inodes_usage
355
       - filter/exclude_system_disk
356
       - filter/exclude_network
357
       - attributes/exclude_system_paging
358
       - transform/host
359
       - resource_detection
360
       - resource_detection/cloud
361
       - resource_detection/env
362
       - cumulative_to_delta
363
       - batch
364
     exporters: [otlp]
365
   logs/host:
366
     receivers: [nrsqlserver]
367
     processors:
368
       - resource_detection
369
       - resource_detection/cloud
370
       - resource_detection/env
371
       - batch/logs
372
     exporters: [otlp]
373
   traces:
374
     receivers: [otlp]
375
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
376
     exporters: [otlp]
377
   metrics:
378
     receivers: [otlp]
379
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
380
     exporters: [otlp]
381
   logs:
382
     receivers: [otlp]
383
     processors: [resource_detection, resource_detection/cloud, resource_detection/env, batch]
384
     exporters: [otlp]

전체 설정을 다운로드하거나 mssql-config.yaml 파일에 붙여넣은 후, Windows RDS 가이드를 따라 gMSA 인증 방법을 사용하여 설정을 완료하십시오.

수신기 설정

max_concurrent_queries을(를) 사용하여 각 스크랩 주기 동안 수신기가 SQL Server에 대해 병렬로 실행하는 메트릭 쿼리 수를 제어할 수 있습니다. 생략하거나 0으로 설정하면 기본값은 4입니다.

receivers:
    nrsqlserver:
        max_concurrent_queries: 4  # default is 4 if omitted or set to 0

사용자의 편의를 위해 제공되는 기계 번역입니다.

NRDOT를 사용한 Microsoft SQL Server 모니터링 설정 참조

중요

리눅스용

Linux 자체 호스팅의 경우

Linux RDS의 경우

Windows용

Windows 자체 호스팅용 - SQL Server 인증

Windows 자체 호스팅의 경우 - Windows 도메인 인증

Windows 자체 호스팅 - gMSA 인증

Windows RDS - SQL Server 인증

Windows RDS용 - Windows 도메인 인증

Windows RDS의 경우 - gMSA 인증

수신기 설정

사용자의 편의를 위해 제공되는 기계 번역입니다.

NRDOT를 사용한 Microsoft SQL Server 모니터링 설정 참조

중요

리눅스용 .css-21sua1{background:none;border:none;width:0;padding:0;}

Linux RDS의 경우

Windows용

Windows 자체 호스팅용 - SQL Server 인증

Windows 자체 호스팅의 경우 - Windows 도메인 인증

Windows 자체 호스팅 - gMSA 인증

Windows RDS - SQL Server 인증

Windows RDS용 - Windows 도메인 인증

Windows RDS의 경우 - gMSA 인증

수신기 설정

리눅스용