DIMS MONITORING POC 1 Agent and Server Services

DIMS MONITORING POC 1 Agent and Server Services

#DIMS #MONITORING #POC #Agent #Server #Services

“Catalin Ploaie Cata Ploaie”

DIMS – MONITORING POC 1. Agent and Server Services

This video is part of a POC covering monitoring using agents and a server service. Up to this point the application was retrieving data from clients via scripts but I saw that most of the monitoring applications have something that runs
on the client which retrieve data locally and send to the server and on server there is a service which consume that data. So the video shows this behavior. What the video doesn’t show is how to create the windows services and the code
in each of those. Mostly the code is the result of chatgpt inquiries combined with code I already have as part of main application. In few words, client runs powershell scripts and tsql scripts and send them to DIMSServer as datatables
, DIMSServer service receive these tables and upon the amount of data in each table decide if it will insert data via SP or bulk insert. I searched and searched and couldn’t find a meaningful explanation of how query store retrieve and store queries in order to provide metrics as they provide or how other third party monitoring applications are doing hence I came with my own interpretation. I am bulkinserting everything covering a 15 seconds period from dm_exec_query_stats and memory…

source