| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
 [12.1.279 Pro] - Performance Dashboard |
 |
Is there a way to see what queries the Performance Dashboard runs for the different Key Metrics? For some unknown reason, the diagram for Transactions/sec stops refreshing. I have to restart the dashboard and then it works for a few minutes (seconds?). Unfortunately, that's a rinse-and-repeat kind of process.
|
|
| Fri Nov 25, 2022 9:36 am |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I assume you are asking about SQL Server dashboard. That chart is based on polling values in dm_os_performance_counters, base query is
 |
|
SELECT ROW_NUMBER() OVER(ORDER BY (cntr_value) DESC) AS rank,
instance_name AS database_name,
cntr_value
FROM sys.dm_os_performance_counters
WHERE object_name = 'SQLServer:Databases'
AND counter_name = 'Transactions/sec'
AND instance_name != '_Total'
AND cntr_value != 0 |
It fetches 'Transactions/sec' performance counter and shows changes between its latest and previous values
|
|
| Wed Nov 30, 2022 3:51 pm |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
But why does it stop refreshing? And why don't the others?
|
|
| Wed Nov 30, 2022 4:24 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I'm not sure. Maybe data caching somewhere.
I'm going to try tracing events to see what's coming back.
|
|
| Wed Nov 30, 2022 8:32 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
This issue has been confirmed as a bug. We are going to fix it soon.
|
|
| Fri Dec 02, 2022 3:56 pm |
|
|
|
