June 12, 2017 at 10:55 pm
Comments posted to this topic are about the item AUTO Affinity
June 12, 2017 at 10:57 pm
Nice question, thanks Steve.
Have only ever had to change this once, where a server was running multiple instances of SQL (and being used as a web server) - definitely not best practice, though...
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
June 13, 2017 at 2:58 am
Just to be pedantic, the thread doesn't randomly pick a CPU, the operating system moves the threads based on workload - but hey, I knew what you meant.
June 13, 2017 at 5:45 am
sipas - Tuesday, June 13, 2017 2:58 AMJust to be pedantic, the thread doesn't randomly pick a CPU, the operating system moves the threads based on workload - but hey, I knew what you meant.
I'll take your pedantic and raise you punctilious, the thread has to on a CPU before it can be moved 😛 :laugh:
Far away is close at hand in the images of elsewhere.
Anon.
June 13, 2017 at 5:56 am
David Burrows - Tuesday, June 13, 2017 5:45 AMI'll take your pedantic and raise you punctilious, the thread has to on a CPU before it can be moved 😛 :laugh:
One cannot be punctilious if one misses out a word in one's sentence. :rolleyes:
June 13, 2017 at 6:28 am
sipas - Tuesday, June 13, 2017 5:56 AMDavid Burrows - Tuesday, June 13, 2017 5:45 AMI'll take your pedantic and raise you punctilious, the thread has to on a CPU before it can be moved 😛 :laugh:
One cannot be punctilious if one misses out a word in one's sentence. :rolleyes:
To be or not to be........
LOL :hehe:
Far away is close at hand in the images of elsewhere.
Anon.
June 13, 2017 at 9:51 am
70 percent correct confirms that this was an easy one. Thanks, Steve!
June 19, 2017 at 10:14 am
Actually the correct answer is incorrect. The only correct thing in it is that it mentions
server workload. The thread can't pick a CPU, the OS assigns a CPU to the thread and that changes when the OS (not the thread) decides to assign a different CPU to that thread.
the strange thing is that the correct explanation is given when the "correct" answer is so obviously wrong. Or is it the BOL page referenced in teh explanation that's wrong? The URL referenced in the explanation redirects to https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-server-configuration-transact-sql which clearly states that the OS assigns threads when teh setting is AUTO.
As there is only one answer that says both that a thread is assigned to the CPU and it can change to a different thread later (which is acually correct if the antecededent to "it" is the assigned hread) that answer is the only one which can be interpreted as describing what actually happens. And that's not the answer claimed to be correct, but one of those claimed to be wrong.
Tom
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply