 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2137
|
|
 [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: 7904
|
|
| |
|
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: 2137
|
|
| |
|
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: 7904
|
|
| |
|
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: 7904
|
|
| |
|
This issue has been confirmed as a bug. We are going to fix it soon.
|
|
| Fri Dec 02, 2022 3:56 pm |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
