Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

NUMA Expand / Collapse
Author
Message
Posted Wednesday, July 6, 2011 11:37 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 9:42 PM
Points: 31,036, Visits: 15,466
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
Post #1137820
Posted Wednesday, July 6, 2011 11:37 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:00 AM
Points: 12,962, Visits: 10,734
Nice question, thanks.



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

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1137822
Posted Thursday, July 7, 2011 1:50 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, April 3, 2014 2:04 AM
Points: 633, 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'.
Post #1137856
Posted Thursday, July 7, 2011 2:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
Thanks for the question Steve.
Post #1137896
Posted Thursday, July 7, 2011 5:11 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 2:20 PM
Points: 3,966, Visits: 5,207
Good question, thanks

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1137976
Posted Thursday, July 7, 2011 5:14 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
This applicable to SQL Server 2008 and above. It's not available in 2005 I believe.

http://brittcluff.blogspot.com/
Post #1137980
Posted Thursday, July 7, 2011 6:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:09 AM
Points: 395, Visits: 168
sys.dm_os_memory_nodes exits in sql 2008 and above.
Post #1138033
Posted Thursday, July 7, 2011 6:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:35 AM
Points: 1,825, Visits: 2,175
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
Post #1138037
Posted Thursday, July 7, 2011 7:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:50 PM
Points: 5,322, Visits: 25,235
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
Post #1138109
Posted Thursday, July 7, 2011 7:47 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, April 3, 2014 2:04 AM
Points: 633, Visits: 43
Thank you for your replies.
Post #1138142
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse