for true prod code I tend to avoid merge - performance vs insert/update can vary - either faster or slower and no quick rule to decide on it - its...

As the table is partitioned by a date - are records on "older" partitions ever updated/inserted/deleted? if not any index operation should be done on recent partitions only, which would...

look at this thread as it gives a good explanation - better to turn that setting off - https://stackoverflow.com/questions/59505490/ssis-2019-autoadjustbuffersize-causes-buffer-allocation-error

you did NOT give us the SQL code you are running - so nothing for us to advise on - just giving a table content and stating  you get no...

That script snippet seems to update the wrong job. The obfuscated name is larger than "DWLoad" for the job name in the job properties screenshot. Are you sure you...

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, 3 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, 4 months ago by frederico_fonseca.