spaghettidba/XESmartTarget

Running XESmartTarget Continuously for 24/7 Monitoring

0x7FFFFFFFFFFFFFFF opened this issue · 1 comments

Hi,

I am new to using XESmartTarget and have gone through its documentation. From my understanding, in order to use XESmartTarget effectively, I need to run the executable continuously. Is that correct? If so, is there a built-in way to run it as a service? What is the recommended approach to ensure it runs 24/7 for monitoring a production SQL Server instance?

In the demos I've seen, the XESmartTarget executable is run in a command line. However, I am concerned that if the RDP session gets disconnected or logged off by someone, the program will exit, causing the monitoring to stop. I need a solution that ensures XESmartTarget runs continuously without being interrupted.

Any suggestions or best practices for achieving this would be greatly appreciated. Thank you in advance!

Hi, XESmartTarget needs to run continuously, that's right. There is no built-in way to make XESmartTarget run as a service, but you can run it in a service wrapper like NSSM. Basically, you register NSSM to run as a service (you can do so from the GUI, there's documentation on the website) and it runs whatever program you want at service start.
I don't recommend running XESmartTarget on the SQL Server box, use a different one if possible.
Hope this helps