Go to All Forums

Monitoring SQL server

Due to the need to use specific SQL permissions, we are thinking about writing some SQL agent jobs that run a series of queries, compile that info and directly output the data in json format to a file.

 

Is there a method for that json file to be directly ingested in to site 24x7? 

 

If not, would something as basic as writing a powershell script that reads the json file and spits it back out work?

Like (1) Reply
Replies (1)

Re: Monitoring SQL server

Hi Clindsay,

       >>Is there a method for that json file to be directly ingested in to site 24x7?

 Yes, its possible using Site24x7's Custom Plugins.

You can write your own plugin and place it in Site24x7WindowsAgent Plugin's folder

Eg: "C:\Program Files (x86)\Site24x7\WinAgent\monitoring\Plugins".

The plugin will then be automatically detected by the Site24x7WindowsAgent and be executed at every 5 mins interval. 

As per your requirement, you can write a PowerShell plugin, that performs the SQL agent jobs to run series of queries and provide that script output in JSON format.

But, make sure the plugin's JSON output has certain Mandatory Parameters. Find our help documentation below that will guide you through writing a plugin along with a sample plugin file for your reference.

https://www.site24x7.com/help/admin/adding-a-monitor/plugins/windows-custom-plugins.html

Hope this fulfills your requirement. Please let us know for further specifications or queries, if any.

Thanks!

Like (0) Reply

Was this post helpful?