Viewing 15 posts - 1 through 15 (of 15 total)
Thanks for all the help guys. I'm going to do a bunch of reading, and maybe a bit of troubleshooting and testing this weekend and I'll let you all know...
March 15, 2013 at 3:59 pm
And less than two minutes later I realize how silly my last post seems.
For anybody finding this thread through google, NUMA (or Non-Uniform Memory Access) definitely has a lot...
March 15, 2013 at 3:32 pm
TheSQLGuru (3/15/2013)
March 15, 2013 at 3:28 pm
Jonathan Kehayias (3/15/2013)
The configuration you are trying to obtain doesn't make sense. With 4 NUMA nodes and 4 instances I would just use ALTER SERVER CONFIGURATION and set the...
March 15, 2013 at 3:15 pm
Production Server\NCR:
affinity mask1414
111153140
221153140
331153140
Development Server\NCR:
affinity mask1414
111153140
221153140
331153140
Production Server\GTA:
affinity mask224224
55124032241
66124032241
77124032241
Development Server\GTA:
affinity mask224224
55124032241
66124032241
77124032241
Production Server\ENT:
affinity mask35843584
9913840335842
101013840335842
111113840335842
Development Server\ENT:
affinity mask35843584
9913840335842
101013840335842
111113840335842
Production Server\DOCINDEX:
affinity mask81928192
1313161440181923
Development Server\DOCINDEX:
affinity mask81928192
1313161440181923
And this is with the settings where if I stop and restart GTA or...
March 15, 2013 at 3:10 pm
TheSQLGuru (3/15/2013)
March 15, 2013 at 2:37 pm
TheSQLGuru (3/15/2013)
March 15, 2013 at 2:35 pm
In SQL Server 2008, SSMS didn't separate things into NUMA nodes at all. It just presented a list of Cores, 0 to 15, one column for Processor Affinity, one for...
March 15, 2013 at 2:23 pm
Jonathan Kehayias (3/15/2013)
My guess without being able to query the system is that you've mixed NUMA nodes in your settings.
This may sound like a rather basic question, but what do...
March 15, 2013 at 1:59 pm
I'll try setting it to default for memory allocation and see if that goes away.
I'm also going to try allocating just processor and not I/O affinity, as that was...
March 15, 2013 at 1:20 pm
Here is the ERRORLOG for DOCINDEX
---
2013-03-15 15:07:27.05 Server Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Enterprise Edition...
March 15, 2013 at 1:11 pm
Sure, I'll get the Errorlog up shortly
March 15, 2013 at 1:04 pm
Okay, I will read up on the Windows System Resource Manager and start the ball rolling to figure out how that works and get it into testing so that we...
March 15, 2013 at 1:02 pm
All four instances are SQL Server 2012 Enterprise
We've configured the affinity like that because these instances used to be completely separate (but much less powerful) servers, and when we negotiated...
March 15, 2013 at 12:48 pm
Just to add some information/confirmation:
I started the DOCINDEX instance in minimal configuration mode using the following command:
"C:\Program Files\Microsoft SQL Server\MSSQL11.DOCINDEX\MSSQL\Binn\sqlserver.exe" -sDOCINDEX -f
Then I connected to the database and ran the...
March 15, 2013 at 12:12 pm
Viewing 15 posts - 1 through 15 (of 15 total)