Grafana "Repository Dashboard" doesnt display [CPU usage%]

kekcjkee commented 3 years ago

I'm learning English. Sorry for mistakes.

Did you check DOCS to make sure there is no workaround? Yes

Describe the bug I have a central repository with multiple remote servers. One server is SQL Server Standard Edition and the repository dashboard does not show the percentage of CPU usage for that server. But SQL Instance Overview display that.

To Reproduce Steps to reproduce the behavior:

Create central repository (SQL1) and setup SQLWatchImport.exe for migrate data to it from remote server (SQL02).

Expected behavior I want to look CPU Usage % for all remote servers without dependence Edition.

Screenshots

Windows Server (please complete the following information):

SQL01 (Central Repository) - Windows Server 2019 Standard 10.0
SQL02 (Remote Server) - Windows Server 2016 Standard 10.0

SQL Server (please complete the following information):

SQL01 (Central Repository) Version: Microsoft SQL Server 2019 (RTM-CU9) (KB5000642) - 15.0.4102.2
SQL01 (Central Repository) Edition: Developer Edition
SQL02 (Remote server) Version: Microsoft SQL Server 2017 (RTM-GDR) (KB4505224) - 14.0.2027.2
SQL02 (Remote server) Edition: Standard Edition

SQL Server Management Studio (SSMS -> about -> copy info): SQL Server Management Studio 15.0.18369.0 SQL Server Management Objects (SMO) 16.100.46041.41 Microsoft Analysis Services Client Tools 15.0.19342.0 Microsoft Data Access Components (MDAC) 10.0.17763.1 Microsoft MSXML 3.0 6.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.17763

SQLWATCH version (from DACPAC or from sysinstances)

SQL01 (Central Repository): 4.2.0.28234
SQL02 (Remote server): 4.2.0.28234

marcingminski commented 3 years ago

duplicate of https://github.com/marcingminski/sqlwatch/issues/261 Are you referring to the central repo dashboard only?

kekcjkee commented 3 years ago

Yes. It doesnt work only on central repository dashboard.

steffenengelhamburg commented 3 years ago

Hi, got the same: the source of problem was a failure on a prior Import. SQLWatchImport.exe Log File showed some Duplicate Keys on each later import for this server.

2021-05-26 13:20:18.752 ERROR Failed to merge table "[V-SQL001].dbo.sqlwatch_meta_procedure" at Cannot insert duplicate key row in object 'dbo.sqlwatch_meta_procedure' with unique index 'idx_sqlwatch_meta_procedure_1'. The duplicate key value is (V-SQL001, 5, Ad-Hoc Query 3FBE6AA6).

After debugging imports in the DWH this seems that SQLWatch imported some parts of CPU count until a parallel session that imported sqlwatch_meta_procedure hits the duplicate key error.

The SQL Instance Overview displayed all CPU data but not the last that where needed for the Central Repository.

Solution in my case: investigate SQLWatchImport Log File or cmd output and find the duplicate Keys. Delete in DWH all Entries for the Server on that table.

Run a Full Import for the Server.

Thats it....

Greetings from Hamburg

kekcjkee commented 3 years ago

Hi, @steffenengelhamburg . I dont have errors in the logs for the problem instance. Look it. Do I understand you correctly?

