try

CREATE EVENT SESSION [Performance monitoring] ON SERVER
ADD EVENT sqlserver.sql_statement_completed(SET collect_statement=(1)
ACTION(sqlserver.client_hostname,sqlserver.database_name,sqlserver.nt_username,sqlserver.plan_handle)
WHERE ([package0].[greater_than_int64]([duration],(30000)) AND [sqlserver].[username]<>N'NT SERVICE\SQLTELEMETRY'))
ADD TARGET package0.event_file(SET FILENAME=N'...',max_file_size=(5))
WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=OFF,STARTUP_STATE=OFF)
GO

• This reply was modified 1 year, 2 months ago by frederico_fonseca.

or use MSDN licensing - but this has a whole bunch of other implications for everyone that accesses the server with it.

its a bug - will be fixed on future CU - helps reading the documentation https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2019/cumulativeupdate27

and is the insert a single statement inserting single row values or is it the result of joining other tables - including the possibility of being done on a merge...

edit: dup post

• This reply was modified 1 year, 3 months ago by frederico_fonseca.

looks...

that link kind of says it all - but it is a bit over the top in my opinion.

first thing - separate the 3 permissions mentioned (SHOWPLAN, ALTER TRACE and...

before worrying about how much you are going to need you should be looking at what tables did grow, and why - is that expected business data being added or...

how have you managed to max the VM in terms of storage?  unless you have a crap vm (which by the looks of it isn't, as a 32 vcpu is...

as mentioned on this, and other of your threads, the index usage gets reset with every restart/failover of the server (and likely also as part of a specific db restore/offline...

• This reply was modified 1 year, 3 months ago by frederico_fonseca.

don't know what tool you are using to execute the above -...

don't know what tool you are using to execute the above - but on...

Thanks for the feedback.

Jon,

This is a code deploy script file, I'm trying to create. Hence, need to set DB context first then run a few DDLs (see below)

Example snippet:

SELECT...

Cluster STXL on ( MANDT, TDOBJECT, TDNAME ) instead of creating all those separate non-clus indexes.  If those key columns are not inherently unique, and you can add a...

I'd like to run an SSIS package asynchronously from a SQL Agent job step through the the [SSISDB].[catalog].[create_execution] and [SSISDB].[catalog].[start_execution] stored procedures. I need the target package to be...

• This reply was modified 1 year, 3 months ago by frederico_fonseca.