Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

NUMA Node Expand / Collapse
Posted Thursday, September 3, 2009 8:11 AM



Group: General Forum Members
Last Login: Today @ 1:21 PM
Points: 5,674, Visits: 8,201
GilaMonster (9/3/2009)
TheSQLGuru (9/3/2009)
I sure wish there was more information available about NUMA and how SQL Server uses it and how it can affect performance.

There was a whole presentation on NUMA at PASS either 2005 or 2006. It was done by two guys from either the SQL dev team or PSS, I don't have names offhand, but I might be able to find them. If I can, might be worth contacting them, asking if the presentation is publicly available.

That would be nice. I had acquired some insider information from some HP engineers for particular work but it wasn't publicly disseminable (coining a new word there?).


Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #782204
Posted Thursday, September 3, 2009 8:17 AM



Group: General Forum Members
Last Login: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147
I'll dig through old papers. No promises though. If I find the slides I'll mail you the presenters' names.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #782215
Posted Monday, September 30, 2013 8:36 AM


Group: General Forum Members
Last Login: Thursday, March 12, 2015 2:42 PM
Points: 199, Visits: 310
GilaMonster (9/3/2009)
I'll dig through old papers. No promises though. If I find the slides I'll mail you the presenters' names.

Hey Gail, I was just wondering if you ever had a chance to find this info - I'm chasing down a performance issue with stats gathering on a weekend maintenance job and I'm highly suspicious that NUMA configuration is playing a big part in the equation.

On lower lane servers which have 2 - 4 NUMA nodes (distinct memory clerk IDs recognized by SQL Server), stats gathering runs normally using a backup from production - so I know its not "distribution" related. In my production lane it runs slowly but there's only one distinct memory node to work with.

Post #1500034
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse