We have a new extended events session we are kicking off to record all SQL and RPC run on the database.
This is running on an Azure Managed SQL instance and writing event files to Azure Blob Storage.
For some reason the files are rolling when they reach 27 kilobytes. I’m trying to get them to fill to 100 megabytes before rolling like our old SQL Trace files used to function.
Any ideas why?
CREATE
EVENT SESSION AllQueries
ON DATABASE
ADD EVENT sqlserver.begin_tran_starting(
ACTION(sqlserver.session_id)),
ADD EVENT sqlserver.commit_tran_completed(
ACTION(sqlserver.session_id)),
ADD EVENT sqlserver.error_reported(
ACTION(package0.callstack,sqlserver.database_id,sqlserver.session_id,sqlserver.sql_text,sqlserver.tsql_stack)
WHERE ((severity)>=(20) OR ((error_number)=(17803) OR (error_number)=(701) OR (error_number)=(802) OR (error_number)=(8645) OR (error_number)=(8651) OR (error_number)=(8657) OR (error_number)=(8902) OR (error_number)=(41354) OR (error_number)=(41355) OR (error_number)=(41367) OR (error_number)=(41384) OR (error_number)=(41336) OR (error_number)=(41309) OR (error_number)=(41312) OR (error_number)=(41313)))),
ADD EVENT sqlserver.existing_connection(
ACTION(package0.event_sequence,sqlserver.client_hostname,sqlserver.session_id)),
ADD EVENT sqlserver.login(SET collect_options_text=(1)
ACTION(package0.event_sequence,sqlserver.client_hostname,sqlserver.session_id)),
ADD EVENT sqlserver.logout(
ACTION(package0.event_sequence,sqlserver.session_id)),
ADD EVENT sqlserver.physical_page_read(
ACTION(sqlserver.session_id)),
ADD EVENT sqlserver.rollback_tran_completed,
ADD EVENT sqlserver.rpc_completed(SET collect_statement=(1)
ACTION(sqlserver.database_id,sqlserver.database_name,sqlserver.query_hash,sqlserver.query_plan_hash,sqlserver.session_id,sqlserver.sql_text,sqlserver.username)),
ADD EVENT sqlserver.sql_batch_completed(
ACTION(sqlserver.database_id,sqlserver.database_name,sqlserver.query_hash,sqlserver.query_plan_hash,sqlserver.session_id,sqlserver.sql_text))
ADD TARGET
package0.event_file
(
SET filename =
'https://storage.blob.core.windows.net/storage/sqlxeventfile.xel',
max_file_size = 100,
max_rollover_files = 200
)
WITH
(MAX_MEMORY = 200 MB,
MAX_DISPATCH_LATENCY = 3600 SECONDS)
GO