SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


NUMA Node


NUMA Node

Author
Message
TheSQLGuru
TheSQLGuru
SSC-Dedicated
SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)SSC-Dedicated (30K reputation)

Group: General Forum Members
Points: 30500 Visits: 8667
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. Sad

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 on googles mail service
GilaMonster
GilaMonster
SSC Guru
SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)SSC Guru (211K reputation)

Group: General Forum Members
Points: 211721 Visits: 46259
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


Jeremy Brown
Jeremy Brown
Right there with Babe
Right there with Babe (783 reputation)Right there with Babe (783 reputation)Right there with Babe (783 reputation)Right there with Babe (783 reputation)Right there with Babe (783 reputation)Right there with Babe (783 reputation)Right there with Babe (783 reputation)Right there with Babe (783 reputation)

Group: General Forum Members
Points: 783 Visits: 311
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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search