If Member_MRN_lkupAllMBRNOs is a multi-statement table-valued user-defined function, that alone is going to cause pretty massive performance heads. Either switch it to being an in-line function, or eliminate the use...

I agree with Johan, you want to take a look at Data Masker. It's probably the single most sophisticated tool for getting this done, and it will absolutely keep relations...

That is an odd one. Are you under memory stress? Have you tried writing out to file? I generally don't recommend using the buffers because it does add considerable overhead...

Up front, I work for Redgate.

We, every monitoring tool, use the exact same set of tools you can use. Dynamic Management Views, Extended Events, Query Store, DMI queries, PerfMon, all...

Remember, that's a VM, so you're reading what it thinks it sees from within that VM. You should also run queries against the hypervisor to see how much CPU is...

Wait.

A terrabyte restore could take several hours depending on your disk, the amount of recovery needed, contention on resources with running processes...

Wait.

Or, look to the wait statistics to see what...

Pretty sure this query will do everything you're asking for and more.

January 24, 2022 at 2:46 pm

#3976538

Yep. Timeout is strictly a client connection setting. You can control the remote query timeout setting, but it's still very much a client-side problem. Otherwise, this sure sounds like...

The execution plan doesn't have runtime metrics (what's called an "Actual Plan" in SSMS), so it's a little hard to know precisely what's happening. You say it's returning two rows....

As @ratbak says, a SELECT won't affect data in tables. Any given SELECT operation can cause blocking as it uses resources, which can slow down things. However, that's extremely common...

Here's the Microsoft documentation

Read uncommitted simply doesn't take out some locks, allowing for reads as data gets changed. This can result in incorrect data, missing or duplicate data. Honestly,...

I don't have documentation on this kind of setup, sorry. I've never run more than 2-3 instances on a server.

However, heck yes, you need to have max memory set.

@jo-2 Pattyn...

One, please, always, despite this being a technical question, talk to someone in legal at your organization after you decide on a path forward.

Two, I've been studying this for years,...

ISNULL will affect performance if the ISNULL is being used in WHERE, ON or HAVING. As part of the SELECT or VALUES listing of columns, ISNULL won't be a big...

Thanks for the responses everyone.

Rod, I feel for you man. It's hard to find good places where you can learn & grow. I went through four jobs in less than...