2021-05-26 15:09:31.678 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_xes_query_processing" (Thread: 13)
2021-05-26 15:09:31.710 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_xes_wait_event" (Thread: 17)
2021-05-26 15:09:31.850 DEBUG Fetched "Last Seen" ("2021-05-26 12:04:38.557") from "dbo.sqlwatch_meta_os_volume" for "[SQL02]" in 0.9029ms. (Thread: 8)
2021-05-26 15:09:31.850 DEBUG Fetched "Last Updated" ("2021-05-24 08:34:51.360") from "dbo.sqlwatch_meta_memory_clerk" for "[SQL02]" in 1.0167ms. (Thread: 28)
2021-05-26 15:09:31.850 DEBUG Fetched "Last Updated" ("2021-05-24 08:34:51.300") from "dbo.sqlwatch_meta_performance_counter" for "[SQL02]" in 0.89ms. (Thread: 22)
2021-05-26 15:09:31.850 DEBUG Fetched "Last Seen" ("2021-05-26 12:00:26.977") from "dbo.sqlwatch_meta_procedure" for "[SQL02]" in 3.4998ms. (Thread: 43)
2021-05-26 15:09:31.897 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_os_volume" (Thread: 10)
2021-05-26 15:09:31.897 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_memory_clerk" (Thread: 39)
2021-05-26 15:09:31.897 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_procedure" (Thread: 14)
2021-05-26 15:09:31.897 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_performance_counter" (Thread: 39)
2021-05-26 15:09:32.085 DEBUG Fetched "Last Seen" ("1970-01-01 00:00:00.000") from "dbo.sqlwatch_meta_sql_query" for "[SQL02]" in 0.8631ms. (Thread: 12)
2021-05-26 15:09:32.085 DEBUG Fetched "Last Seen" ("2021-05-26 08:18:13.000") from "dbo.sqlwatch_meta_query_plan_hash" for "[SQL02]" in 0.9971ms. (Thread: 46)
2021-05-26 15:09:32.085 DEBUG Fetched "Last Updated" ("2021-05-24 08:39:30.787") from "dbo.sqlwatch_meta_system_configuration" for "[SQL02]" in 2.8323ms. (Thread: 15)
2021-05-26 15:09:32.085 DEBUG Fetched "Last Updated" ("2021-05-24 08:34:07.377") from "dbo.sqlwatch_meta_report" for "[SQL02]" in 3.3143ms. (Thread: 49)
2021-05-26 15:09:32.132 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_program_name" (Thread: 10)
2021-05-26 15:09:32.132 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_sql_query" (Thread: 33)
2021-05-26 15:09:32.132 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_query_plan_hash" (Thread: 45)
2021-05-26 15:09:32.132 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_system_configuration" (Thread: 42)
2021-05-26 15:09:32.132 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_report" (Thread: 24)
2021-05-26 15:09:32.319 DEBUG Fetched "Last Snapshot Time" ("1970-01-01") from "dbo.sqlwatch_logger_perf_query_stats" for "[SQL02]" in 0.8202ms. (Thread: 12)
2021-05-26 15:09:32.319 DEBUG Fetched "Last Seen" ("2021-05-26 08:00:26.787") from "dbo.sqlwatch_meta_database" for "[SQL02]" in 0.6716ms. (Thread: 20)
2021-05-26 15:09:32.319 DEBUG Fetched "Last Snapshot Time" ("1970-01-01") from "dbo.sqlwatch_logger_report_action" for "[SQL02]" in 0.8643ms. (Thread: 43)
2021-05-26 15:09:32.319 DEBUG Fetched "Last Updated" ("1970-01-01 00:00:00.000") from "dbo.sqlwatch_meta_baseline" for "[SQL02]" in 0.7108ms. (Thread: 5)
2021-05-26 15:09:32.319 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 08:14:03") from "dbo.sqlwatch_logger_xes_blockers" for "[SQL02]" in 3.1296ms. (Thread: 46)
2021-05-26 15:09:32.319 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 08:17:13") from "dbo.sqlwatch_logger_xes_iosubsystem" for "[SQL02]" in 3.6057ms. (Thread: 17)
2021-05-26 15:09:32.350 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_perf_query_stats" (Thread: 26)
2021-05-26 15:09:32.350 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_report_action" (Thread: 8)
2021-05-26 15:09:32.350 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_baseline" (Thread: 30)
2021-05-26 15:09:32.350 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_xes_blockers" (Thread: 22)
2021-05-26 15:09:32.350 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_xes_iosubsystem" (Thread: 9)
2021-05-26 15:09:32.366 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_database" (Thread: 12)
2021-05-26 15:09:32.522 DEBUG Fetched "Last Updated" ("1970-01-01 00:00:00.000") from "dbo.sqlwatch_meta_errorlog_attribute" for "[SQL02]" in 0.7289ms. (Thread: 43)
2021-05-26 15:09:32.522 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 08:14:43") from "dbo.sqlwatch_logger_check_action" for "[SQL02]" in 1.315ms. (Thread: 17)
2021-05-26 15:09:32.538 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:09:03") from "dbo.sqlwatch_logger_perf_os_schedulers" for "[SQL02]" in 4.8626ms. (Thread: 40)
2021-05-26 15:09:32.538 DEBUG Fetched "Last Updated" ("1970-01-01 00:00:00.000") from "dbo.sqlwatch_meta_errorlog_keyword" for "[SQL02]" in 5.0664ms. (Thread: 30)
2021-05-26 15:09:32.554 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:09:03") from "dbo.sqlwatch_logger_dm_exec_requests_stats" for "[SQL02]" in 28.4726ms. (Thread: 19)
2021-05-26 15:09:32.569 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_errorlog_attribute" (Thread: 18)
2021-05-26 15:09:32.569 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:09:03") from "dbo.sqlwatch_logger_dm_exec_sessions_stats" for "[SQL02]" in 45.962ms. (Thread: 20)
2021-05-26 15:09:32.585 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_check_action" (Thread: 15)
2021-05-26 15:09:32.585 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_errorlog_keyword" (Thread: 29)
2021-05-26 15:09:32.585 DEBUG Created landing table "#dbo.sqlwatch_logger_perf_os_schedulers" for "SQL02" in 7.46ms. (Thread: 23)
2021-05-26 15:09:32.600 DEBUG Copied 3 rows from "[SQL02].dbo.sqlwatch_logger_perf_os_schedulers" to "#dbo.sqlwatch_logger_perf_os_schedulers" in 60.2045ms. (Thread: 37)
2021-05-26 15:09:32.600 DEBUG Merged 2 rows from "#dbo.sqlwatch_logger_perf_os_schedulers" for "SQL02" in 2.5152ms (Thread: 48)
2021-05-26 15:09:32.600 INFO Imported "dbo.sqlwatch_logger_perf_os_schedulers" from "SQL02" in 1156.9034ms (Thread: 48)
2021-05-26 15:09:32.616 DEBUG Created landing table "#dbo.sqlwatch_logger_dm_exec_requests_stats" for "SQL02" in 6.4739ms. (Thread: 20)
2021-05-26 15:09:32.632 DEBUG Copied 6 rows from "[SQL02].dbo.sqlwatch_logger_dm_exec_requests_stats" to "#dbo.sqlwatch_logger_dm_exec_requests_stats" in 67.8032ms. (Thread: 26)
2021-05-26 15:09:32.632 DEBUG Merged 4 rows from "#dbo.sqlwatch_logger_dm_exec_requests_stats" for "SQL02" in 2.6339ms (Thread: 50)
2021-05-26 15:09:32.632 INFO Imported "dbo.sqlwatch_logger_dm_exec_requests_stats" from "SQL02" in 1188.0756ms (Thread: 50)
2021-05-26 15:09:32.632 DEBUG Created landing table "#dbo.sqlwatch_logger_dm_exec_sessions_stats" for "SQL02" in 7.7044ms. (Thread: 11)
2021-05-26 15:09:32.632 DEBUG Copied 6 rows from "[SQL02].dbo.sqlwatch_logger_dm_exec_sessions_stats" to "#dbo.sqlwatch_logger_dm_exec_sessions_stats" in 62.88ms. (Thread: 5)
2021-05-26 15:09:32.647 DEBUG Merged 4 rows from "#dbo.sqlwatch_logger_dm_exec_sessions_stats" for "SQL02" in 2.6727ms (Thread: 43)
2021-05-26 15:09:32.647 INFO Imported "dbo.sqlwatch_logger_dm_exec_sessions_stats" from "SQL02" in 1203.2146ms (Thread: 43)
2021-05-26 15:09:32.647 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:09:03") from "dbo.sqlwatch_logger_perf_os_wait_stats" for "[SQL02]" in 2.7032ms. (Thread: 42)
2021-05-26 15:09:32.647 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:04:39") from "dbo.sqlwatch_logger_disk_utilisation_volume" for "[SQL02]" in 2.7413ms. (Thread: 27)
2021-05-26 15:09:32.647 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:09:03") from "dbo.sqlwatch_logger_perf_os_memory_clerks" for "[SQL02]" in 2.1456ms. (Thread: 23)
2021-05-26 15:09:32.647 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:04:38") from "dbo.sqlwatch_logger_disk_utilisation_database" for "[SQL02]" in 2.8339ms. (Thread: 20)
2021-05-26 15:09:32.647 DEBUG Fetched "Last Snapshot Time" ("1970-01-01") from "dbo.sqlwatch_logger_errorlog" for "[SQL02]" in 5.0686ms. (Thread: 23)
2021-05-26 15:09:32.647 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:05:43") from "dbo.sqlwatch_logger_check" for "[SQL02]" in 3.5948ms. (Thread: 44)
2021-05-26 15:09:32.647 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:00:30") from "dbo.sqlwatch_logger_perf_procedure_stats" for "[SQL02]" in 10.4364ms. (Thread: 18)
2021-05-26 15:09:32.694 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_check" (Thread: 10)
2021-05-26 15:09:32.694 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_disk_utilisation_database" (Thread: 45)
2021-05-26 15:09:32.694 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_errorlog" (Thread: 29)
2021-05-26 15:09:32.694 DEBUG Created landing table "#dbo.sqlwatch_logger_perf_os_wait_stats" for "SQL02" in 10.4124ms. (Thread: 8)
2021-05-26 15:09:32.694 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_disk_utilisation_volume" (Thread: 42)
2021-05-26 15:09:32.710 DEBUG Created landing table "#dbo.sqlwatch_logger_perf_os_memory_clerks" for "SQL02" in 5.8198ms. (Thread: 41)
2021-05-26 15:09:32.710 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_perf_procedure_stats" (Thread: 16)
2021-05-26 15:09:32.710 DEBUG Copied 6 rows from "[SQL02].dbo.sqlwatch_logger_perf_os_memory_clerks" to "#dbo.sqlwatch_logger_perf_os_memory_clerks" in 61.9894ms. (Thread: 41)
2021-05-26 15:09:32.710 DEBUG Copied 67 rows from "[SQL02].dbo.sqlwatch_logger_perf_os_wait_stats" to "#dbo.sqlwatch_logger_perf_os_wait_stats" in 64.0188ms. (Thread: 21)
2021-05-26 15:09:32.710 DEBUG Merged 4 rows from "#dbo.sqlwatch_logger_perf_os_memory_clerks" for "SQL02" in 1.9342ms (Thread: 37)
2021-05-26 15:09:32.710 INFO Imported "dbo.sqlwatch_logger_perf_os_memory_clerks" from "SQL02" in 69.2298ms (Thread: 37)
2021-05-26 15:09:32.725 DEBUG Merged 45 rows from "#dbo.sqlwatch_logger_perf_os_wait_stats" for "SQL02" in 13.8694ms (Thread: 19)
2021-05-26 15:09:32.725 INFO Imported "dbo.sqlwatch_logger_perf_os_wait_stats" from "SQL02" in 83.0848ms (Thread: 19)
2021-05-26 15:09:32.866 DEBUG Fetched "Last Snapshot Time" ("2021-05-25 21:00:01") from "dbo.sqlwatch_logger_system_configuration" for "[SQL02]" in 1.1522ms. (Thread: 45)
2021-05-26 15:09:32.866 DEBUG Fetched "Last Updated" ("2021-05-24 08:39:31.147") from "dbo.sqlwatch_meta_system_configuration_scd" for "[SQL02]" in 1.0405ms. (Thread: 9)
2021-05-26 15:09:32.866 DEBUG Fetched "Last Seen" ("2021-05-26 08:18:13") from "dbo.sqlwatch_meta_query_plan" for "[SQL02]" in 1.2417ms. (Thread: 17)
2021-05-26 15:09:32.866 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 08:18:13") from "dbo.sqlwatch_logger_xes_long_queries" for "[SQL02]" in 1.2778ms. (Thread: 18)
2021-05-26 15:09:32.866 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:09:03") from "dbo.sqlwatch_logger_perf_os_performance_counters" for "[SQL02]" in 2.2072ms. (Thread: 24)
2021-05-26 15:09:32.866 DEBUG Fetched "Last Seen" ("2021-05-26 12:00:26.680") from "dbo.sqlwatch_meta_agent_job_step" for "[SQL02]" in 1.2195ms. (Thread: 15)
2021-05-26 15:09:32.866 DEBUG Fetched "Last Updated" ("1970-01-01 00:00:00.000") from "dbo.sqlwatch_meta_performance_counter_instance" for "[SQL02]" in 2.2303ms. (Thread: 39)
2021-05-26 15:09:32.866 DEBUG Fetched "Last Seen" ("2021-05-26 08:00:27.380") from "dbo.sqlwatch_meta_table" for "[SQL02]" in 1.5111ms. (Thread: 10)
2021-05-26 15:09:32.897 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_query_plan" (Thread: 40)
2021-05-26 15:09:32.913 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_system_configuration_scd" (Thread: 23)
2021-05-26 15:09:32.913 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_system_configuration" (Thread: 37)
2021-05-26 15:09:32.913 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_xes_long_queries" (Thread: 47)
2021-05-26 15:09:32.913 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_performance_counter_instance" (Thread: 37)
2021-05-26 15:09:32.913 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_agent_job_step" (Thread: 11)
2021-05-26 15:09:32.913 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_table" (Thread: 33)
2021-05-26 15:09:32.913 DEBUG Created landing table "#dbo.sqlwatch_logger_perf_os_performance_counters" for "SQL02" in 4.879ms. (Thread: 30)
2021-05-26 15:09:32.929 DEBUG Copied 231 rows from "[SQL02].dbo.sqlwatch_logger_perf_os_performance_counters" to "#dbo.sqlwatch_logger_perf_os_performance_counters" in 62.0111ms. (Thread: 24)
2021-05-26 15:09:32.944 DEBUG Merged 154 rows from "#dbo.sqlwatch_logger_perf_os_performance_counters" for "SQL02" in 10.9775ms (Thread: 46)
2021-05-26 15:09:32.944 INFO Imported "dbo.sqlwatch_logger_perf_os_performance_counters" from "SQL02" in 293.27ms (Thread: 46)
2021-05-26 15:09:33.069 DEBUG Fetched "Last Seen" ("2021-05-26 08:00:26.880") from "dbo.sqlwatch_meta_master_file" for "[SQL02]" in 0.949ms. (Thread: 10)
2021-05-26 15:09:33.116 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_master_file" (Thread: 42)
2021-05-26 15:09:33.116 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_snapshot_header_baseline" (Thread: 14)
2021-05-26 15:09:33.116 DEBUG Fetched "Last Seen" ("2021-05-25 21:15:01.910") from "dbo.sqlwatch_meta_index_missing" for "[SQL02]" in 0.7542ms. (Thread: 29)
2021-05-26 15:09:33.116 DEBUG Fetched "Last Seen" ("2021-05-25 21:15:01.690") from "dbo.sqlwatch_meta_index" for "[SQL02]" in 1.2652ms. (Thread: 47)
2021-05-26 15:09:33.116 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:09:03") from "dbo.sqlwatch_logger_perf_file_stats" for "[SQL02]" in 0.8322ms. (Thread: 48)
2021-05-26 15:09:33.116 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:04:39") from "dbo.sqlwatch_logger_disk_utilisation_table" for "[SQL02]" in 1.1599ms. (Thread: 8)
2021-05-26 15:09:33.116 DEBUG Fetched "Last Snapshot Time" ("2021-05-26 12:00:00") from "dbo.sqlwatch_logger_agent_job_history" for "[SQL02]" in 2.4628ms. (Thread: 43)
2021-05-26 15:09:33.163 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_index" (Thread: 24)
2021-05-26 15:09:33.163 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_meta_index_missing" (Thread: 26)
2021-05-26 15:09:33.163 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_disk_utilisation_table" (Thread: 46)
2021-05-26 15:09:33.163 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_agent_job_history" (Thread: 20)
2021-05-26 15:09:33.241 DEBUG Created landing table "#dbo.sqlwatch_logger_perf_file_stats" for "SQL02" in 15.3518ms. (Thread: 19)
2021-05-26 15:09:33.257 DEBUG Copied 93 rows from "[SQL02].dbo.sqlwatch_logger_perf_file_stats" to "#dbo.sqlwatch_logger_perf_file_stats" in 132.8102ms. (Thread: 8)
2021-05-26 15:09:33.257 DEBUG Merged 62 rows from "#dbo.sqlwatch_logger_perf_file_stats" for "SQL02" in 4.3993ms (Thread: 24)
2021-05-26 15:09:33.257 INFO Imported "dbo.sqlwatch_logger_perf_file_stats" from "SQL02" in 140.205ms (Thread: 24)
2021-05-26 15:09:33.257 DEBUG Fetched "Last Snapshot Time" ("2021-05-25 21:15:02") from "dbo.sqlwatch_logger_index_missing_stats" for "[SQL02]" in 0.7743ms. (Thread: 39)
2021-05-26 15:09:33.257 DEBUG Fetched "Last Snapshot Time" ("1970-01-01") from "dbo.sqlwatch_logger_index_usage_stats" for "[SQL02]" in 0.7479ms. (Thread: 44)
2021-05-26 15:09:33.257 DEBUG Fetched "Last Snapshot Time" ("1970-01-01") from "dbo.sqlwatch_logger_index_histogram" for "[SQL02]" in 2.2713ms. (Thread: 13)
2021-05-26 15:09:33.304 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_index_usage_stats" (Thread: 51)
2021-05-26 15:09:33.304 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_index_missing_stats" (Thread: 19)
2021-05-26 15:09:33.304 DEBUG Nothing to import from "[SQL02].dbo.sqlwatch_logger_index_histogram" (Thread: 37)
2021-05-26 15:09:33.304  Finished: "SQL02". Time taken: 2196.5636ms 
2021-05-26 15:09:33.304  Import completed in 2655.0407ms

