Go to repository Dashboard, Expand the "Performance - Average Values Over Time"
The values for above mentioned columns will not be there
Expected behavior
The columns must have values
Screenshots
Windows Server (please complete the following information):
OS Version: Windows 2016 R2
SQL Server (please complete the following information):
SQL Version: [e.g. SQL Server 2016 SP1]
SQL Edition: [e.g. Enterprise]
SQL Server Management Studio (SSMS -> about -> copy info):
Microsoft SQL Server Management Studio 13.0.16106.4
Microsoft Analysis Services Client Tools 13.0.1700.441
Microsoft Data Access Components (MDAC) 10.0.17763.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.17763.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.17763
SQLWATCH version (from DACPAC or from sysinstances)
4.2.0.28234
Additional context
The table gets data from the below query
SELECT --repository_dashboard_table
'Batch Requests/sec' = avg(case when counter_name = 'Batch Requests/sec' then [cntr_value_calculated] else null end)
,'Readahead pages/sec' = avg(case when counter_name = 'Readahead pages/sec' then [cntr_value_calculated] else null end)
,'Transactions/sec' = max(case when counter_name = 'Transactions/sec' then [cntr_value_calculated] else null end)
,'Processes blocked' = avg(case when counter_name = 'Processes blocked' then [cntr_value_calculated] else null end)
,'User Connections' = avg(case when counter_name = 'User Connections' then [cntr_value_calculated] else null end)
,'Logins/sec' = avg(case when counter_name = 'Logins/sec' then cntr_value_calculated else null end)
,pc.sql_instance
FROM [dbo].[vw_sqlwatch_report_fact_perf_os_performance_counters] pc
WHERE
[aggregation_interval_minutes] = 1
AND $__timeFilter(snapshot_time)
AND counter_name IN ('Batch Requests/sec','Readahead pages/sec','Transactions/sec','Processes blocked','CPU usage %','User Connections','Logins/sec')
GROUP BY pc.sql_instance
If i remove the condition "[aggregation_interval_minutes] = 1" in the where condition then i see the data.
Please check whether this is a fix or I need to check something else.
Did you check DOCS to make sure there is no workaround? https://sqlwatch.io/docs/
Yes
Describe the bug The table "Performance - Average Values Over Time" does not show values for the columns:
Blocked, Batch Requests , Transactions, Connections, Logins/Sec
To Reproduce Steps to reproduce the behavior:
Expected behavior The columns must have values
Screenshots
Windows Server (please complete the following information):
SQL Server (please complete the following information):
SQL Server Management Studio (SSMS -> about -> copy info): Microsoft SQL Server Management Studio 13.0.16106.4 Microsoft Analysis Services Client Tools 13.0.1700.441 Microsoft Data Access Components (MDAC) 10.0.17763.1 Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.11.17763.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 6.3.17763
SQLWATCH version (from DACPAC or from sysinstances)
Additional context The table gets data from the below query SELECT --repository_dashboard_table 'Batch Requests/sec' = avg(case when counter_name = 'Batch Requests/sec' then [cntr_value_calculated] else null end) ,'Readahead pages/sec' = avg(case when counter_name = 'Readahead pages/sec' then [cntr_value_calculated] else null end) ,'Transactions/sec' = max(case when counter_name = 'Transactions/sec' then [cntr_value_calculated] else null end) ,'Processes blocked' = avg(case when counter_name = 'Processes blocked' then [cntr_value_calculated] else null end) ,'User Connections' = avg(case when counter_name = 'User Connections' then [cntr_value_calculated] else null end) ,'Logins/sec' = avg(case when counter_name = 'Logins/sec' then cntr_value_calculated else null end) ,pc.sql_instance FROM [dbo].[vw_sqlwatch_report_fact_perf_os_performance_counters] pc WHERE [aggregation_interval_minutes] = 1 AND $__timeFilter(snapshot_time) AND counter_name IN ('Batch Requests/sec','Readahead pages/sec','Transactions/sec','Processes blocked','CPU usage %','User Connections','Logins/sec') GROUP BY pc.sql_instance
If i remove the condition "[aggregation_interval_minutes] = 1" in the where condition then i see the data.
Please check whether this is a fix or I need to check something else.
Many thanks Zee