sql-servergrafananode-redsqlbrowser

How to use Select / Insert in the same time interval with 2 different software (i used grafana and node red)?

I created a system which need node-red as back end, and grafana as front end, and use sql server as database. And i realized when DMS (Database Management System) will lock the database for one session. so i cannot use insert(node red), AND Select(grafana) at the same time. the connection will be closed if i do that. What should i do to this case?

I tried to change time refresh interval in the grafana time setting. i used 1 second inject in node red, and i use 10 second in grafana. basicly the connection was stable until grafana action / 10 second.

I expect the grafana and the node red can work with mssql server at the same interval time.

Solution

  • Use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED before your Select queries.