search

KevinKelly25 / LearnSQL

LearnSQL, a website for learning SQL
1 stars 2 forks source link

Missing Performace Analytics on Databases #33

Open KevinKelly25 opened 6 years ago

KevinKelly25 commented 6 years ago

There are some great external applications that monitors performance and gives analytics. We need to look into them before we release the website.

KevinKelly25 commented 6 years ago

Since we are adding a lot more DB functionality this Checkpoint and in next checkpoint is all about focusing on connection management it makes sense to implement a monitoring tool this Checkpoint. I think we should test out the the grafana monitoring tool first. We can decide to change later if we find out this one does not meet our requirements. The docs concerning postgres are found here

KevinKelly25 commented 6 years ago

I have created a Installation guide for Grafana here

Please test and ensure you can get this working properly. This guide does not show the user how to get panels working as that is more DB specific. We will need to create a dashboard specifically for our purposes and then we can share it here. This issue will remain open until that dashboard in created. If anyone has ideas or parts of the dashboard they want to work on post the related queries and settings in this thread.

Side Note: Please let me know through teams if find any errors or things that need clarifying in the gist guide.