How Many Threads Can One Query Use In SQL Server?

Become a member! www.youtube.co...
Click here for 50% off a health check: training.erikd...
If you like what you see here, you'll love my advanced performance tuning training:
training.erikd...

[@Garstor]

I have finally seen a subtree cost larger than anything I have ever worked on. I owe you a beer, sir. Except using Delta Miles to claim it is risky since they keep knocking important parts off their planes.

[@ErikDarlingData]

Hahaha, thankfully they’re on the ground when that happens.

[@Garstor]

@@ErikDarlingData Don't give them any ideas!

[@mickeuthas]

And Pythagoras theorem is very much about Right triangles and goes like this:
DECLARE
@SideA DECIMAL(10, 2) = 5
, @SideB DECIMAL(10, 2) = 10
, @Hypotenuse DECIMAL(10, 2)
SET @Hypotenuse = SQRT(POWER(@SideA, 2) + POWER(@SideB, 2))
Select @Hypotenuse As Hypotenuse

[@ErikDarlingData]

YOU'RE A GENIUS! Wow. Thank you for sharing!

[@lancebeasley8509]

I think it is a Right Triangle. Two sides at 90 degrees.

[@ErikDarlingData]

now that you mention it, i think you're right.

[@sanibalus1]

I still can't figure it out why sp_PressureDetector shows in the last result set 1264 for parallel_worker_count. The number of branches is 316. The DOP is degraded to 2. It should be 632 parallel workers used for that query. Why it is shown 1264 as the worker_count for that session in sp_PressureDetector?

[@ErikDarlingData]

I haven’t had time to look into it yet.

[@sanibalus1]

Anyway, thanks for one more useful video.

[@ErikDarlingData]

I figured it out. I was using SUM when I should have used MAX in the script. I'm pushing out some fixes to that and other odds and ends shortly.

[@plancktime9750]

I need to stop watching these videos. I'm learning too much about sql server

[@ErikDarlingData]

It does tend to lead to depression.