On some SQL Server instances, (I did not find a pattern yet), when I try to manually start this session, I get the following error :
For target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", the parameter "filename" passed is invalid. Target parameter at index 0 is invalid (Microsoft SQL Server, Error: 25641)
If we look into the SQL Server logs, each time the instance starts (i.e. after Windows reboots for patches to get applied), we get :
Error: 25641, Severity: 16, State: 0. For target, "5B2DA06D-898A-43C8-9309-39BBBE93EBBD.package0.event_file", the parameter "filename" passed is invalid. Target parameter at index 0 is invalid
Error: 25710, Severity: 16, State: 1. Event session "system_health" failed to start. Refer to previous errors in the current session to identify the cause, and correct any associated problems.
Error: 25709, Severity: 16, State: 1. One or more event sessions failed to start. Refer to previous errors in the current session to identify the cause, and correct any associated problems.
Has anyone observed this issue ? I suspect it's due to permissions, as the definition of the session does not indicate a path, but simply the name of the .xel file. That is, it writes directly to the SQL Server logs folder, where obviously the SQL Server service account is granted full access.
I get the same issue for the AlwaysOn_health session.
Thanks in advance for your help !