search

Matticusau / sqlops-mssql-instance-insights

SqlOps Studio MSSQL Instance Insights Extension
MIT License
16 stars 3 forks source link

Bug: mssql-instance-XELSystemIO widget not formated well in chart due to null values #5

Open Matticusau opened 6 years ago

Matticusau commented 6 years ago

The query is returning NULL values for the [Longest Pending Request File] and [Longest Pending IO Duration] in some cases. This breaks the line chart visual.

One solution is to add ISNULL around the fields and default to 0.

This was previously tracked under sqlops-widgets issue 14 with a fix released to Dev. Need to make sure this was copied to this project