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 Node Expand / Collapse
Author
Message
Posted Thursday, September 3, 2009 8:11 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:19 AM
Points: 4,320, Visits: 6,113
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?).


Best,

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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 42,464, Visits: 35,527
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 2008, MVP
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
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, May 4, 2014 10:21 PM
Points: 202, Visits: 307
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