As Andreas wrote, if you have access to the database you can use sp_Blitz, sp_humanevents, sp_WhoIsActive for a quick triage.

For administration of SQL DB's you might also look at dbatools

It's nice to have the dashboard.

You can use it when it's slow ("user request") to make an inventory of troublesome queries / blocking

Most expensive queries by cpu / reads /...

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...