I have a few surveys to editorialize but I'd like to kick off another one where you have to run a bit of code and send the results.
For this one I'm interested in how you have your system configured for parallelism, given the number of processor cores and NUMA nodes configured.
For systems using SQL Server 2005 onwards, the following code will work:
[value_in_use] AS [MAXDOP],
COUNT (DISTINCT [parent_node_id]) AS [Nodes],
COUNT (*) AS [Cores]
[status] = 'VISIBLE ONLINE') AS os
[name] = 'max degree of parallelism';
If you have any info on the general workload/workload mix on the server, that would be helpful too.