steffenengelhamburg commented 3 years ago

Correct, that seems fine ... other possible problem: got this solved in a different customer environment... Please check:

Grafana DWH source is set to 5 sek
both dashboards are set to Default Browser Time or the same Timezone
no Local Time Delay between Client and Grafana Server (maybe because different NTP Timeserver)

kekcjkee commented 3 years ago

@steffenengelhamburg I think problem in the query. I add instead of [CPU usage %] [Processor Time %] and that works. Its from #261

SELECT 
      [time] = snapshot_time --FLOOR(DATEDIFF(second, '1970-01-01', t.[snapshot_time])/1)*1
      ,'CPU Usage %' = t.[cntr_value_calculated]
  FROM (SELECT 
     snapshot_time
    ,[cntr_value_calculated]=sum(pc.[cntr_value_calculated])
    FROM [dbo].[sqlwatch_logger_perf_os_performance_counters] pc
        inner join [dbo].[sqlwatch_meta_performance_counter] mpc
            on pc.sql_instance = mpc.sql_instance
            and pc.performance_counter_id = mpc.performance_counter_id  
    WHERE pc.snapshot_time BETWEEN '2021-05-26T12:39:53Z' AND '2021-05-26T12:44:53Z'
    --AND mpc.counter_name IN ('CPU usage %')
    AND mpc.counter_name IN ('Processor Time %') -- Instead of [CPU usage %] [Processor Time %]
    AND pc.instance_name NOT IN ('internal')
    AND pc.[sql_instance] IN ('SQL02')
       AND snapshot_time >= dateadd(minute,-15,getutcdate())
    GROUP BY snapshot_time) t
 -- GROUP BY snapshot_time --FLOOR(DATEDIFF(second, '1970-01-01', t.[snapshot_time])/1)*1
