Querying Azure SQL Extended Event not returning any data
I created an extended event in Azure SQL database to capture query data. The data is being written to Azure blog storage, and there is definitely data in the files:
I verified that data exists by downloading one of the files and opening it in SSMS.
I created the appropriate SAS token and database credentials.
However, when querying any of the xel files, it returns no data, and I am not sure why. I have tried both sys.fn_xe_file_target_read_file and sys.fn_get_audit_file_v2. Both return nothing as shown below.
Any ideas? What did I miss? Thank you very much.
1 answer
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more