Describe the bug
There are several metrics in the SQL Instance Overview Grafana dashboard that produces errors that seem to be query related.
The 2 main errors seems to be:
ISSUE 1 -failed to convert long to wide series when converting from dataframe: long series must be sorted ascending by time to be converted
AND
ISSUE 2 - convert frame from rows error: duplicate column names are not allowed, found identical name XXX at column indices X and X
Screenshots
### ISSUE 1
This seems to occur when the query produces no results. I'm not sure if this is related to my repository not properly collecting the data or the query itself but the results are always zero records. This is a central repository with 12 instances, and none produce data from the query.
The areas where I see this error are:
SQL Server Overview Panel
No panel name - 2nd Panel - In the JSON it has an ID of 310. Appears above in the screen shot next to CPU
Top waits by total time
Checks
### ISSUE 2
This issue seems to occur when a field is returned twice in the query.
SQL Server Overview Panel
Disk Space Used %. The 2 and 3 columns returned in the query are unnamed and so produces the duplicate column error.
SQL Server Memory Panel - All the below for memory have the "Page reads/sec" field returned twice in the query
SQL Memory Breakdown
Process Memory
Memory Grant
Free list stalls/sec
Page Lookup Rate
Page reads/sec vs Page writes/sec
Checkpoint pages/sec
Lazy Writes/sec
Avg. Page Life Expectancy
Buffer cache hit ratio
SQLWATCH version (from DACPAC or from sysinstances)
Describe the bug There are several metrics in the SQL Instance Overview Grafana dashboard that produces errors that seem to be query related.
The 2 main errors seems to be: ISSUE 1 -failed to convert long to wide series when converting from dataframe: long series must be sorted ascending by time to be converted AND ISSUE 2 - convert frame from rows error: duplicate column names are not allowed, found identical name XXX at column indices X and X
Screenshots
### ISSUE 1 This seems to occur when the query produces no results. I'm not sure if this is related to my repository not properly collecting the data or the query itself but the results are always zero records. This is a central repository with 12 instances, and none produce data from the query.
The areas where I see this error are: SQL Server Overview Panel
### ISSUE 2 This issue seems to occur when a field is returned twice in the query. SQL Server Overview Panel
SQL Server Memory Panel - All the below for memory have the "Page reads/sec" field returned twice in the query
SQLWATCH version (from DACPAC or from sysinstances)