Blog Post

SQL Server Blog
1 MIN READ

SQL Server BDC Hints and Tips: Changing Grafana/Kibana Display Time Zone

BobDorr's avatar
BobDorr
Icon for Microsoft rankMicrosoft
Feb 08, 2022

 

Moved from: bobsql.com

 

The Grafana and Kibana interfaces default to the local browser time zone on a SQL Server BDC cluster.  Some of my machines are in the PST time zone and others the CST time zone and I find myself doing math calisthenics trying to line up metric and log information.

 

Currently the SQL Server BDC cluster does not allow you change the default from local browser time (being worked on by the team) but you can temporally adjust Grafana or Kibana.  Here I highlighted how to adjust the time zone for Grafana and Kibana.

 

Grafana: https://10.193.23.37:30777/Grafana

1.       Click on the Dashboard Settings (gear icon, top right)

2.       Change the time zone option

 If you press the ‘Save’ button the following error appears

 

3.       Instead use the ‘Go Back’ button which causes the current session to honor the selected time zone

 
Kibana: https://10.193.23.37:30777/kibana

1.       Click on the Settings (gear icon, left)

 

2.       Select Advanced Setting and Scroll to the time zone for data formatting

3.       Press the ‘SAVE’ Button

Updated Feb 08, 2022
Version 1.0
No CommentsBe the first to comment