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

To add to this, settings for parallelism are not some "magic" number that can be applied across any environment. If it could be recommended with little to no information, then...

Yep. Lets say you are doing an update on a table or insert which requires an exclusive lock on the table. Having the query go parallel creates self-blocking as you...