Standard answer for slowness -> what are your waits. Have you already activated query store to find the culprits? Is it patched up

Hyper-V:

Is it someway throttled: powersaving , resource limits,...

Moved the concatenation of tmp columnname in the STRING_AGG

select 'UPDATE '+name+' JOIN tmp USING (mssql_id) SET '+STRING_AGG(table_name +'.' + COLUMN_NAME+'=tmp.' + COLUMN_NAME,',')+';'
from dbo.t_column_details  C left join...

As you use a local smtp server, msdb.dbo.sp_send_dbmail will work find since it only sees the local smtp server.

Maybe your network admin could help configuring the smtp-server?

Do you send mails with Exchange Online through msdb.dbo.sp_send_dbmail?

We use a regular smtp-server for dbmail and  is not impacted (as it doesn't use exchange online)

Why did you pick the SQL 2012 forum? That version doesn't deal with pyspark / dataframes

CLOUD based setup: Do you mean that the monitoring tool should run in the cloud

And you want it to monitor on-premises databases (Servers ON-Prime)?

Or a monitoring tool that runs in...

Thanks for posting the commandline.

I can't help you further with rs.exe. We execute reports using urls. Does it stop immediately, after a fixed amount of time, ...

Any oracle timeouts set...

ORA-01013: user requested cancel of current operation

Your Oracle command is likely timing out.

Have a check on RPTUSER.CM_UNBILLED_DATA_P1

Did you set the -l parameter of rs.exe? (timeout)

Thanks for posting the solution

Where do you find "run in debug"?

It isn't build in to restore selected tables. Perhaps with 3th party software?

I hope benefits / motiviation of consolidating all databases into one outweighs the hassles with recovery (recovery time...

If you are only interested in EntityType, you  could use an nonclustered index on it. With a bit luck it only uses this index on one field instead of the...

If I run your code I get

Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@listid".

Is it possible to have some sample data in...

MS has a whole page on it

https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-injection?view=sql-server-ver16

You could use sp_humanevents (Erik Darling) https://www.erikdarlingdata.com/sp_humanevents/

To capture the waits while it is slow or log it to a table

Tools like sp_Blitz, sp_Blitzfirst (Brent Ozar) to have a quick...

• This reply was modified 3 years, 6 months ago by Jo Pattyn. Reason: added XESmartTarget