Use Extended Events to capture the metrics. That's how I'd do it.

Wait, a deadlock is an error that will clear immediately. It won't lock the server and prevent access. I think you're saying that you're getting blocking that is preventing access....

But, from what I can see, the Payment_ID column matches to a value 67280309 for Reissued_from_payment_id. How do you related it to 33333 when the payment_id for that is 22222?...

Have you identified what query specifically it's trying to run and the structure of that query? Use Extended Events to track that down.

I'm one of those to push myself to learn. I'm often disappointed with myself for not learning more, faster. I think I'm concerned that if I don't push myself,...

My personal challenge workwise is to learn WhereScape and Snowflake to build a warehouse from our two major Health Care systems plus the myriad of one-off systems we have...

I'm having the same problem time-wise.  As the old saying goes, "So say we all". 😀

I also have to admit there's great incentive in learning something new if you...

Thanks Jeff.

Yeah, I'm still at "barely functional" when it comes to PostgreSQL. I made a few fast leaps and then I just haven't been able to carve out time to...

There really is no easy way to about defining table access. The tools you have can show you the queries that have been run and/or the procedures that have been...

Sorry. I was away. Looks like everyone took good care of you. Glad you tracked down the issue.

You can look at sys.dm_db_wait_stats, note, NOT sys.dm_os_wait_stats, to see network waits from the Azure SQL Database side of things. However, otherwise, you have to measure that from the client.

Whatever you choose, please, please, OH PLEASE, focus first on clarity and communication. Any other kind of rigid enforcement of some particular little persnickety rule must come second. The purpose...

Are you initializing the backup file each time, or is the backup file stacking? Try running RESTORE HEADERONLY to see if you're putting multiple backups into a single file....

Both have a future. Further, "cloud computing" is an insanely vague term, like, "I work with computers". Cloud computing encompasses stuff like cloud-hosted virtual machines, services, up to and including...

I tried it for a time to see if there was more or better engagement versus Youtube. Kind of sucked actually.

In other news "Oh no, my moribund Twitch account (which...