Does my approach for building a real time monitoring system make sense? [closed]
- by sameer
I am developing an application that will display a dashboard that will display data from different SQL databases. This needs to happen in almost real time, our refresh time is about 5 minutes. My approach so far is:
Develop a Windows service to accumulate the data from various SQL Server instances.
Persist those details into a SQL DB, from which the dashboard will display them on the web page.
Trigger fetching of data from the Windows service will every x minutes.
The details of the SQL Server instances will be stored in the SQL DB which the Windows service will be referring.
Does my approach make sense?