ORDER BY
  time ASC

funooni commented 2 years ago

Dears,

I am facing a similar issue. I see only 1 box and that says no data, this particular box has no data but all other queries do have data but none of the tiles is shown.

I see that the field is not found

Whereas i can see the field in the query as well as query results.

Any help will be appreciated.

steffenengelhamburg commented 2 years ago

Hi, I‘m just working on Converted Grafana 8 Dashboards and finished 99%, but still struggled with the Checks reports. Because i‘m in holiday for 10 days without laptop i can upload the new dashboards not before the return ;)

I tested on Grafana 7 and 8 and found, that the new Dashboards seems not compatible. I‘ll commit a new set of dashboards for Grafana 8.

greetings from the baltic sea Steffen

funooni commented 2 years ago

Hi, I‘m just working on Converted Grafana 8 Dashboards and finished 99%, but still struggled with the Checks reports. Because i‘m in holiday for 10 days without laptop i can upload the new dashboards not before the return ;)

I tested on Grafana 7 and 8 and found, that the new Dashboards seems not compatible. I‘ll commit a new set of dashboards for Grafana 8.

greetings from the baltic sea Steffen

Many thanks for your prompt response. I just tried on grafana 7.5.9 and it works. Enjoy your holidays. Greetings from Arabian desert. Zee

steffenengelhamburg commented 2 years ago

Hi, back on track, i changed the dashboards and fixed some V8 Issues. For testing i uploaded the Zip for review in #392

https://github.com/marcingminski/sqlwatch/issues/392

Please let me know if the Dashboards work or some more fixes are needed.

Greetings from Hamburg Steffen

SergeiTsernitski commented 9 months ago

@steffenengelhamburg is it possible to check dashboards for Grafana v10.0.2? There are still issues with displaying CPU Usage in 'Repository Dashboard'.

steffenengelhamburg commented 9 months ago

Hi Sergei, what issues are you facing? Greetings from Hamburg

marcingminski / sqlwatch

Grafana "Repository Dashboard" doesnt display [CPU usage%] #379