I applied trace flag 8015 and 8048 to SQL Server on the dl560 and restarted.
The trace flags are in place...
dbcc tracestatus
TraceFlag Status Global Session
8015 1 1 0
8048 1 1 0
Trace flag 8015 has resulted in only one CPU group (parent node id for the schedulers)...
select distinct parent_node_id from sys.dm_os_schedulers
parent_node_id
0
64
Trace flag 8015 has also resulted in a single memory node for the server...
select distinct memory_node_id from sys.dm_os_memory_nodes
memory_node_id
0
64
**** UPDATE by sql_sasquatch 20130426 ****
Seems like interest in trace flag 8015 is starting to bring folks here. See a susequent blog post for a more comprehensive discussion of trace flag 8015 with lotsa links to the Microsoft docuemtnation about SQL Server NUMA support and the consequences of disabling it.
http://sql-sasquatch.blogspot.com/2013/04/startup-trace-flags-i-love.html
**** END UPDATE ****
**** UPDATE by sql_sasquatch 20130810 ****
Finally got around to adding some graphs to explain my interest in disabling NUMA support at the SQL Server layer. Check it out.
http://sql-sasquatch.blogspot.com/2013/08/sql-server-numa-servers-cpu-hotspot.html
**** END UPDATE ****
No comments:
Post a Comment