Just a thought here from reading the XML, but any chance you have a trigger on CREATE_JOB_LOG that writes to the second DB (Logs_Epass)? or I may be reading the...

One thought, which Jeff implied, on performance improvement would be to pre-calculate the data. What I mean is rather than calculating the data on demand, do a nightly (or hourly)...

We collect these statistics on a weekly basis. This way we persist runtime history for all monitored instances.

This comes in handy when provisioning for growth or planning migrations.

Devs and...

To add to what everyone else said, I would not be surprised if it isn't 2 isolated databases involved. What is MORE likely is that a view on database A...

Not essentially a "speed it up" thing, but could you refresh a test instance and run that on the test instance? I am wondering if MAYBE the slowness is due...

That screenshot is TINY, but if I am reading it right, you are missing the functions. Have you installed the required modules and are you using the correct powershell version...

I agree with Frederico_fonsca here - OPENQUERY is going to give you the best performance as the query runs fully on the remote side. IF you are doing it in...

Just to add to what Ant-Green is saying - if you expose your SQL instance to the internet (ie not behind a firewall), someone is going to try to get...

Can you connect using other tools? The error tells you what is wrong though - Visual studio can't see the server. If I had to guess, I would say firewall,...

To add to what Frederico_fonseca said, we don't even know what tool you are importing the data to/from. You say "ETL", but is this SSIS? I think so, but not...

Just trying to eyeball your deadlock, it looks like the deadlock is caused by a python script. Quick review of the deadlock XML, it kind of looks like you are...

I know a lot of discussion has already happened on this, but I wanted to point out that it would be nice to see the actual vs estimated execution plan....

As far as I am aware, you can make the SSIS package in newer versions of VS, you just can't deploy IF the version is too new.

For example, I have...

Have you tried connecting by IP instead of server name set up in the hosts file? I am wondering if SQL Server Engine doesn't "trust" the hosts file and is...

One thing to point out though about the hashing approach and indexing on it though - is that index useful? You likely are not searching by the hash and are...