SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[12.1.279 Pro] - Performance Dashboard

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[12.1.279 Pro] - Performance Dashboard
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2069

Post [12.1.279 Pro] - Performance Dashboard Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7724

Post Reply with quote
I assume you are asking about SQL Server dashboard. That chart is based on polling values in dm_os_performance_counters, base query is


Code:
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2069

Post Reply with quote
But why does it stop refreshing? And why don't the others?
Wed Nov 30, 2022 4:24 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7724

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7724

Post Reply with quote
This issue has been confirmed as a bug. We are going to fix it soon.
Fri Dec 02, 2022 3:56 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.