Skip to content

Commit 57ecd1d

Browse files
m82labsm82labs
authored
Worktable workfile stats (#8587)
1 parent a1dae0d commit 57ecd1d

2 files changed

Lines changed: 6 additions & 2 deletions

File tree

‎plugins/inputs/sqlserver/azuresqlqueries.go‎

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -527,8 +527,8 @@ WITH PerfCounters AS (
527527
,'Mirrored Write Transactions/sec'
528528
,'Group Commit Time'
529529
,'Group Commits/Sec'
530-
,'Distributed Query'
531-
,'DTC calls'
530+
,'Workfiles Created/sec'
531+
,'Worktables Created/sec'
532532
,'Query Store CPU usage'
533533
) OR (
534534
spi.[object_name] LIKE '%User Settable%'
@@ -1068,6 +1068,8 @@ WITH PerfCounters AS (
10681068
,'Mirrored Write Transactions/sec'
10691069
,'Group Commit Time'
10701070
,'Group Commits/Sec'
1071+
,'Workfiles Created/sec'
1072+
,'Worktables Created/sec'
10711073
,'Distributed Query'
10721074
,'DTC calls'
10731075
,'Query Store CPU usage'

‎plugins/inputs/sqlserver/sqlserverqueries.go‎

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -409,6 +409,8 @@ SELECT DISTINCT
409409
,'Mirrored Write Transactions/sec'
410410
,'Group Commit Time'
411411
,'Group Commits/Sec'
412+
,'Workfiles Created/sec'
413+
,'Worktables Created/sec'
412414
,'Distributed Query'
413415
,'DTC calls'
414416
,'Query Store CPU usage'

0 commit comments

Comments
 (0)