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

I point to three tools for monitoring query performance (not Jobs, Johan's answer is a good one), including batches, statements and procedures. These are, in no particular order, Dynamic Management...

So just to clarify. if i have a clustered index on say contactid and invoiceid however none of the updates are on those columns then there wouldn't be a...

I like @DesNorton's answer.

However, what about just using the SEQUENCE object? It'll do the increments for you. It doesn't have to be specifically an IDENTITY column that way.