May 26, 2008 at 10:39 am
Here is part of the output of DBCC MEMORYSTATUS on my SQL 2005 instance.
Does this mean my system is NUMA-enabled? There are 2 nodes displayed.
Memory Manager KB
------------------------------ --------------------
VM Reserved 1773596
VM Committed 101948
AWE Allocated 6291456
Reserved Memory 1024
Reserved Memory In Use 0
(5 row(s) affected)
Memory node Id = 0 KB
------------------------------ --------------------
VM Reserved 4992
VM Committed 34056
AWE Allocated 3069704
MultiPage Allocator 4696
SinglePage Allocator 168296
(5 row(s) affected)
Memory node Id = 1 KB
------------------------------ --------------------
VM Reserved 1764444
VM Committed 63880
AWE Allocated 333304
MultiPage Allocator 11816
SinglePage Allocator 168296
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 27, 2008 at 9:01 pm
May the following link help.
May 28, 2008 at 8:10 am
Thank you for the response and link. That link was actually what prompted my opening post.
Any info on NUMA architecture as it relates to SQL Server performance?
Any experiences anyone wishes to share?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply