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 1234»»»

Instance won't start after changing Processor Affinity Expand / Collapse
Author
Message
Posted Friday, March 15, 2013 11:55 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 18, 2013 6:16 AM
Points: 16, Visits: 12
I have a server which I'm trying to setup identically to our running production server and I'm running into issues. The hardware is identical, as follows:

2x 8-Core Opteron 6212
32gb RAM
670GB of Disk Space split 60 C: / 610 E:

OS is Windows Server 2008 R2 Enterprise
SQL Server is 2012 SP1 with rollup (11.0.3128)

The server has four instances installed, across which we're trying to split resources by setting Max RAM and Process/IO Affinity, like this:

\NCR - 8GB, Process on Cores 1,2,3, I/O on Core 4
\GTA - 8GB, Process on Cores 5,6,7, I/O on Core 8
\ENT - 8GB, Process on Cores 9,10,11, I/O on Core 12
\DOCINDEX - 4GB, Process on Core 13, I/O on Core 14

Leaving 4GB, and Cores 0 and 15 free for the OS.

The production server is setup like this and running fine. The development server is fine right up until I change the Process and IO affinity. As soon as I do that and restart the SQL Server Services or the whole box, GTA and DOCINDEX's services will start, then immediately stop.

Since I can't get them started, I end up uninstalling and reinstalling the instance. Then they run fine with no process or IO affinity set. I can change the Max RAM, but if I change the Process or IO affinity again they do the same thing.

I've tried stopping all the SQL services and just turning on DOCINDEX or just turning on GTA, thinking that it might be a problem with resource availability, but they still won't start.

I've even gone as far as reformatting the entire box again from scratch, making sure I follow the procedure I wrote up when I built the production box and run into the same issue.

The system event logs have no helpful information at all. The only event related to the services in question are a bunch of "This is informational" events describing the startup, then one saying "The service has entered the stopped state".

The ERRORLOG has the same lack of information. I can post both if needed.

Help!

Jon
Post #1431662
Posted Friday, March 15, 2013 12:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 18, 2013 6:16 AM
Points: 16, Visits: 12
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 following:
sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'affinity mask', 0x00000000
GO
RECONFIGURE
GO

Which resulted in the following output:
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option 'affinity mask' changed from 8192 to 0. Run the RECONFIGURE statement to install.

Then I stopped the server and restarted it from services.msc . It started and ran with no issues and the process and IO affinity were both set back to automatic.

I changed them back to Process on CPU 13 and IO on CPU 14. I went into services.msc, stopped the service, and upon restart it did the same "The service started then stopped" thing.

So it's DEFINITELY the affinity that's doing this, I just wish I knew why. At least now I have a way to get things working again without having to uninstall and reinstall the whole instance but it's still annoying.
Post #1431669
Posted Friday, March 15, 2013 12:43 PM


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 @ 12:20 PM
Points: 41,529, Visits: 34,445
Are those two instances (the ones failing) SQL Express by any chance?

btw, generally configuring the cores as you tried is not usually a good idea. Those are fairly advanced settings that usually should be left at default unless there's a really, really good reason. If you want to balance the CPU load of the instances, the windows resource manager's a better choice
http://technet.microsoft.com/en-us/library/cc755056.aspx



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 #1431680
Posted Friday, March 15, 2013 12:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 18, 2013 6:16 AM
Points: 16, Visits: 12
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 the purchase of the larger servers with management we had to guarantee that any one instance would not be able to affect the performance of any other instance by encroaching on its resources.

In other words, if someone does something crazy in NCR, it should affect only NCR. It should not be able to max out more than its 3 CPUs or eat up more than its 8gb of RAM.

Is there another way to limit which cores a given instance will use?

Jon
Post #1431684
Posted Friday, March 15, 2013 12:54 PM


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 @ 12:20 PM
Points: 41,529, Visits: 34,445
GilaMonster (3/15/2013)
If you want to balance the CPU load of the instances, the windows resource manager's a better choice
http://technet.microsoft.com/en-us/library/cc755056.aspx


