Description
Summarize Functionality
Currently, the only documentation for Read-DbaXEFile that does not require knowing the path to the .xel file is Get-DbaXESession -SqlInstance sql2019 -Session deadlocks | Read-DbaXEFile. I've never seen this work, presumably because the documentation strongly suggests that it only works if you write your .xel file to a file share and I've never seen anyone do that.
I propose that we document how to use Read-DbaXEFile without knowing the file path and without needing a UNC share. The only trick that I know for this is by putting many extra steps in the pipeline. For example,
`Get-DbaXESession -SqlInstance sql2019 -Session deadlocks |
Get-DbaXESessionTarget |
Get-DbaXESessionTargetFile |
Read-DbaXEFile
works consistently for me, but requires some permissions that I have yet to fully understand.
Is there a command that is similiar or close to what you are looking for?
Yes
Technical Details
As above. The only thing to add is that it helps to stop the session to force a rollover.