Dashboard - Grafana 8.0.x - Fail

marcingminski / sqlwatch

SQL Server Performance Monitor

https://docs.sqlwatch.io

Other

428 stars 168 forks source link

Dashboard - Grafana 8.0.x - Fail #392

Open sozezzo opened 3 years ago

sozezzo commented 3 years ago

Describe the bug We just migrated to Grafana 8.0.x

To Reproduce Steps to reproduce the behavior:

Install Grafana 7.5.8
Import SQL Instance Overview.json on Grafana
Install Grafana 8.0.2

Screenshots SqlWatch

SQL Instance Overview

Grafana 7.5.8

Grafana 8.0.2

There are more errors but it is enough to show the problem.

marcingminski commented 3 years ago

Did you raise this with Grafana? Does not sound like a Sqlwatch problem if it used to work in Grafana 7?

marcingminski commented 3 years ago

Btw, the error suggest waits are not sorted by time? Can you check the query and test with order by time?

sozezzo commented 3 years ago

I think the problem is more serious than the message says. I changed the "order by", but still had other problems. It needs more analyze to fix.

I wrote to Grafana support, but I don't have Grafana Enterprise to have support. I hope they will answer me.

By now, my workaround is rollback to Grafana 7.5.8, but to someone that arrives now, they will think that SqlWatch doesn't work with Grafana.

marcingminski commented 3 years ago

From your screenshot, I can see that it's the waits and checks that fail. These are the only ones not sorted by time. I am still sure it will work when you sort it by time.

kekcjkee commented 3 years ago

@marcingminski

I have the same problem. After upgrading Grafana to 8.0. I think this should be mentioned in the documentation.

ERROR: failed to convert long to wide series when converting from dataframe: long series must be sorted ascending by time to be converted

steffenengelhamburg commented 3 years ago

Please can anyone try these V8 Dashboards? I tried them on V8 & V8.1 and soetimes get different result on Checks & Waits.

On latest Grafana V8 Version everything seem fine. Fixes on Instance Overview: Summary: Checks, Waits, Disk Used Table Memory: duplicate Column Error - replace the dupblicate Column "Page reads/sec" with missing "Readahead reads/sec"

On the Repository Dashboard the Datalinks on the Table are fixed to.

Grafana V8.1.zip

Please let me know if the Dashboards are ok, I'll create a Pull Request after validation.

Greetings from Germany Steffen

steffenengelhamburg commented 3 years ago

Hi @kekcjkee @marcingminski @sozezzo do you testet the dashboards?

Greetings from Hamburg Steffen

pcamelio commented 2 years ago

Hello I tested on Grafana 8.2.1 and the problem is gone

sozezzo commented 2 years ago

Unfortunately, my panels still have errors.

I have no time to check and to fix it, I use Grafana old version, and it is okay.

DickUMCG commented 2 years ago

Hello I tested on Grafana 8.2.1 and the problem is gone

Hmm... On 8.3.4 I have still the issues @sozezzo mentions. O, then I was trying to fix it and fixed it partly and then happened to find out that there was a new Grafana 8.1.zip which solves it completely. Thanx @steffenengelhamburg .