July 14, 2011 at 2:55 am
I wasn't attempting to trick anyone, but rather trying to make you aware that there are some settings and functions that work differently for large scale, x64 systems.
July 14, 2011 at 3:36 am
SQLkiwi (7/13/2011)
affinity64 I/O mask rates quite low on the QotD-sneak-o-meter
Ha ha. That "sneak-o-meter" had me laughing.
There are several tricky, misworded, or confusing QOTD questions. I did get this one wrong because I confused the affinity with affinity64 and I accept that I was wrong.
July 14, 2011 at 7:06 am
Paul, the QotD-sneak-o-meter comment was hysterical. Thanks for clarifying what is being deprecated.
Steve, the question was a good one and taught lots of us about an aspect that many of us (myself at least) had never heard of before. I was certainly not trying to imply that you were trying to trick us. I answered hastily before reading more on the topic and was incorrect in my understanding. Keep 'em coming. Your questions lately have been awesome and really educational.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 14, 2011 at 11:18 am
Thanks! FYI I'm now using QotD-sneak-o-meter v2, which uses a logarithmic scale. I had to buy a replacement after my original meter had its needle wrapped around the end-stop by a previous question (quite some time ago now).
This was a very good question, though Steve please don't confuse > 32 processors with an x86 or x64 issue.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
July 15, 2011 at 11:55 am
Good question.
But why call a bit-mask a switch?
Tom
August 29, 2011 at 8:33 pm
Well, I did the same thing as mentioned above. I answered based on my understanding that 64 cpus could be used. I forgot about the affinity64 I/O.
Darn this aging decrepit brain!
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply