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 06, 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 @ 1:49 PM
Points: 32,768, Visits: 14,929
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 06, 2011 11:37 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:39 AM
Points: 12,187, Visits: 9,137
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 07, 2011 1:50 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, April 03, 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 07, 2011 2:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 9:09 AM
Points: 1,337, Visits: 746
Thanks for the question Steve.
Post #1137896
Posted Thursday, July 07, 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 @ 4:15 AM
Points: 3,681, Visits: 4,815
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 07, 2011 5:14 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247
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 07, 2011 6:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:12 PM
Points: 369, Visits: 165
sys.dm_os_memory_nodes exits in sql 2008 and above.
Post #1138033
Posted Thursday, July 07, 2011 6:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 1,621, Visits: 2,031
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 07, 2011 7:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:08 PM
Points: 5,469, Visits: 23,464
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 07, 2011 7:47 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, April 03, 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