SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


NUMA


NUMA

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (403K reputation)SSC Guru (403K reputation)SSC Guru (403K reputation)SSC Guru (403K reputation)SSC Guru (403K reputation)SSC Guru (403K reputation)SSC Guru (403K reputation)SSC Guru (403K reputation)

Group: Administrators
Points: 403991 Visits: 20465
Comments posted to this topic are about the item NUMA

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (180K reputation)SSC Guru (180K reputation)SSC Guru (180K reputation)SSC Guru (180K reputation)SSC Guru (180K reputation)SSC Guru (180K reputation)SSC Guru (180K reputation)SSC Guru (180K reputation)

Group: General Forum Members
Points: 180088 Visits: 13357
Nice question, thanks.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
eric_van_uden
eric_van_uden
SSChasing Mays
SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)

Group: General Forum Members
Points: 653 Visits: 43
I may be exposing my ignorance, but is this applicable to SQL server 2008 R2 only?
I get this result in earlier versions of SQL Server:

Invalid object name 'sys.dm_os_memory_nodes'.
paul s-306273
paul s-306273
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6428 Visits: 1336
Thanks for the question Steve.
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSC-Forever
SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)SSC-Forever (43K reputation)

Group: General Forum Members
Points: 43690 Visits: 7842
Good question, thanks

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Britt Cluff
Britt Cluff
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3701 Visits: 253
This applicable to SQL Server 2008 and above. It's not available in 2005 I believe.

http://brittcluff.blogspot.com/
Rafael Krisller
Rafael Krisller
SSChasing Mays
SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)

Group: General Forum Members
Points: 601 Visits: 168
sys.dm_os_memory_nodes exits in sql 2008 and above.
Thomas Abraham
Thomas Abraham
SSCertifiable
SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)SSCertifiable (7K reputation)

Group: General Forum Members
Points: 7001 Visits: 2256
Learned a lot from this question. Had to do a lot of reading to find the answer, as I mostly deal with non-administration side of SQL Server. Thanks for the question Steve.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
bitbucket-25253
bitbucket-25253
SSC-Forever
SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)SSC-Forever (42K reputation)

Group: General Forum Members
Points: 42041 Visits: 25280
The source cited has the following statement:
Nodes are created per physical NUMA memory nodes


But, as it always is, how does one determine the number of soft NUMA nodes?

Anyone.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
eric_van_uden
eric_van_uden
SSChasing Mays
SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)SSChasing Mays (653 reputation)

Group: General Forum Members
Points: 653 Visits: 43
Thank you for your replies.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search