Maybe a silly question, buy shouldn't there be a colon after https
? That is,
SELECT event_data FROM sys.fn_xe_file_target_read_file (N'https://example.blob.core.windows.net/exevents/Alwaysonheath*.xel',NULL, NULL, NULL);
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
0
I have setup extended events on Managed instance. Below are the steps followed:
create a master key
Create a credential for Azure Blob storage with shared access token
Create the extended event and start the session
The session is running and I can see the file available in blob storage.
The issue is whenever I am trying to view the target data, I am getting the error:
The log file name "https//example.blob.core.windows.net/exevents/Alwaysonheath*.xel" is invalid. Verify that the file exists and that the sql server account has access to it. (Microsoft sql server, error: 25718)
when i run the query to fetch event data: SELECT event_data FROM sys.fn_xe_file_target_read_file (N'https//example.blob.core.windows.net/exevents/Alwaysonheath*.xel',NULL, NULL, NULL);
The result set is empty
Note: I can download the file from azure storage and view the content, only when trying to view target data I am getting the above error.
Can you please guide me what might be the issue
Maybe a silly question, buy shouldn't there be a colon after https
? That is,
SELECT event_data FROM sys.fn_xe_file_target_read_file (N'https://example.blob.core.windows.net/exevents/Alwaysonheath*.xel',NULL, NULL, NULL);
Hi @robin sql ,
sys.fn_xe_file_target_read_file requires VIEW SERVER STATE permission on the server, please check it.
Reading large result sets by executing sys.fn_xe_file_target_read_file in Management Studio may result in an error. May be you can use the Results to File mode (Ctrl+Shift+F) to export large result sets to a file and read the file with another tool instead.