Firstly you can do more granular limits, second, because if the other instances are doing nothing at all, why shouldn't the one get most of the CPU, it's not preventing the others from working, they're idle. If all 4 are working heavily, then the limits kick in.

Can you post the error log of one of the times the startup failed? The entire error log please.

Also, 4GB for the OS might be a little on the low side for a 32 GB server. Monitor, make sure that the available memory (perfmon counter) doesn't drop below 600MB-1GB.



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 #1431689
Posted Friday, March 15, 2013 1:02 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 18, 2013 6:16 AM
Points: 16, Visits: 12
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 can eventually roll to our production environment.

Until that time, I would still really like to find out why I'm able to run this configuration on one server and not the other. Can you offer any assistance, despite the fact that you don't recommend this configuration?
Post #1431695
Posted Friday, March 15, 2013 1:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 18, 2013 6:16 AM
Points: 16, Visits: 12
Sure, I'll get the Errorlog up shortly
Post #1431699
Posted Friday, March 15, 2013 1:05 PM


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 @ 12:20 PM
Points: 41,529, Visits: 34,445
cryovenom (3/15/2013)
Can you offer any assistance, despite the fact that you don't recommend this configuration?


If you post the error log that I asked for, maybe.



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 #1431700
Posted Friday, March 15, 2013 1:11 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 18, 2013 6:16 AM
Points: 16, Visits: 12
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 (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

2013-03-15 15:07:27.05 Server (c) Microsoft Corporation.
2013-03-15 15:07:27.05 Server All rights reserved.
2013-03-15 15:07:27.05 Server Server process ID is 2084.
2013-03-15 15:07:27.05 Server System Manufacturer: 'Supermicro', System Model: 'H8DGG'.
2013-03-15 15:07:27.05 Server Authentication mode is MIXED.
2013-03-15 15:07:27.06 Server Logging SQL Server messages in file 'E:\SQLData\DOCINDEX\MSSQL11.DOCINDEX\MSSQL\Log\ERRORLOG'.
2013-03-15 15:07:27.06 Server The service account is 'STAFFNET\sqladmin'. This is an informational message; no user action is required.
2013-03-15 15:07:27.06 Server Registry startup parameters:
-d E:\SQLData\DOCINDEX\MSSQL11.DOCINDEX\MSSQL\DATA\master.mdf
-e E:\SQLData\DOCINDEX\MSSQL11.DOCINDEX\MSSQL\Log\ERRORLOG
-l E:\SQLData\DOCINDEX\MSSQL11.DOCINDEX\MSSQL\DATA\mastlog.ldf
2013-03-15 15:07:27.06 Server Command Line Startup Parameters:
-s "DOCINDEX"
2013-03-15 15:07:27.40 Server SQL Server detected 2 sockets with 4 cores per socket and 8 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
2013-03-15 15:07:27.40 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2013-03-15 15:07:27.40 Server Detected 32766 MB of RAM. This is an informational message; no user action is required.
2013-03-15 15:07:27.40 Server Using locked pages in the memory manager.
2013-03-15 15:07:27.42 Server Large Page Allocated: 32MB
2013-03-15 15:07:27.43 Server Large Page Allocated: 32MB
2013-03-15 15:07:27.45 Server Large Page Allocated: 32MB
2013-03-15 15:07:27.48 Server Large Page Allocated: 32MB
2013-03-15 15:07:27.97 Server Processor affinity turned on: node 0, processor mask 0x0000000000000000. Threads will execute on CPUs per affinity settings. This is an informational message; no user action is required.
2013-03-15 15:07:27.97 Server Processor affinity turned on: node 1, processor mask 0x0000000000000000. Threads will execute on CPUs per affinity settings. This is an informational message; no user action is required.
2013-03-15 15:07:27.97 Server Processor affinity turned on: node 2, processor mask 0x0000000000000000. Threads will execute on CPUs per affinity settings. This is an informational message; no user action is required.
2013-03-15 15:07:27.97 Server Processor affinity turned on: node 3, processor mask 0x0000000000002000. Threads will execute on CPUs per affinity settings. This is an informational message; no user action is required.
2013-03-15 15:07:27.97 Server I/O affinity turned on, processor mask 0x0000000000004000. Disk I/Os will execute on CPUs per affinity I/O mask/affinity64 mask config option. This is an informational message only; no user action is required.
2013-03-15 15:07:28.07 Server This instance of SQL Server last reported using a process ID of 1412 at 3/15/2013 3:07:21 PM (local) 3/15/2013 7:07:21 PM (UTC). This is an informational message only; no user action is required.
2013-03-15 15:07:28.07 Server Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x0000000000000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-03-15 15:07:28.07 Server Node configuration: node 1: CPU mask: 0x00000000000000f0:0 Active CPU mask: 0x0000000000000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-03-15 15:07:28.07 Server Node configuration: node 2: CPU mask: 0x0000000000000f00:0 Active CPU mask: 0x0000000000000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-03-15 15:07:28.07 Server Node configuration: node 3: CPU mask: 0x000000000000f000:0 Active CPU mask: 0x0000000000002000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2013-03-15 15:07:28.09 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2013-03-15 15:07:28.09 Server Lock partitioning is enabled. This is an informational message only. No user action is required.
2013-03-15 15:10:15.10 Server Failed allocate pages: FAIL_PAGE_ALLOCATION 1
2013-03-15 15:10:15.10 Server
Process/System Counts Value
---------------------------------------- ----------
Available Physical Memory 21823102976
Available Virtual Memory 8747790282752
Available Paging File 37028200448
Working Set 131485696
Percent of Committed Memory in WS 100
Page Faults 44643
System physical memory high 1
System physical memory low 0
Process physical memory low 0
Process virtual memory low 0
2013-03-15 15:10:15.10 Server
Memory Manager KB
---------------------------------------- ----------
VM Reserved 46859968
VM Committed 322916
Locked Pages Allocated 3902916
Large Pages Allocated 215040
Emergency Memory 1024
Emergency Memory In Use 16
Target Committed 4194304
Current Committed 4225832
Pages Allocated 40056
Pages Reserved 0
Pages Free 3830912
Pages In Use 394792
Page Alloc Potential 3589800
NUMA Growth Phase 1
Last OOM Factor 3
Last OS Error 2
2013-03-15 15:10:15.10 Server
Memory node Id = 0 KB
---------------------------------------- ----------
VM Reserved 46761536
VM Committed 224532
Locked Pages Allocated 68876
Pages Allocated 36928
Pages Free 0
Target Committed 293384
Current Committed 293408
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
2013-03-15 15:10:15.10 Server
Memory node Id = 1 KB
---------------------------------------- ----------
VM Reserved 32768
VM Committed 32788
Locked Pages Allocated 1040
Pages Allocated 1040
Pages Free 0
Target Committed 33832
Current Committed 33832
Foreign Committed 0
Away Committed 0
Taken Away Committed 0
2013-03-15 15:10:15.10 Server
Memory node Id = 2 KB
---------------------------------------- ----------
VM Reserved 32768
VM Committed 32788
Locked Pages Allocated 1040
Pages Allocated 1040
Pages Free 0
Target Committed 33832
Current Committed 33832
Foreign Committed 0
Away Committed 3830912
Taken Away Committed 0
2013-03-15 15:10:15.10 Server
Memory node Id = 3 KB
---------------------------------------- ----------
VM Reserved 32768
VM Committed 32788
Locked Pages Allocated 3831960
Pages Allocated 1048
Pages Free 3830912
Target Committed 3833232
Current Committed 3864752
Foreign Committed 8
Away Committed 0
Taken Away Committed 3830912
2013-03-15 15:10:15.10 Server
Memory node Id = 64 KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 20
Locked Pages Allocated 0
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLGENERAL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1088
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLBUFFERPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 12999744
VM Committed 65536
Locked Pages Allocated 132
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLQUERYEXEC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 152
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLOPTIMIZER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1008
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLUTILITIES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLSTORENG (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 536
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLCLR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLSERVICEBROKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 288
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SNI (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SNI (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SNI (node 2) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SNI (node 3) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SNI (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SNI (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLXP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
MEMORYCLERK_XTP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
MEMORYCLERK_HOST (node 3) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SOSNODE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 17968
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SOSNODE (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3352
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SOSNODE (node 2) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3352
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SOSNODE (node 3) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 3544
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SOSNODE (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2424
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SOSNODE (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 30640
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SOSOS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 200
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SOSMEMMANAGER (node 0) KB
---------------------------------------- ----------
VM Reserved 138496
VM Committed 106496
Locked Pages Allocated 31816
SM Reserved 0
SM Committed 0
Pages Allocated 0
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 192
2013-03-15 15:10:15.10 Server
MEMORYCLERK_XE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 376
2013-03-15 15:10:15.10 Server
MEMORYCLERK_SQLLOGPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2072
2013-03-15 15:10:15.10 Server
CACHESTORE_OBJCP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_SQLCP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 1704
2013-03-15 15:10:15.10 Server
CACHESTORE_PHDR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_XPROC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
CACHESTORE_TEMPTABLES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
CACHESTORE_NOTIF (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
CACHESTORE_VIEWDEFINITIONS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
CACHESTORE_XMLDBTYPE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_XMLDBELEMENT (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_XMLDBATTRIBUTE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_STACKFRAMES (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_STACKFRAMES (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_STACKFRAMES (node 2) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_STACKFRAMES (node 3) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_STACKFRAMES (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_STACKFRAMES (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40
2013-03-15 15:10:15.10 Server
CACHESTORE_BROKERTBLACS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
CACHESTORE_BROKERKEK (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_BROKERDSH (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_BROKERUSERCERTLOOKUP (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_BROKERRSB (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_BROKERREADONLY (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 32
2013-03-15 15:10:15.10 Server
CACHESTORE_BROKERTO (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
CACHESTORE_EVENTS (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
CACHESTORE_SEHOBTCOLUMNATTRIBUTE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 128
2013-03-15 15:10:15.10 Server
CACHESTORE_COLUMNSTOREOBJECTPOOL (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 128
2013-03-15 15:10:15.10 Server
CACHESTORE_XML_SELECTIVE_DG (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
USERSTORE_SCHEMAMGR (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 152
2013-03-15 15:10:15.10 Server
USERSTORE_TOKENPERM (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 168
2013-03-15 15:10:15.10 Server
USERSTORE_SXC (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
USERSTORE_SXC (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
USERSTORE_SXC (node 2) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
USERSTORE_SXC (node 3) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
USERSTORE_SXC (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 8
2013-03-15 15:10:15.10 Server
USERSTORE_SXC (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 40
2013-03-15 15:10:15.10 Server
OBJECTSTORE_SNI_PACKET (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2013-03-15 15:10:15.10 Server
OBJECTSTORE_SNI_PACKET (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2013-03-15 15:10:15.10 Server
OBJECTSTORE_SNI_PACKET (node 2) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2013-03-15 15:10:15.10 Server
OBJECTSTORE_SNI_PACKET (node 3) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2013-03-15 15:10:15.10 Server
OBJECTSTORE_SNI_PACKET (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 56
2013-03-15 15:10:15.10 Server
OBJECTSTORE_SNI_PACKET (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 280
2013-03-15 15:10:15.10 Server
OBJECTSTORE_SERVICE_BROKER (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 368
2013-03-15 15:10:15.10 Server
OBJECTSTORE_LOCK_MANAGER (node 0) KB
---------------------------------------- ----------
VM Reserved 16384
VM Committed 16384
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 648
2013-03-15 15:10:15.10 Server
OBJECTSTORE_LOCK_MANAGER (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 648
2013-03-15 15:10:15.10 Server
OBJECTSTORE_LOCK_MANAGER (node 2) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 648
2013-03-15 15:10:15.10 Server
OBJECTSTORE_LOCK_MANAGER (node 3) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 648
2013-03-15 15:10:15.10 Server
OBJECTSTORE_LOCK_MANAGER (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 24
2013-03-15 15:10:15.10 Server
OBJECTSTORE_LOCK_MANAGER (Total) KB
---------------------------------------- ----------
VM Reserved 16384
VM Committed 16384
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 2616
2013-03-15 15:10:15.10 Server
OBJECTSTORE_XACT_CACHE (node 0) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
OBJECTSTORE_XACT_CACHE (node 1) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
OBJECTSTORE_XACT_CACHE (node 2) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
OBJECTSTORE_XACT_CACHE (node 3) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
OBJECTSTORE_XACT_CACHE (node 64) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 16
2013-03-15 15:10:15.10 Server
OBJECTSTORE_XACT_CACHE (Total) KB
---------------------------------------- ----------
VM Reserved 0
VM Committed 0
Locked Pages Allocated 0
SM Reserved 0
SM Committed 0
Pages Allocated 80
2013-03-15 15:10:15.10 Server
Buffer Pool Value
---------------------------------------- ----------
Database 0
Simulated 0
Target 65503232
Dirty 0
In IO 0
Latched 0
Page Life Expectancy 167
2013-03-15 15:10:15.10 Server
Memory Pool Manager Pages
---------------------------------------- ----------
Reserved Current 0
Reserved Limit 474920
2013-03-15 15:10:15.10 Server
Memory Pool (internal) Pages
---------------------------------------- ----------
Allocations 49368
Predicted 97702
Private Target 0
Private Limit 0
Total Target 524288
Total Limit 524288
OOM Count 0
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_CACHE (internal) Pages
---------------------------------------- ----------
Allocations 998
Rate 4587
Target Allocations 337189
Future Allocations 0
Overall 425984
Last Notification 1
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_STEAL (internal) Pages
---------------------------------------- ----------
Allocations 4013
Rate 12480
Target Allocations 348097
Future Allocations 0
Overall 425984
Last Notification 1
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_RESERVE (internal) Pages
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 331604
Future Allocations 0
Overall 425984
Last Notification 1
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_COMMITTED (internal) Pages
---------------------------------------- ----------
Allocations 44355
Rate 31258
Target Allocations 407217
Future Allocations 0
Overall 425984
Last Notification 1
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_XTP (internal) Pages
---------------------------------------- ----------
Allocations 2
Rate 9
Target Allocations 331615
Future Allocations 0
Overall 425984
Last Notification 1
2013-03-15 15:10:15.10 Server
Memory Pool (default) Pages
---------------------------------------- ----------
Allocations 0
Predicted 94982
Private Target 0
Private Limit 0
Total Target 524288
Total Limit 524288
OOM Count 0
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_CACHE (default) Pages
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 331604
Future Allocations 0
Overall 425984
Last Notification 1
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_STEAL (default) Pages
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 331604
Future Allocations 0
Overall 425984
Last Notification 1
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_RESERVE (default) Pages
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 425984
Future Allocations 94848
Overall 425984
Last Notification 1
2013-03-15 15:10:15.10 Server
MEMORYBROKER_FOR_XTP (default) Pages
---------------------------------------- ----------
Allocations 0
Rate 0
Target Allocations 331604
Future Allocations 0
Overall 425984
Last Notification 1
2013-03-15 15:10:15.12 Server Exception raised in Startup::CommunicationsManager.
Post #1431705
Posted Friday, March 15, 2013 1:16 PM


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 @ 12:20 PM
Points: 41,529, Visits: 34,445
2013-03-15 15:10:15.10 Server Failed allocate pages: FAIL_PAGE_ALLOCATION 1


That's memory related, might have something to do with the NUMA node configuration, not sure though.
Going to have to consult an expert on this one. Let me see if I can find someone awake at this hour of a Friday.



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 #1431709
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse