SQLDIAG /R /I "%cd%\SQLDiagPerfStats_Detailed_Trace.XML" /O "%cd%\SQLDiagOutput" /P
I'm using the above syntax to register sqldiag. However when I run the service or use SQLDIAG START. I get the following error
The SQLDIAG service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service.
Any help would be greatly appreciated.